After you encountered this error - please do not run script anymore. Can you please post here from Script\Log\GetQuotes-Yahoo.txt. Just need lines if they report any error and lines related to AAPL extract.
For everybody who are still planning to run script - please backup Quotes folder before your run.
@dinotuf - I believe that you might be from the region, where Yahoo returns numbers with a dot instead of a comma. Please do following. 1. Fix files in your quotes folder - remove all records with incorrect data. 2. Backup your Quotes folder in case updated scripts do not fix the issue. 3. Go to download page and get new version (2024-09-12!). If you do not see new version download, you might have to do CTRL+F5 to refresh cash. 4. Extract updated 2 scripts 5. Run scripts and test if your issue is fixed.
A big thank you to @newuser for sharing your scripting knowledge to resolve the issue and to Vidas for co-ordinating the testing etc to keep this project back on track.
I ran the new scripts and the quotes are working, but for some reason I keep getting the below error. Not sure if others are experiencing it?
Below is the output from the log.
15:24:19 --- Starting script GetExchRates-YahooIntraday.ps1
Currency count: 2. MinDate: 2006-12-29
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/GBPUSD=X?period1=1726099200&period2=1726185599&interval=1d&events=history&crumb=@CRUMB@
- Not Found (web err)
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/USDGBP=X?period1=1726099200&period2=1726185599&interval=1d&events=history&crumb=@CRUMB@
- Not Found (web err)
15:24:20 --- Finished. CurrExch Requested/Succeed/Failed/Used: 2/0/2/0. Duration: 2 sec.. Date-Time:
@MikeP - This error in GetExchRates-YahooIntraday is very old bug and has no impact. But if you download latest scripts (just published few min ago), you can also get that script and update on your computer and this error should go away.
I replaced all the scripts from the latest version. But same issue for the Currency Intraday quote file is not being created.
I used the URL https://query1.finance.yahoo.com/v7/finance/download/GBPUSD=X?period1=1726099200&period2=1726185599&interval=1d&events=history&crumb=@CRUMB@
Getting the same JSON unauthroized error, I think this script also needs to be modified.
Thanks @VidasMatelis and @newuser for all your work on fixing this. I've backed up entire folder, downloaded new scripts and put the 2 new Yahoo ones into my folder structure. Historical data is now working, however Intraday is not. I get the below error when running UpdatePSD.bat. After running this, the QuotesIntraDay folder is empty.
Thank you @VidasMatelis and @newuser for your work in updating the scripts so quickly. The historical data works great, and I still use v2.4. I experienced the same as @scope11, with the intraday script producing no rows. Also, about half my stocks pay dividends, so it would be helpful to have the Yahoo Dividends script updated, if possible. PortfolioSlicer has been an extremely useful tool and I appreciate that is is free. Thanks again.
@scope11: Please download updated scripts and replace your old scripts. Latest script on Download page is : v3_20240913 (2024-Sep-13). If you do not see that, you might need to refresh your browser, likely press CTRL+F5
It appears that you updated .bat file with v3 files and now executing scripts that you should not be executing. Can you restore your v2 .bat files? Link to download old v2 scripts: http://www.portfolioslicer.com/download/v2.4/PortfolioSlicerDDMScriptsV2.4.18.zip Then replace .ps1 file with files from v3 scripts. Do not replace psConfig.txt file
Comments
Can you please post here from Script\Log\GetQuotes-Yahoo.txt.
Just need lines if they report any error and lines related to AAPL extract.
For everybody who are still planning to run script - please backup Quotes folder before your run.
I now have found them, thank you for the updates
Please do following.
1. Fix files in your quotes folder - remove all records with incorrect data.
2. Backup your Quotes folder in case updated scripts do not fix the issue.
3. Go to download page and get new version (2024-09-12!). If you do not see new version download, you might have to do CTRL+F5 to refresh cash.
4. Extract updated 2 scripts
5. Run scripts and test if your issue is fixed.
I ran the new scripts and the quotes are working, but for some reason I keep getting the below error. Not sure if others are experiencing it?
Below is the output from the log.
I used the URL
https://query1.finance.yahoo.com/v7/finance/download/GBPUSD=X?period1=1726099200&period2=1726185599&interval=1d&events=history&crumb=@CRUMB@
Getting the same JSON unauthroized error, I think this script also needs to be modified.
Edit to add: Using V3
Log File - GetQuotes-YahooIntraday.txt is like below for every symbol.
Symbol: VT. Next date: 2024-09-13. Quote file: C:\Users\Russ\OneDrive\Documents\Personal\Financial\Investments\PortfolioSlicerV3.0.0\Russ V2\PSDataExtract\Quotes\_VT_.txt
Requesting url: https://query2.finance.yahoo.com/v8/finance/chart/VT?period1=1726185600&period2=1726271999&interval=1d&events=history&includeAdjustedClose=true&crumb=
Done: VT. No new quotes found.
Latest script on Download page is : v3_20240913 (2024-Sep-13).
If you do not see that, you might need to refresh your browser, likely press CTRL+F5
I am using v2, tried updating the script with the new version provided and i am now getting weird errors:
anyone can help ? I am completly lost...
Thanks in advance!
Can you restore your v2 .bat files?
Link to download old v2 scripts: http://www.portfolioslicer.com/download/v2.4/PortfolioSlicerDDMScriptsV2.4.18.zip
Then replace .ps1 file with files from v3 scripts.
Do not replace psConfig.txt file