Version Download Release Date Description
1.4.0 Download Mar 21 2018 Changes : Api Audit , Bug Fixes.
1.3.0 Download Dec 13 2017 Version 1.3.0
Updated excel plugin installation package with activation log
1.2.0 Download Nov 18 2017 Based on version 1.0, this version add more features: Sentiment history for Forex, Commodities, Cryptocurrencies, and Topics.
1.0 Download Sep 5 2017 Initial version with functional features: Leaders/Laggers, Sentiment history for Indexes, Companies, Company search and Timezone.

I. Installation steps

Step 1 : Download Zip file and extract.

Step 2 : Extract the zip file to a temporary folder of your choice.

Step 3 : Find setup.exe in the containing folder. Double Click on the setup.exe,
which will bring up a pop-up as below.

Step 4 : Click Install. Click on the Close button once the installation process has
been completed.

II. Product Activation

Step 1: Open Excel and click on “INFOTRIE” tab

Step 2: Click on “Product Activation” menu item.

If you are a FinSentS Subscribed User, enter only “AppKey” in the Activation Wizard, click on the ‘Generate’ button and wait for activation. Upon successful activation, plug-in menu items get displayed under “INFOTRIE” tab.

If you are a Corporate User, enter “AppKey” and “SecrectKey” in the Activation Wizard, click on the Generate button and wait for activation. Upon successful activation, plug-in menu items get displayed under “INFOTRIE” tab.

Note: If the Activation fails, the Activation Wizard pop-up stays opened and an error log gets displayed. Most of the time, users face the Windows OS file write permission issue. A typical error log would ends with a line as below.

‘Activation Failed…..Access to the path ‘C:\Program Files\InfotrieProductActivation’ is denied.’

In this case, do grand necessary write permission to the respective windows folders.

Step 3: If the Activation is successful, “API” Menu gets displayed under “INFOTRIE” tab as below.

Enter Appkey and Secrectkey and click Generate button wait for activation.After activation process you will have the features under INFOTRIE tab.

III. API Functions

1. Leaders/Laggers

Summary: Exclusive analysis for more specific investment goals. InfoTrie divides the daily sentiment scores into positive and negative: positive is leaders and negative is laggers. The results will be pretty clear by using this intuitive and simple approach.

Description: This API returns Leaders or Laggers data of thousands of companies all over the world.When you input Index ID and Format, you can get Sector, Price, Name, Sentiment Score, Name ID, Industry, News Volume, News Buzz, Ticker and Price change.

InfoTrie has 15+ years history data. The FinSentS News Sentiment database offers daily media sentiment indicators for:

– 45,000+ stocks

– Major global stock indices

– FX

– Commodities

The FinSentS News Sentiment database currently covers these stocks:

-15,000 North American stocks

– 8,000 European stocks

– 4,000 Japanese stocks

– 14,000 Asian stocks excluding Japan

– 3,000 Australia / New Zealand stocks

The data is powered by FinSentS published by InfoTrie Financial Solutions

Input

  • indexid (required):- will be concat of class type and id.

Format: in_<x> where x is the index.

Output

  • Sector
  • Price.
  • Name: Name of the company
  • Sentiment Score: a numeric measure of the bullishness / bearishness of news coverage of the stock.
  • Nameid
  • Industry
  • News Volume: the absolute number of news articles covering the stock.
  • News Buzz: a numeric measure of the change in coverage volume for the stock.
  • Ticker
  • Price change

Each stock has 8 indicators.

In this section we have option to choose index wise leaders and laggers.

Leaders section

Select Leaders – > choose index

Leaders Data

Laggers section

Select Laggers – > choose index

Laggers Data

2. Sentiment History

Summary: Equity news sentiment history for smarter investment decisions. Analysing the sentiment history can help people to research the development of company, and help to predict.

Description: This API returns News Sentiment data around thousands of stocks, commodities and Forex listed globally. When you input Company ID, Format and Number of Days, you can get the detailed sentiment history of the company including sentiment score, Sentiment high / low, News Volume, News Buzz and Date.

InfoTrie has 15+ years history data. The FinSentS News Sentiment database offers daily media sentiment indicators for:

– 45,000+ stocks

             – Major global stock indices

              – FX

              – Commodities

              The FinSentS News Sentiment database currently covers these stocks:

-15,000 North American stocks

– 8,000 European stocks

– 4,000 Japanese stocks

– 14,000 Asian stocks excluding Japan

– 3,000 Australia / New Zealand stocks

The data is powered by FinSentS published by InfoTrie Financial Solutions

Inputs:

  • companyid (required) :- will be concat of class type and id.

      Format: c_<x> where “x” is the Company id.

  • ndays :- No of Days. This field specifies the look back period of our historical                         sentiment data.

Outputs:

  • Sentiment Score: a numeric measure of the bullishness / bearishness of news         coverage of the stock.
  • Sentiment high / Low: highest and lowest intra-day sentiment scores.
  • News Volume: the absolute number of news articles covering the stock.
  • News Buzz: a numeric measure of the change in coverage volume for the         stock.
  • Date

In this section we have option to choose sentiment history for indexes and companies.

Sentiment history for indexes

Select Sentiment History – > choose index

Sentiment data for indexes

Sentiment history for companies

Select Sentiment History – > click company->enter company name(minimum 4 letters) -> click search button -> choose select option from companylist

Sentiment data for companies

Sentiment history for forex

Select Sentiment History – > click Forex->choose select option from Forex list

Sentiment data for Forex

Sentiment history for Commodity

Select Sentiment History – > click Commodity-> click Type(Ex:Energy)-> click Sub Type(Energy)->choose select option from Commodity List

Sentiment data for Commodity

Sentiment history for Crypto Currencies

Select Sentiment History – > click Commodity-> click Type(Ex:A-C)-> choose select option from Crypto Currencies List

Sentiment data for Crypto Currencies

Sentiment history for Topic

Select Sentiment History – > click Commodity-> choose select option from Topic List

Sentiment data for Topic

3. Company Search

Summary: Quickly search for being early movers in the fiercely competitive era. By using this API, you can search and find any company you are concerned.

Description : This API returns Company information by Company Name.

In this section we have option to search companies.

Select Company Search – > enter company name(minimum 4 letters) -> click search button  we can get corresponding companies what we searched.

Company Search data

4. DATA ISSUE OR CONNECTION FAILED

If API response is not proper or no data that time popup will show “NODATA” message

If there is any internet issue like no connection that time popup will show “NODATA or please check the internet connection” message

5. Timezone

In this section we have option to choose timezones.Here we have three timezones(Asia/Singapore, Europe/Berlin, America/New_York) this is for getting Sentiment history data based on timezone.

Select Timezone – > choose timezone

6. Troubleshooting Section

1. Version related issue while installing Excel plugin.

If User have any problem while installing new version Excel plugin .Please Uninstall Infotrie_excel_addin from Control panel->Programs.

2.  Other Error while installing Excel plugin.

Run the following command in your command prompt 

rundll32 dfshim CleanOnlineAppCache

3.  Activation Failure

If the Activation fails, the Activation Wizard pop-up stays opened and an error log gets displayed. Most of the time, users face the windows file write permission issue.
#A typical error log would ends with a line as below.

‘Activation Failed…..Access to the path ‘C:\Program Files\InfotrieProductActivation’ is denied.’

In this case, do grand necessary write permission to the respective windows folders.

In the case of an Invalid App Key, the error log shows as in the below screen shot.

Version Download Release Date Description
1.2.0 Download Mar 21 2018 Changes : Api Audit , Bug Fixes.
1.0 Download Feb 26 2018 Initial version with functional features: Leaders/Laggers, Sentiment history for Indexes, Companies, and Company search.

Installation steps

Step 1 : Double click InfoTrie Excel Plugin(Mac).xlam file

Product Activation

Step 1 : Click on Enable Macros button

Step 2 : Click File -> New Workbook

Step 3 : Click on Product Activation button

Enter Appkey and Secrectkey and click Login button and wait for activation.

After activation process you will have the features under the API button.

  • Leaders/Laggers

Summary: Exclusive analysis for more specific investment goals. InfoTrie divides the daily sentiment scores into positive and negative: positive is leaders and negative is laggers. The results will be pretty clear by using this intuitive and simple approach.

Description: This API returns Leaders or Laggers data of thousands of companies all over the world.When you input Index ID and Format, you can get Sector, Price, Name, Sentiment Score, Name ID, Industry, News Volume, News Buzz, Ticker and Price change.

InfoTrie has 15+ years history data. The FinSentS News Sentiment database offers daily media sentiment indicators for:

– 45,000+ stocks

– Major global stock indices

– FX

– Commodities

The FinSentS News Sentiment database currently covers these stocks:

-15,000 North American stocks

– 8,000 European stocks

– 4,000 Japanese stocks

– 14,000 Asian stocks excluding Japan

– 3,000 Australia / New Zealand stocks

The data is powered by FinSentS published by InfoTrie Financial Solutions

Input

  • indexid (required):- will be concat of class type and id.

Format: in_<x> where x is the index.

Output

  • Sector
  • Price.
  • Name: Name of the company
  • Sentiment Score: a numeric measure of the bullishness / bearishness of news coverage of the stock.
  • Nameid
  • Industry
  • News Volume: the absolute number of news articles covering the stock.
  • News Buzz: a numeric measure of the change in coverage volume for the stock.
  • Ticker
  • Price change

Each stock has 8 indicators.

In this section we have option to choose index wise leaders and laggers.

Leaders section

Select Leaders / Laggers – > choose index

Leaders/Laggers Data

Sentiment History

Summary: Equity news sentiment history for smarter investment decisions. Analysing the sentiment history can help people to research the development of company, and help to predict.

Description: This API returns News Sentiment data around thousands of stocks, commodities and Forex listed globally. When you input Company ID, Format and Number of Days, you can get the detailed sentiment history of the company including sentiment score, Sentiment high / low, News Volume, News Buzz and Date.

InfoTrie has 15+ years history data. The FinSentS News Sentiment database offers daily media sentiment indicators for:

– 45,000+ stocks

– Major global stock indices

– FX

– Commodities

The FinSentS News Sentiment database currently covers these stocks:

-15,000 North American stocks

– 8,000 European stocks

– 4,000 Japanese stocks

– 14,000 Asian stocks excluding Japan

– 3,000 Australia / New Zealand stocks

The data is powered by FinSentS published by InfoTrie Financial Solutions

Inputs:

  • companyid (required) :- will be concat of class type and id.

Format: c_<x> where “x” is the Company id.

  • ndays :- No of Days. This field specifies the look back period of our historical sentiment data.

Outputs:

  • Sentiment Score: a numeric measure of the bullishness / bearishness of news coverage of the stock.
  • Sentiment high / Low: highest and lowest intra-day sentiment scores.
  • News Volume: the absolute number of news articles covering the stock.
  • News Buzz: a numeric measure of the change in coverage volume for the stock.
  • Date

In this section we have option to choose sentiment history for indexes and companies.

Sentiment history for indexes

Select Sentiment History – > choose index

Sentiment data for indexes

Sentiment history for companies

Select Sentiment History – > click company->enter company name(minimum 4 letters) -> click search button -> choose select option from companylist

Sentiment data for companies

Sentiment history for Commodity

Select Sentiment History – > click Commodity-> click Type(Ex:Energy)-> click Sub Type(Energy)->choose select option from Commodity List

Sentiment data for Commodity

Sentiment history for Crypto Currencies

Select Sentiment History – > click Commodity-> click Type(Ex:A-C)-> choose select option from Crypto Currencies List

Sentiment data for Crypto Currencies

Sentiment history for Topic

Select Sentiment History – > click Commodity-> choose select option from Topic List

Sentiment data for Topic

  • Company Search

Summary: Quickly search for being early movers in the fiercely competitive era. By using this API, you can search and find any company you are concerned.

Description : This API returns Company information by Company Name.

In this section we have option to search companies.

Select Company Search – > enter company name(minimum 2 letters) -> click search button  we can get corresponding companies what we searched.

Company Search data

  • DATA ISSUE OR CONNECTION FAILED

If API response is not proper or no data that time popup will show “NODATA” message
If there is any internet issue like no connection that time popup will show “NODATA or please check the internet connection” message