›

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Quick Links

Categories

Zero change days on weekends

dmorley64dmorley64
in General
Recently, when I look at the Daily tab, I am seeing the market closed days (weekends and Holiday) reported as zero in the Daily Capital Gain/Loss chart and the Last 12 Days value table (I am still using 2.4.08). While technically this is correct, I am pretty sure these days never used to show up.

I checked Quotes.csv and each symbols quote.txt file and there are no weekend values in either of those files.

Did something change in Excel perhaps, or did I change something?




Thanks

Comments

  • VidasMatelisVidasMatelis
    Weekend day should not be included and I confirmed that previously they were not included, so I am not sure what changed. I checked v3 and weekend dates in Daily tab are not included.
    But about a month ago there was new script released that changed how quotes are received from Yahoo, so I suspect that might have introduced some side effect.

    Even you said that in Quotes.csv there are no quotes for weekend, can you please double check that again - could you please open quotes.csv file in the notepad and do a search for weekend day, for example search for string 2014-05-25

  • dmorley64dmorley64
    I double checked quotes.csv by searching as you suggested, and I think I have found the reason why this is happening. A short while ago, I invested in various crypto currencies. I added the crypto symbols to my existing config.txt. UpdatePSData.bat auto runs once a day, even on weekends, and crypto trades 7/24 so there is always weekend data in quotes.cvs for the crypto symbols even though there is no weekend data for my ETFS.

    I have a separate spreadsheet for my crypto investment than my RRSPs, but I guess because there is data on the weekend for some symbols in quotes, it then causes these zero value days in my RRSP spreadsheet.

    I will have to re-think how to do this, as I dont like the weekend zero values in my RRSP spreadsheet. Please let me know what you think is the best way to handle this.

    Thanks

  • VidasMatelisVidasMatelis
    If you will have symbols that have quotes on the holidays/weekends, then with current code you will see calculated values on these days. Maybe try disabling updatePSData.bat not to run on the weekend, but still next Monday if quotes are available for weekend, then they will be picked up. I think you will have to learn living with weekend calculations.
Sign In or Register to comment.