1/6/2024 0 Comments See finance quote not updating![]() If you are not interested in this you may skip this part. I am going to talk a little about the technical implementation to help those looking for how it works. CSV files, a JSON file format implementation should work. Since the problem is that Google has an issue processing. The solution that I found is that Yahoo does provide data of stocks and unit trusts in JSON format, instead of CSV format. My Solution to Pull Market Prices from Yahoo Finance Data (and Other Data) Since we are also retrieving a CSV file for this implementation, this is also hit with the problem and you will observe that under Yahoo Price it shows as #ERROR!. This is located in your Tools > Script Editor. I had another implementation for some readers, which is to use a javascript function to retrieve the Yahoo Finance price. In my first implementation, you will see #ERROR! on Yahoo Data Ref sheet. This has hit people with various different implementation. It is not a Yahoo Finance or Data source thing. They are having problems retrieving data from CSV files. The latest outage seem to do more with Google Spreadsheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |