Error in HighVal() used in a custom series -> does not update every day in "Rules" but does so in "Chart"

Report a problem or error
1

Hi all,

I was recreating the Hi-Lo Index introduced by Georg several years ago I am observing some strange results when using HighVal.
I was struggling to get the same values as his post so I dug a little further.

Public custom series here → https://www.portfolio123.com/app/series/summary/9418?st=0&mt=8

Pls see the screenshots attached.
When using HighVal:

  • The Rules section of the custom series only seems to update every Saturday (??)
  • The Chart section correctly updates every day
  • The Screener also updates correctly every day

How come the Rules section of the custom series only updates weekly?
Or did I miss something?

I used the close of Amazon:

  • It made a high of 2012.71 on 31 Aug 2018 followed by a new high of 2039.51 on 04 Sept 2018.
  • So on 04 Sept 2018 and beyond, highval(63,0,#close) should be 2039.51 (lookback circa 3 months = 63 bars)
  • It only becomes so on Sat 08 Sept

Many thanks,

Jerome

HighVal issue.pdf (415 KB)

2

I’ve changed the behavior to respect chart frequency, which is not currently included in this particular request; until the next server release wherein the frequency option will be visible on the rules page, it will only show daily values. The behavior has also been revised to always use Saturday fundamentals instead of current fundamentals if run with a current date.
Thanks for raising the issue.

3

Hi Aaron,

Many thanks for your prompt action.
I am not completely sure I understand the end-state (after the next release) as you describe it.
Also because you mention fundamental whereas my example above only uses price points…

  1. In the example I gave above where the chart frequency is set to “daily”:
  • the chart is currently correct (the last daily value is correct and matches the one from the screener)
  • the rules section is not correct (it only updates weekly on Saturdays)

→ Will the rules section be updated daily and therefore match both the chart and the screener?

  1. If the above example had the chart frequency set to weekly:
    → the rules section would be the same as it is today (i.e. would update the values every Saturday)
    → the chart section would also only update its value on Saturday

  2. I just noticed something else that puzzles me:

  • Take this private custom series using Beta3Y: https://www.portfolio123.com/app/series/summary/5024?st=1&mt=8
  • Watch out! it is live so pls do not change it - even if you can
  • Frequency is set to weekly → chart is updated weekly (this is OK) → latest value = 1.01 from last Saturday 01 Dec
  • However, the value provided by the rules section seems to be able to calculate a daily value → latest value using 06Dec in the date selector on top = 1.12. I have to select Sat 01 Dec to get 1.01.

→ So ironically, on a freq set to weekly, I can access a value updated daily in the rules section (using the fundamental datapoint Beta3Y).
But with a freq set to daily (as in my example in point 1 above), I cannot at the moment access a value updated daily in the rules section (using only price points and no fundamental data)

What will it be in the future? Is there an intention to treat fundamental data points differently than price points?

  1. when is the next release? (approx)

Many thanks,

Jerome

4

bump

5

The intended behavior is to match custom series chart values for any “As Of” input to give intuitive output.
Anything that seems to contradict that is either still broken or will be addressed by the new server. I’ll see if we can’t get you the new server later today. I’ll review what you’ve noted and see what more there is to be done.

6

Thank you Aaron - I understand your logic in terms of the desired end-result.