Investors & traders can now use real-time (Ok, 20 minute delayed) data from google finance, in google spreadsheets. Maybe this is nothing new, but I just jumped on it last night, and played around. I added all the US tickers I have positions in to a spreadsheet, then also added either my own weighted cost of capital present ‘fair value’ or morningstar’s ‘fair value’, along side the real-time quotes. I calculated what percentage they were away from the fair value. Here is the chart, I believe this chart will be dynamic, that is, it will change as market data does, and as I change the chart. For now, google spread sheet doesn’t let you play with a legend, so I couldn’t label the stocks. But in order on the chart below from left to right are:
AAPL, CCC, CLC, CL, CPA, CVA, FCX, GOOG, HEK, FSLR, ITU, JCI, MA, MFC, NTDOY, RIG, RIO, TTEK, UNG, V, VE
So you can read, AAPL, is about 4% below my fair value. I should be adding to CVA, JCI, RIO & VE (the four lowest bars) and FSLR is the highest above it’s fair value estimate so, investing via shorting puts seems like the right way to play it, for now.
I’m going to see what else I can cook up, or maybe i’ll go to sleep instead.
Note: UNG obviously doesn’t have a ‘fair value’ estimate. It’s the spot near the right with no bar.
Recent Comments