Hi,
I have created the script
RIC(DATESEL=User Defined, START_DATE=2020-02-19, ZEROBASED=True, INDEX=SPX:WI)/100
Using a watch list I got for Apple (AAPL) the value 3.59% for 2020/03/10.
My manual calculation:
On 2020/02/19 the closing value of Apple was 323.62
On 2020/03/10 the closing value of Apple was 285.34
This is a decline of 11.828%
On 2020/02/19 the closing value of the S&P 500 was 3,386.15
On 2020/03/10 the closing value of the S&P 500 was 2,882.23
This is a decline of 14.881%
The difference between 14.881% and 11.828% is 3,053%
Please give me some explanation why the watch list script shows the value of 3.59% whereas my manual calculation shows a value of 3.053%?
Another question:
In the watch list on Twitter ((https://twitter.com/Optuma/status/1235863994289643520) there is a column named “Since 2/19”.
I have tried to create a script calculating the %-change of some indices and stocks since 02/19, too.
But my scripts didn’t work. I have tried using the StringDate function to set the start date to 2020/02/19 and the Change() and the Change Since Signal function but nothing worked.
Can you give me please the script for the column “Since 2/19” as used in the Twitter screen shot?
Thank you really very much for your help.
Thomas