There have been a lot of people emailing me, messaging me, finding ways to get hold of me, to tell me that my
FREE Stock Portfolio Tracker is not working.
I thought if I don’t try to solve this, there will be no good sleep for me.
So here are some explanations and how to get around this problem.
Yahoo Finance Data is still Working
Verizon’s purchase of Yahoo is going through, and we do not know how it will affect Yahoo Finance.
However, Yahoo is still able to let us access to the data.
The Yahoo Price in Stock Portfolio Tracker comes from the sheets Yahoo Data Ref, Yahoo Data Ref USD, Yahoo Data Ref HKD.
The
Cell A2 in each of those sheet contains the formula that pulls the prices of stocks in your Stock Summary, Stock Summary USD, Stock Summary HKD.
If you look at the image, ......