Scripts In Watchlist Displaying Zeros

Optuma Scripting
1

Hi,

I am having an issue with scripts in a watchlist displaying as 0. Attached is a PDF with screenshots explaining what is going on. Thank you for investigating.

Optuma.pdf (293 KB)

2

By default, a watchlist will load only 1 years worth of data. If scripts require more history than that you need to go to the Watchlists properties panel and adjust the Date Range to Everything.

Ex1

If the values remain as zero once that’s done please attach the workbook itself for review.

3

Hi Matthew,

I updated the Date Range field to Everything. The rows are still showing zeros. Please see the attached workbook. Thank you.

SP_RS.owb (180 KB)

4

Hi,

When I open the workbook all values in the Watchlist load ok. I suspect you may be missing some historical data for the codes.

If you open a chart do you see a full set of data, or is it only a limited amount?

I’d suggest running through Option 3 here for the S&P Indices exchange to ensure you have all available data for the codes in the WL:

https://help.optuma.com/kb/faq.php?id=793

5

Following option 3 fixed the issue completely. Thank you for helping me!

6

Hi Matthew,

Sorry to bother, but the last column has reverted back to all zeros!

Originally I had linked excel lists to the watchlists. I made changes to the excel file, not to the sheet with the symbols but a different sheet in the workbook, and that messed up the watchlists in Optuma. I went back and created manual lists and relinked them to the watchlists. All three of the scripts are working, but the final column that averages two of the scripts has stopped working. The date range of the watchlist is still set to everything. I even scripted them again. Please have a look at this workbook to see why the ASC_Intermediate&LongTermRS script has stopped working in all of the watchlists. I would appreciate that. Thank you very much.

SP_RS-1.owb (180 KB)

7

Thanks Louis. Will have to investigate further, but in the meantime use this combined script:

//Define the variables
V1 = ROC(Week(PERIODAMOUNT=1), BARS=6);
V2 = ROC(Week(PERIODAMOUNT=1), BARS=8);
V3 = ROC(Week(PERIODAMOUNT=1), BARS=13);
V4 = ROC(Week(PERIODAMOUNT=1), BARS=26);
V5 = ROC(Week(PERIODAMOUNT=1), BARS=39);
V6 = ROC(Week(PERIODAMOUNT=1), BARS=52); 
//Average the variables
(V1 + V2 + V3 + V4 + V5 + V6)/6

If you are interested in Rate of Change momentum you may wish to take a look at Martin Pring’s Know Sure Thing indicator:

https://help.optuma.com/kb/faq.php?id=994

8

Hi Darren. Thank you for this script. It’s working well. Pring’s KST and Special K sure are interesting! Louis

9

Hi,

The last column in the Watchlist was blank as the scripts being referenced contained a time frame override, but the script functions themselves did not. In this scenario, if you applied the same script to the chart you’d see this causes the output to show only a value on Fridays. All other days are zero.

To resolve this, you need to use a time frame override on the Script() functions as well, once that is done the expected result is returned.

Adjusted script…

//Set Variables
V1 = SCRIPT(Week(PERIODAMOUNT=1), SCRIPTNAME=ASCIntermediateTermRS) ; 
V2 = SCRIPT(Week(PERIODAMOUNT=1), SCRIPTNAME=ASCLongTermRS) ;

//Average the variables
(V1 + V2)/2

Here is how it looks on the chart (original script) vs Watchlist (updated script).

Ex2