3 ms·
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
by notJim 14y 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 https://gist.github.com/2717042
The overall system is based on research I found here: http://seekingalpha.com/article/15134-the-seeking-alpha-etf-investing-guide http://seekingalpha.com/article/15134-the-seeking-alpha-etf-...