Quote Source: Fred

 

Fed's Fred supports only historical values retrieval mode (i.e. no current values retrieval mode), the supported fields are

Field Primary Name

Field Synonyms

Field Definition

"DATE"

"DT","D"

 

"LAST_TRADE_PRICE"

"PRICE", "P","VALUE"

 

 

Note: Fields in bold are default fields.

Note: Fed's Fred supports all frequencies but weekly ones.

 

Examples:

1. Download from Fed's Fred the last 10 years of CPI of All items in Canada without the Column header

=Q("f::CANCPIALLMINMEI",,"-10y")

 

 

2. Download from Fed's Fred the last 10 years of CPI of All items in Canada with the Column header

=Q("f::CANCPIALLMINMEI",";","-10y")

 

 

 

Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017