Thursday, April 20, 2023

smfGetYahooPortfolioView working again

 Today it started working again.  I can also log in with my old yahoo account and password, so there was obviously an issue on Yahoo.  There was also a message about invalid crumb, so it could be related to the failed login and cookies.

Wednesday, April 19, 2023

smfGetYahooPortfolioView not returning data

 Yahoo Portfolio View has stopped working


smfGetYahooPortfolioView was returning no data.  I was unable to log into portfolio view at Yahoo and the error returned was "unauthorized" when trying to get the json data.

There is also a notice of Portfolio 2.0 coming...

 Checking the code and the URL being created is also nott working if manually entered into a browser.

Here are some of the URLs I was testing with:

https://query1.finance.yahoo.com/v7/finance/quote?fields=" & sFieldList & "&formatted=false&symbols=" & replace(sTickers, ",XXXXX", "")

https://query1.finance.yahoo.com/v7/finance/quote?fields=longName,shortName,quoteSourceName,regularMarketPrice,regularMarketTime,regularMarketChange,twoHundredDayAverage,fiftyTwoWeekRange&formatted=false&symbols=MMM,ED,MCD,NWN,SPHD,XOM,XOM160812C0008650"

"https://query1.finance.yahoo.com/v7/finance/quote?fields=longName,shortName&formatted=false&symbols=AAPL"

"https://query1.finance.yahoo.com/v10/finance/quoteSummary/MMM?modules=financialData"

https://query1.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=financialData

https://query1.finance.yahoo.com/v7/finance/quote?fields=longName,shortName&formatted=false&symbols=AAPL

The v10 was returning json data.


SMF new Add-In version 3.0.2024.04.29

  This new release has fixes for: module smfGetOptionQuotes A member (Bruce) found the issue was with the crumb processing and provided cod...