Get Data

Search

Search gives direct access to all the TE API indicators.

Excel search

You can look for countries, bonds, currencies, stocks and much more. It’s also possible choose from which source/data type you want to get data from.

Excel search example

When selecting the Indicator, must of them, will have some options to manipulate the data from the request, such as Daily Data, Intraday Data or Snapshot Data with Start Date or End Date.

Excel search date

Indicators

Indicators

The Indicators method has the following options:

  • Latest: Get the latest datapoint/snapshot for one or more countries and indicators

  • Historical: Gets data for one or more countries and indicators for a period of time. You can choose a time interval or you can get all the data available

  • Updates: This options let you see what datapoints were updated recently on our databases. It can be updates from last Week or from the last Month.

Excel indicators

When a method is selected will open a window to select the countries and the indicators. It’s possible to find list items by typing in the input area above the lists. After selecting, press the Next button.

Then select which columns to display and choose a excel Cell to show the data.

Note: Selecting updates options doesn’t allow to choose country/indicator.

Excel indicators 2

Excel indicators 3

Result:

Excel indicators 4

Calendar

Calendar

The Calendar method gets the date when a certain indicator for a specific country is expected to be released. You can choose a time interval.

Excel calendar 1

On the lists from the left side you can pick the countries and the indicators. It’s possible to find list items by typing in the input area above the lists. After selecting, press the Next button.

Then select which columns to display and choose a excel Cell to show the data.

Excel calendar 2

Excel calendar 3

Result:

Excel calendar 4

Markets

Markets

The Markets method gets the latest data values for all markets indicators from either currency, index, commodities and bonds. On this method is also possible to request Financial data, in this option will be possible to select countries and respective companies.

Excel markets 1

Windows to select Financials data:

Excel markets 2

Forecasts

Forecasts

The Forecasts gets value predictions for the selected economics indicators, indexes, currencies, commodities or bonds. Only economic indicators has options to choose.

Excel forecats 1

Choosing Economic option the user can pick the countries and the indicators. It’s possible to find list items by typing in the input area above the lists. After selecting, press the Next button to select which columns to display and choose a excel Cell to show the data.

Excel forecats 2

Excel forecats 3

Result:

Excel forecats 4

Ratings

Ratings

Ratings gets the classification attributed to the countries public debt by the ratings agencies.

Excel ratings 1

You can either get the lastest rating for all countries or historical ratings for specified countries.

In case of historical this form will pop up, just select the countries you want to get ratings from.

The Ratings Latest Result:

Excel ratings 2

Ratings Historical:

Excel ratings 3

Ratings The Ratings Historical Result:

Excel ratings 4

History

History

This option is related to the user’s history. Each request done in the other methods generates a formula that is saved in this history. In here the user can manage and check all the formulas requested in the last days and if necessary it allows to run it again by selecting it or to do some modification in the selected formula.

Excel history 1

Excel history 2

Refresh

Refresh

This method is responsible to update the data you might have requested earlier. In here is possible to refresh the data in the moment or to activate an auto-refresh to refresh automatically every x minutes or hours for the active working sheet or for all worksheets open on Excel.

To stop the auto-refresh just select the disable option.

Excel refresh 1

Auto-Refresh:

Excel refresh 2

Help

Help

Press Help to check excel documentation, to contact our support team or to Diagnose issues. If you are facing some type of issue please run diagnose on your system and share a printscreen with our support team.

Excel help 1

Excel help 2

Excel help 3