I have been looking for some excel vba program to maintain my watch list, but could not get one.
Finally, spent few days to learn and developed my own watchlist excel program.
https://drive.google.com/open?id=1HDGzXsDLw9CHk5kMfSP6ct8UOTnHBPMn
If this is useful, use it. Link may be removed after few days (may in this sunday)
Usage:
Column C2…C9999 fill up your tickers (whatever iex trading supports) and the click the getprice button.
Once clicked, Column A1 will say “processing…” then comes to “completed”. It also sorts finally.
Color greens are 10% up, 5% up and 3%, Colr red,Khaki and Light yellow are down 10%, 5% and 3% Respectively
Sorry, I did not have time to write up documentation.
Please no more enhancement, no more work on this.
