| Index | Recent Threads | Who's Online | User List | Search |
|
|
 |
Portfolio123 » List all forums » Forum: Data related issues » Thread: NA's |
|
Total posts in this thread: 14
|
[Request a Feature]
[Post new Thread] [Add To My Favorites] [Watch this Thread] |
| Author |
|
|
charles123
Advanced Member
|
What is the reason for the high number of NA's? Using the screener and screening for SalesTTM, CFTTM, etc. and setting these equal to NA there are hundreds of stocks returned even when opting to use previous quarter data for NA's. |
||
|
|
chasfiji
Advanced Member
|
We have placed a question into Reuters. ---------------------------------------- Portfolio123 Staff |
||
|
|
charles123
Advanced Member
|
Any word from Reuters yet? |
||
|
|
chasfiji
Advanced Member
|
Reuters response: "This may take some time to review the many instances you have provided. I am actively pursuing an answer with our data team and will contact you within two days with a further update or resolution to this query. If you have any questions or concerns in the mean time, please do not hesitate to let me know." ---------------------------------------- Portfolio123 Staff |
||
|
|
chasfiji
Advanced Member
|
Comment from Reuters: Reuters has found an issue of how they are calculating cash flow per share TTM. They are reviewing about 1400 companies to verify the issue and correct it. They will be updating us tomorrow. ---------------------------------------- Portfolio123 Staff |
||
|
|
charles123
Advanced Member
|
Thanks for the update. There is an issue with other factors as well, such as Pr2SALESTTM. I come up with hundreds of companies with NA even with selecting previous quarter fill-in. This appears to be more than a TTM cashfolw caluculation issue. |
||
|
|
chasfiji
Advanced Member
|
SalesTTM is generated when these conditions are met: 1) at least 4 quarters or 2 semi-annuals reported by the company 2) should not be any hybrid period in the latest 4 quarters (e.g. - Japanese ADRs, the companies report in 3M, 6M, 9M, & 12M formats. 3) should not be a year end change 4) company should have reported Revenues Two Examples: BHP (ADR) - does not have quarterlies Softbank - presentation in semi-annual periods is different from the third quarter; therefore, the third quarter 9 month numbers have been not broken further in 3 months I would this resolves some of your questions. The database, which we are working on will resolve an issue like this one. ---------------------------------------- Portfolio123 Staff |
||
|
|
charles123
Advanced Member
|
Thank you. Makes more sense now. I would be nice to see this resolved in the future. I am assuming the same criteria or similar apply to CFTTM. |
||
|
|
chasfiji
Advanced Member
|
For CashFlPSTTM, it is not necessarily the same because there are many more line items that are combined into a single factor. If one line item is missing, it should, in theory, be able to calculate the factor. ---------------------------------------- Portfolio123 Staff |
||
|
|
charles123
Advanced Member
|
Do you mean because of the various line items it should "NOT" be able to calculate the factor if one line item is missing? |
||
|
|
[Show Thread Printable Version] [Post new Thread] |
