FHist returns the value of the formula evaluated 'X' weeks ago from the current as-of-date using our historical engine.

When the weeksAgo parameter is negative the formula will be evaluated in the future of the as-of-date. If the desired future date is beyond the present it will return NA's

Split/dividend sensitive values like EPS or prices are adjusted to the as-of date (observation date) of your analysis. These functions should not be used with estimate data since you might be accessing a different fiscal period. In addition, if the observation date is before 1999, this function will return NA.

Examples:

To get the Market Cap 10 weeks ago

FHist("mktcap",10)

To calculate the 1 year future performance of the stock use the formula below (251 trading days is approximately 1 year)

FHist("close(0)/close(251)",-52)