Print Page  
FORMULA FUNCTIONS / INDIVIDUAL SECURITY
FHist("formula", weeksAgo)
Full Description

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. It should NOT be used with estimate data since it's not adjusted if a quarter change occurs.

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)