Questions

2 things:

1) Does anyone know if there is a way to have excel automatically pull stock prices and refresh itself everyday? I can import a table of historical prices but I'm not sure if it can update itself.

2) Is there a specific way to look at a stock and find the day with its largest open and close difference? Cant tell from just the graphs. I need an easier way compared to sifting through 10 years of prices.

Thanks in Advance

Submitted October 15, 2015 at 06:02PM by EBulvid http://ift.tt/1LR5oQT