Howdy, Stranger!

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

Error updating from Yahoo since 2019-02-23

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: D:\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: D:\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 ?

Comments

  • 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.

  • Yahoo changed APIs, the updated script should be available soon (earliest later tonight).
  • Incredible support Vidas, as you probably know i am addicted to my PS dashboard :)
  • Scripts were updated and available for download: http://portfolioslicer.com/download.html
    Just 2 files were updated:
    GetExchRates-YahooIntraday.ps1
    GetQuotes-YahooIntraday.ps1

  • Fixed, thanks again for the fantastic support !
  • Wow, thanks so much Vidas - really appreciate your fabulous support with this awesome tool!
  • 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!
  • 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.
  • 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
  • Thanks, Vidas. Have sent you the files.
  • 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.
  • This works!! Many thanks, Vidas.
Sign In or Register to comment.