How do I upload a time series, that starts before 1900, to Excel?

Macrobond supports the time series with dates starting before 1900, while Excel, unfortunately, does not. Macrobond Add-in automatically recognizes dates which are entered as text strings. To construct them use the =CONCATENATE formula in Excel.

Set aside one column, and type in the start date’s year.

 

Type in the CONCATENATE formula. Compose the date according to your regional settings, i.e.

  • =CONCATENATE(year, "-01-01")
  • =CONCATENATE("1/1/", year)

 

Paste in the values in the next column. The rest of the dates will be filled in according to template’s frequency.