Using existing excel workbook which already has Yahoo API stock feeds implemented.
Need an additional field pulled from yahoo.
On individual stock sheet, using the API and holdings data, three graphs:
1. Daily gain/loss (shown a positive in green $ above and negative in red below line)
2. Holdings Gain/Loss (same as above, but using holdings and cost, compared to current quote)
3, Current share price graph; two line. Bottom showing 52 week high/low with ranged colored, and above that show current price with day high/low. So day quote above 52 week range, so user can see where the current quote in in relation to 52 week range.