jpb![]() Veteran ![]() ![]() ![]() Posts: 168 Joined: 5/11/2005 Location: Brown Deer, WI ![]() | Steve, I totally agree with you. Thank you for posting this thread. I was experiencing exactly what you were seeing but I hadn't noticed that when I did get results that they were the wrong results. So, thank you for your research. Similar to you, I was trying to use Fundamentals from the Fund button in the Sort Value area. I went further to blend this with Technicals. CASHFLW/(SHRS*C+(SHRS*C*DEBTEQ-CASHEQ)) That's my shot at a Magic Numbers formula. Interestingly, all the components but SHRS is available via the Tech button (found in the Fundamental section, just like your EPS). So, that put me on a journey to see, "can I derive SHRS from any of the other Fundamental data"... (NETINC / EPS) While not perfect, it will have to do. So, my formula becomes: CASHFLW/((NETINC / EPS)*C+((NETINC / EPS)*C*DEBTEQ-CASHEQ)) Unfortunately OT doesn't like this. It complains with "Error 3061: Too few parameters. Expected 1.." Trying a number of different methods to get past this, including: CASHFLW() / (( NETINC() / EPS())* C + (( NETINC() / EPS())* C * DEBTEQ() - CASHEQ())) With no luck. So, now I've converted it to pure "Technical" formulas and OT/OmniScan isn't happy. I'll post a solution if I find one. Suggestions? On the topic of Dynamic lists, I don't agree that just because a value is quarterly that this should inhibit the use and prevent the creation of a Dynamic list. It may mean your list won't change for a full quarter, but that would be the same if you walked forward from that point in time. I suspect the problem is how OmniScan stores data and isn't carrying slowly changing data along with the faster changing daily data to conduct an efficient scan and allow for a Dynamic list to be created. As you can see from the formula I posted above, I'm fully aware that some data (Cashflw, CashEQ, DebtEQ) are slowly changing numbers, and Shares, even slower, but Close is "fast" which will give me a different number every day. So, a Dynamic list could be calculated every day and be different. |