Some Stock Portfolio Tracker Problems and How to get Your Singapore Prices Updated in your Spreadsheet
By Investment Moats  •  December 18, 2017

For the users of my Stock Portfolio Tracker, you might notice that there are some issues getting the end of day Singapore prices.

You would notice a “#NA“, where it says failed to fetch data.

I am puzzled why this happened.

I investigated for 2 days and realize its a combination of:

  1. How my web host handles the caching of the price file “sp.csv”
  2. How ImportData function in Google Spreadsheet works

Suffice to say, I was deeply frustrated. So much so it nearly caused me to down the whole Investment Moats and put me out of commission for 2 full days.

Some times price can be retrieved.

Then it stopped working after a while.

Sometimes you get an old cache version of the file.

The Solution

The solution, which might be temporary or alternative, is to use my custom function getSGPrice() instead of ImportData function.

This ...

...
Read the full article
By Investment Moats
Investment Moats is set up by Kyith Ng and have been around since 2005. He aims to share his experiences making sense of money, how money works and ways to grow his money. It hopes that by sharing his experiences, both good and bad, season investors can advice and critique his decisions and new investors can learn from them and find their own style ...
LEAVE A COMMENT
LEAVE A COMMENT

Your email address will not be published.

*

Your Email Address will not be published
*

Read More Articles
More from thefinance