Subject: Re: Grabbing Market Data During Day
No cookie/crumb thing required.
Google Sheet.
symbol in A1.
Two choices: current price delayed 20 minutes: =googlefinance(A1,"price")
historical price data either rolling or from a fixed point:
=googlefinance(a1,"price",start date (which can be something like today()-250 or a typical Excel date formula),end date, interval (daily or weekly).
such as
GOOGLEFINANCE("GOOG", "price", "1/1/2014", "12/31/2014", "DAILY")
self-documented with all the other attribute parameter values you can use, including basic fundamentals, and can be run with different (limited) parameters against mutual funds.
FC