Error updating from Yahoo since 2019-02-23

patr0kxxx

Getting error upating since 2019-02-23, here an extract from GetQuotes-Yahoo.txt

-------------
10:31:32 --- Starting script GetQuotes-Yahoo.ps1
Symbol count: 9. MinDate: 2009-12-31
Symbol: ^GSPTSE. Next date: 2019-02-23. Quote file: C:\Investing\v24\Data\Quotes\__GSPTSE_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/^GSPTSE?period1=1550880000&period2=1551090696&interval=1d&events=history&crumb=rGE7QsQs7EU
^GSPTSE - Not Found (web err)

Symbol: ^GSPC. Next date: 2019-02-23. Quote file: C:\Investing\v24\Data\Quotes\__GSPC_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/^GSPC?period1=1550880000&period2=1551090696&interval=1d&events=history&crumb=rGE7QsQs7EU
^GSPC - Not Found (web err)

Symbol: VT. Next date: 2019-02-23. Quote file: C:\Investing\v24\Data\Quotes\_VT_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/VT?period1=1550880000&period2=1551090696&interval=1d&events=history&crumb=rGE7QsQs7EU
VT - Not Found (web err)

Symbol: VUN.TO. Next date: 2019-02-23. Quote file: \Investing\v24\Data\Quotes\_VUN.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/VUN.TO?period1=1550880000&period2=1551090696&interval=1d&events=history&crumb=rGE7QsQs7EU
VUN.TO - Not Found (web err)

Symbol: VIU.TO. Next date: 2019-02-23. Quote file: \Investing\v24\Data\Quotes\_VIU.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/VIU.TO?period1=1550880000&period2=1551090696&interval=1d&events=history&crumb=rGE7QsQs7EU
VIU.TO - Not Found (web err)

Symbol: VEE.TO. Next date: 2019-02-23. Quote file: C:\Investing\v24\Data\Quotes\_VEE.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/VEE.TO?period1=1550880000&period2=1551090696&interval=1d&events=history&crumb=rGE7QsQs7EU
VEE.TO - Not Found (web err)

Symbol: VCN.TO. Next date: 2019-02-23. Quote file: C:\Investing\v24\Data\Quotes\_VCN.TO_.txt
Requesting url: https://query1.finance.yahoo.com/v7/finance/download/VCN.TO?period1=1550880000&period2=1551090696&interval=1d&events=history&crumb=rGE7QsQs7EU
VCN.TO - Not Found (web err)

10:31:37 --- Finished. Quotes Requested/Succeed/Failed/Rows: 9/0/9/0. Duration: 6 sec.
-------------


A manual fetch of the query1.finance.yahoo.com URL's result in:
{
"finance": {
"error": {
"code": "Unauthorized",
"description": "Invalid cookie"
}
}
}

Maybe yahoo modified their API's ?

patr0kxxx

Managed to fix the invalid cookie error, now getting this:

13:49:24 --- Starting script GetQuotes-YahooIntraday.ps1
Symbol count: 9. MinDate: 2009-12-31
Symbol: ^GSPTSE. Next date: 2019-02-23. Quote file: C:\Investing\v24\Data\Quotes\__GSPTSE_.txt
Requesting url: https://finance.yahoo.com/quote/^GSPTSE
** For Symbol: ^GSPTSE new quotes not found (there is no 'D(ib)" data-reactid="35">' in html that came back)

Symbol: ^GSPC. Next date: 2019-02-23. Quote file: C:\Investing\v24\Data\Quotes\__GSPC_.txt
Requesting url: https://finance.yahoo.com/quote/^GSPC
** For Symbol: ^GSPC new quotes not found (there is no 'D(ib)" data-reactid="35">' in html that came back)

Symbol: VT. Next date: 2019-02-23. Quote file: C:\Investing\v24\Data\Quotes\_VT_.txt
Requesting url: https://finance.yahoo.com/quote/VT
** For Symbol: VT new quotes not found (there is no 'D(ib)" data-reactid="35">' in html that came back)

Symbol: VUN.TO. Next date: 2019-02-23. Quote file: C:\Investing\v24\Data\Quotes\_VUN.TO_.txt
Requesting url: https://finance.yahoo.com/quote/VUN.TO
** For Symbol: VUN.TO new quotes not found (there is no 'D(ib)" data-reactid="35">' in html that came back)

Symbol: VIU.TO. Next date: 2019-02-23. Quote file: C:\Investing\v24\Data\Quotes\_VIU.TO_.txt
Requesting url: https://finance.yahoo.com/quote/VIU.TO
** For Symbol: VIU.TO new quotes not found (there is no 'D(ib)" data-reactid="35">' in html that came back)

Symbol: VEE.TO. Next date: 2019-02-23. Quote file: C:\Investing\v24\Data\Quotes\_VEE.TO_.txt
Requesting url: https://finance.yahoo.com/quote/VEE.TO
** For Symbol: VEE.TO new quotes not found (there is no 'D(ib)" data-reactid="35">' in html that came back)

Symbol: VCN.TO. Next date: 2019-02-23. Quote file: C:\Investing\v24\Data\Quotes\_VCN.TO_.txt
Requesting url: https://finance.yahoo.com/quote/VCN.TO
** For Symbol: VCN.TO new quotes not found (there is no 'D(ib)" data-reactid="35">' in html that came back)

13:49:29 --- Finished. Quotes Requested/Succeed/Failed/Rows: 9/0/9/0. Duration: 6 sec.

VidasMatelis

Yahoo changed APIs, the updated script should be available soon (earliest later tonight).

patr0kxxx

Incredible support Vidas, as you probably know i am addicted to my PS dashboard

VidasMatelis

Scripts were updated and available for download: http://portfolioslicer.com/download.html
Just 2 files were updated:
GetExchRates-YahooIntraday.ps1
GetQuotes-YahooIntraday.ps1

patr0kxxx

Fixed, thanks again for the fantastic support !

earcandy90

Wow, thanks so much Vidas - really appreciate your fabulous support with this awesome tool!

dmorley64

Thanks so much for the fix! I was observing the same problem and came here and was very pleasantly surprised to have the scripts available already!

deepakhemadri

Updated the scripts. While pulling the data from Yahoo works, the psMakeAllDataFiles routine seems to be stuck. Have tried it multiple times. Log file content for psMakeAllDataFiles is below.

15.23.58 --- Starting script psMakeAllDataFiles.ps1
15.23.59 Starting creating file CurrencyConv.csv.
15.23.59 Finished creating file CurrencyConv.csv. Source file count: 4. Record count: 7116.
15.23.59 Finished creating file Dividends.csv. Source file count: 0. Record count: 0.


Any thoughts? Thank you.

VidasMatelis

deepakhemadri,

I am not sure why script on your environment get stuck. To investigate I would need your script files (no need for excel file). So I need all files from Quotes, QuotesIntraday, Dividends, CurrExch and Scripts folders.
My email is posted on this page: http://www.portfolioslicer.com/contact.html

deepakhemadri

Thanks, Vidas. Have sent you the files.

VidasMatelis

HI deepakhemadri,

I released another update that should help your situation - you have a lot of daily quotes - over 500k records, so powershell script was running slow and it appears that older optimization for these scenarios was lost in this release. Please test these updated scripts (download page) and let me know if you still have any issues.

deepakhemadri

This works!! Many thanks, Vidas.