Search This Blog

Tuesday, May 29, 2012

Track Historical Economic Indicator Prices in Excel

Clients may create spreadsheets in Excel tracking historic Open, Close, High and Low prices for Economic Indicators using the Telemet IQ Excel add-in tool.

1.      In adjacent cells, enter the Symbol for your economic indicator in all capital letters followed by a “-I” to denote Index.  For example, EMPLOY is the symbol for the US Unemployment Rate Index.  So, I would type EMPLOY-I into my reference cell.
2.      Use the Telemet IQ Add-in tool to choose the historic prices data and periods.

Example:


No comments:

Post a Comment