That's another issue that I am facing too. If you relied on Google for quotes, then none of them will work as Google is not allowing bots to access their finance data. You will have to switch sources to Yahoo, Stooq, or AlphaVantage.
hi, I have exactly the same issue, I tried the previous solution to adjust the script but it does not work.
strange, I can still use the main webpage of finance.google.com (but see more below) in the log I am getting these errors: for GetQuotes-Google : NASDAQ:INTC - Not Found (web err) for GetQuotes-GoogleWeb : EPA:FP - Not Found (web err)
1) I updated the psScript file to remove any quotes from any Google Sources. 2)I found the same ticker on Yahoo and added them to the Yahoo section. 3) In some cases I did not find the ticker elsewhere, in which case, I found the Quotes.csv file (in PSData folder) from March 18 (back when Google was still providing data), and copied the entries in to the *new* Quotes.csv file.
qosmioamit - any updates that you make to the quotes.csv will be overwritten the next time you run a quote update script.
For the India markets, there seems to be a data feed issue to Yahoo and to AlphaVantage after 13/Mar. You can open any ticker on Yahoo Finance and you can see only today's quote and 12/Mar and before quotes. This has been true for the past few days.
I have a suggestion / request for MaximT - The NSE and BSE stock exchange sites provide EOD data for all their tickers for each trading day and historical data too. Would you be able to pull those files (they are already in CSV) and update the quote files for stocks held in the portfolio? This would get rid of any issues related to Yahoo/Google/etc at least for EOD data. Some data massaging needs to be done similar to what we need to do if we switch from Yahoo to Google and so on.
I haven't found an alternative to GoogleWeb for my Canadian Mutual Funds. Yahoo has historical data, but not since December 2017. I tried the same symbols in AlphaVantage, and got the same result as Yahoo.
xcerik, if you have already used PortfolioSlicer, then you must have on your computer mutual fund data up to last week. So if you would switch now same mutual funds to Yahoo source, then even Yahoo starts in Dec 2017, all you need from Yahoo is data from March 2018. Please read at the bottom of this page http://www.portfolioslicer.com/scripts/quotes-datasource.html on how to change quote source.
VidasMatelis. Yahoo provides historical data for mutual funds but they all stop at around December 2017. You can check for F00000T407.TO or GGF31144 in old google web. The only value useful from yahoo is the intraday. https://ca.finance.yahoo.com/quote/F00000T407.TO/history?p=F00000T407.TO.
All the other scripts do not give access to quotes for Canadian mutual funds except AlphaVantage but it seems they have the same source of data as yahoo.
kevmegforest - sorry, but there is not much I can do about this, as Canadian Mutual fund data is not available. You still have an option to manually add quotes to these files, you will need at least one quote per month for Portfolio Slicer to work properly.
Vidas, I found that the historical quotes from Yahoo for some of the Hong Kong stocks are not correct. It is quite annoying to use inaccurate data for the calculations. (AlphaVantage also has the same wrong data, I believe they are using the same set of back end database.)
Comments
I have exactly the same issue, I tried the previous solution to adjust the script but it does not work.
strange, I can still use the main webpage of finance.google.com (but see more below)
in the log I am getting these errors: for GetQuotes-Google : NASDAQ:INTC - Not Found (web err)
for GetQuotes-GoogleWeb : EPA:FP - Not Found (web err)
Could be they changed something on DNS as the site changes from finance.google.com to https://www.google.com/search?stick=H4sIAAAAAAAAAOPQeMSozC3w8sc9YSmpSWtOXmMU4RJyy8xLzEtO9UnMS8nMSw9ITE_lAQCCiJIYKAAAAA&q=finance&tbm=fin#scso=uid_liOxWpaPE6fN6QTMxbrADg_0:0&spf=1521558421075
Thanks, Adrian
1) I updated the psScript file to remove any quotes from any Google Sources.
2)I found the same ticker on Yahoo and added them to the Yahoo section.
3) In some cases I did not find the ticker elsewhere, in which case, I found the Quotes.csv file (in PSData folder) from March 18 (back when Google was still providing data), and copied the entries in to the *new* Quotes.csv file.
No errors!
For the India markets, there seems to be a data feed issue to Yahoo and to AlphaVantage after 13/Mar. You can open any ticker on Yahoo Finance and you can see only today's quote and 12/Mar and before quotes. This has been true for the past few days.
I have a suggestion / request for MaximT - The NSE and BSE stock exchange sites provide EOD data for all their tickers for each trading day and historical data too. Would you be able to pull those files (they are already in CSV) and update the quote files for stocks held in the portfolio? This would get rid of any issues related to Yahoo/Google/etc at least for EOD data. Some data massaging needs to be done similar to what we need to do if we switch from Yahoo to Google and so on.
Here are the links where you can get the EOD quotes.
NSE - https://www.nseindia.com/products/content/equities/equities/archieve_eq.htm (Choose BhavCopy in the drop down and any date)
BSE - https://www.bseindia.com/markets/equity/EQReports/BhavCopyDebt.aspx?expandable=3 (Choose a date or click the first link on the left side of the table to download latest trading day EOD data).
Thanks.
All the other scripts do not give access to quotes for Canadian mutual funds except AlphaVantage but it seems they have the same source of data as yahoo.
I have not tried it yet, but Google EOD and interday data feeds but be working again. Folks might be able to find Mutual Fund Quotes again ...
Thanks for sharing!
In the past year I switched between Yahoo and Google a few times. Yahoo now works OK and I can find all symbols info I want, so I'll keep using Yahoo.
I found that the historical quotes from Yahoo for some of the Hong Kong stocks are not correct. It is quite annoying to use inaccurate data for the calculations. (AlphaVantage also has the same wrong data, I believe they are using the same set of back end database.)