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

IMPORTANT: The function should NOT be used with split sensitive data, like earnings per share, as it does not adjust for splits between the point in time date and 'X' weeks ago. It should also 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)