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.

Installation steps

Step 1 : Download Zip file and extract.

Step 2 : Double click on ‘InfoTrieCertificate.p7b’ Certificate and follow below mentioned screenshot

Click

Click Install Certificate button

Step 3 : Rename setup.ext to setup.exe and install it.

Product Activation

Open Excel and take INFOTRIE tab Click on product activation.

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

Appkey : Enter your Appkey Secrectkey : Enter your Secrectkey

  • 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

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

  • 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

  • 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

  • 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

  • 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 panal->Programs.

2#  Other Error while installing Excel plugin.

Run the following command in your command prompt 

rundll32 dfshim CleanOnlineAppCache

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