Hacker News new | ask | show | jobs
by notJim 5143 days ago
What I have is a sheet which says how many of each asset I own, and the desired allocation. Then, there is a cell that calculates the current allocation, based on the number of shares, and the current price of the share.

The current price of the share is fetched from another sheet using a vlookup. That sheet is populated by the script. The script is here! https://gist.github.com/2717042

The overall system is based on research I found here: http://seekingalpha.com/article/15134-the-seeking-alpha-etf-...