Custom Series Value Error

I have a custom series: UnivAvg(“TRUE”,“Pr13W%Chg”) using the Dow as the Universe. Today I run the totals and get -2.99 as the value.

However, when I use the Custom Series in a screen I get a value of -.05, also using the Dow as the Universe and same run date.

ShowVar(@Avg,close(0,GetSeries(“Univ13wkRet”)))//Custom Series
SetVar(@Group,Close(0)>9.99)
ShowVar(@UniAvg13W%Chg,Aggregate(“Pr13W%Chg”, #GroupVar, #Avg,0))//Custom Average On Screen Universe

This is the output:

No Ticker Name Last MktCap @Avg @UniAvg13W%Chg
1
AAPL[5D][1Y] Apple Inc 124.50 710,322.31 -0.05 -2.99
2
AXP[5D][1Y] American Express Co 75.90 76,051.80 -0.05 -2.99
3
BA[5D][1Y] Boeing Co 144.06 98,114.52 -0.05 -2.99 ETC…
I have computed the average return in Excel and it matches -2.99

BTW, this mismatched value error occurs on all my GetSeries calls in screener. Any help is appreciated…



I got it to work.Not sure how to reproduce the problem, which is very important.

The recalculation of a custom series tries to be efficient and only recalculate a series if the date needed is not available. -.05 is a data point for previous weekend so somehow the custom series was not being updated when called from the screener. Daily vs Weekly custom series might have been the cause , but I’m not sure. After a few UPDATES in the custom series I got the screener to show the right value.

I’ll do some more testing tomorrow to see if I can reproduce.

Thank you Marco. Indeed I can get a matching value from the above: -2.99 after running the screen a few times.

But when I add this series to check : ShowVar(@D1,Close(0,GetSeries(“Inst1”))) the error is there again. In Custom Series the value is -3.44, but when I add to the screen above I get -.99.

I’m wondering if how I use P123 may be an issue. I often will have multiple tabs open so I can bounce back and forth between parts of the service, such as screener open and in another tab custom series might be open, though I do make sure to save before switching tabs. I just tried to do everything from one tab however and still get the error.

Also, any way you can delete the first image which shows my categories?? I can’t find a way to do it myself.

Thanks for the help, we’ll see what tomorrow brings…

Marco, there must be something you did on the back end to fix the Dow value. I still can’t get accuracy from any of my other GetSeries calls.

Seems to me based on your response that the Custom Series engine is not updating: “The recalculation of a custom series tries to be efficient and only recalculate a series if the date needed is not available.

Marco, I figured it out. The error occurred because of the frequency set in the chart tab. It defaults to weekly, when I changed it to daily, the numbers matched up.

Who would think to look in a chart tab to set data frequency for a formula?

Thanks for the help…