I've been working on creating a worksheet for value pick on stocks for myself. Lately, I am thinking that this worksheet could help others to quickly see if a stock is undervalued, fair, overvalued. It's a long way from becoming something that I feel would be truly useful. My reason behind creating this is that I think watchlists are often quite useless because you only see a stocks current price. Please give me some feedback as to what I could add/remove to improve the worksheet. OR! maybe I'm wasting my time because there is something like this out there for free? I would like to know that too.
Current fields/thoughts behind each field:
- Ticker: Stock ticker
- Risk: This is personal but could serve as a reminder to users of the risk for themselves in buying a stock
- Exchange: Currently CAN/US (IE. NYSE, TSX) will expand or create a different worksheet for each exchange
- Previous ATH: It's the all time high price since the company listed. Currently I don't think it is really accurate but I will try to continue to improve this
- Current Price: The current price of the ticker, it is a bit delayed because I'm just using free information off the web
- Percentage Increase: Speculation of percentage gain buying at `Current Price` compared to `Previous ATH`. Basically how much the price has dropped compared to it's ATH and how much you stand to gain if it was to go back up to the ATH
- Increase: It's just another way of Percentage Increase but just saying if the stock reaches ATH again it will be a 1x, 2x, 3x...10x etc