OmniTrader Forum OmniTrader Forum
forums calendars search
today this week
 
register logon control panel Forum Rules
You are currently browsing as a guest.
You should logon to access more features
A Self-Moderated Community - ALL MEMBERS, PLEASE READ!
Vote for Members who contribute the most to your trading, and help us moderate content within the Forums.


Only Forum Moderators, Administrators, and the owner of this message may delete it.

 
jpb

Veteran
1002525
Posts: 168

Joined: 5/11/2005
Location: Brown Deer, WI

User Profile
 
Subject : RE: Using Fundamentals as a Sort Value not working
Posted : 1/24/2020 12:55 PM
Post #46657 - In reply to #46633

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.
Deleting message 46657 : RE: Using Fundamentals as a Sort Value not working


Nirvana Systems
For any problems or issues please contact our Webmaster at webmaster@nirvsys.com.