Historical data will follow the function format:
=HistoricalData(“SYMBOL”,”Field”,”Start”, “End”, “Frequency”)
where SYMBOL needs to be replaced with the preferred Money.Net ticker symbol, Field needs to be replaced with one of the historical data field names below, Start needs to be replaced with your beginning date, End needs to be replaced with your ending date, andFrequency needs to be replaced with a frequency option mentioned below.
Note: The quotes need to remain in place if you are typing the Ticker/DataField in directly. They need to be removed if you are instead referring to another cell that contains the text.
Click here for a list of all available Historical Fields and frequencies.
The available frequency options for Historical Stock Data are:
Daily, Weekly, Monthly, Annually, Quarterly
The available frequency options for Historical Fundamental Data are:
Annual, Annual (As Reported), Quarterly, Quarterly (As Reported), Trailing Twelve Months, Trailing Twelve Months (As Reported), Annual (Most Recent), Quarterly (Most Recent), Trailing Twelve Months (Most Recent)