September 1, 2021 at 8:18 am #65797
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.September 1, 2021 at 8:23 am #65800
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.
If the values remain as zero once that’s done please attach the workbook itself for review.September 1, 2021 at 9:17 am #65803
I updated the Date Range field to Everything. The rows are still showing zeros. Please see the attached workbook. Thank you.September 1, 2021 at 9:49 am #65806
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:September 1, 2021 at 10:07 am #65807
Following option 3 fixed the issue completely. Thank you for helping me!September 1, 2021 at 12:17 pm #65811
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.September 1, 2021 at 7:39 pm #65827Darren
- Topics: 70
- Replies: 829
- Posts: 899
Thanks Louis. Will have to investigate further, but in the meantime use this combined script:1234567891011//Define the variablesV1 = 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:September 2, 2021 at 2:43 am #65833
Hi Darren. Thank you for this script. It’s working well. Pring’s KST and Special K sure are interesting! LouisSeptember 2, 2021 at 8:07 am #65839
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…12345678//Set VariablesV1 = 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).
- You must be logged in to reply to this topic.