Introduction to Investment Data Cloud – A Step-by-step Guide

Article Key Points

  1. What is the Investment Data Cloud?
  2. Why should I use the IDC Excel Add-in?
  3. How to Setup the IDC Excel Add-in?
  4. How to Use the IDC Function Tool?
  5. Example 1: How to Create a Minute Bar Dataset of Apple and Tesla
  6. Example 2: Track a Custom Portfolio’s Performance

What is the Investment Data Cloud?
The Investment Data Cloud is an Excel add-in that allows you to easily pull equity trading data into your spreadsheet. Its intuitive and easy-to-use functions make analyzing trading data a pleasure (https://investmentdatacloud.com/).

Why should I use the IDC Excel Add-in?

  • Data Retrieval – With this Add-in, you can easily retrieve a wide range of equity market data from IDC’s vast collection. This includes today’s market and historical stock quotes and corporate activities.
  • Integration with Excel – The Add-in seamlessly integrates detailed trading data into Excel, allowing you to leverage the powerful data analytical tools of Excel alongside IDC’s robust market data.
  • Real-time updates – The Add-in allows you to stream real-time data into your Excel spread sheets, providing up-to-the-minute market information that can be automatically refreshed at specific intervals. This feature is particularly useful for monitoring market and tracking portfolio returns.
  • Reliable Data Source – The IDC’s database provides reliable and comprehensive equity data. As a trusted source for equity market data, IDC ensures the data is collected from reputable sources and undergoes rigorous quality checks to maintain its integrity. The add-in is a trust-worth source that can be used to cross-reference data from other sources like Yahoo stock data.

How to setup the IDC Excel Add-in? Download the Appropriate IDC Add-in Files
1. Find out what version of Excel you have:File a Account a About Excel. A window will pop up,

About Excel Window versions

2. Go to https://investmentdatacloud.com/, download the Add-in that fits your system.

Add the Add-in to Your Excel

1. Find the Add-in directory of your device.

File a Options a Add-ins a Go to a Browse, a window will pop-up, and the path displayed in that window is your add-in directory.

How to Add Add-ins into your Excel

How to Add Add-ins into your Excel step2

2. Copy the “IDC AddIn.xlam” file and the “ExcelDna.IntelliSense64.xll” (this file name will be different if you are using a 32-bit system) into the directory found above.

3. Finally, Go back to the Add-in window in Excel. Click on “Browse” again. Select the two files you just copied in. Click OK to close the Add-in window. Congratulations! Your IDC Add-in should be ready to use!

Browse Add-ins

Check Add-ins

How to Use the IDC Function Tool

The IDC Function Tool allows you to generate a dataset of equity market data with only a few clicks.

How to use the IDC function

Open the IDC Function Tool, you will see the following window.

Open the IDC function tool

1. The Ticker Symbol(s) cell is the only place you would need to type. The Ticker Symbols takes input in the form of “Ticker1, Ticker2” (including the quotation marks).

2. Select the desired period you are interested in.

3. In section 3, make sure that “Datasets” and “Regular” are selected. Choosing a dataset allows you to select multiple stocks and field names. Alternatively, selecting “Functions” will generate a single output. You also have the option to retrieve adjusted market data.

4. In section 4, you can choose the type of dataset or function you want. Each dataset has different field names, which will be displayed in section 5. The screenshot shows the selection of the daily OHLC dataset, which provides field names such as Open, High, Low, and Close. If you choose a different dataset type, for example, IDC_TradeAndQuoteMinuteBar, a different set of field names will appear, and section 2 will prompt you to further specify the minutes.

IDC function tool

5. In section 5, you have the option to select the specific fields you want. If you don’t select any fields, the default behavior is to retrieve all available fields. After making your field selections, click on the “Run” button. A dataset will then be generated and displayed in your Excel sheet, starting from the cell you previously selected.

Example 1: How to Create a Minute Bar Dataset of Capital One and Apple (COF and AAPL)

How to Create a Minute Bar Dataset of Capital One and Apple (COF and AAPL)

To generate a dataset for Apple and Tesla, you can input the ticker symbols “COF, AAPL” (including the quotation marks) in the Ticker Symbols field. Then, follow the instructions mentioned earlier, such as selecting the desired time, dataset type, and field names, you should get a dataset like this:

Data in IDC function tool

Once you have obtained a dataset, you can manipulate and analyze the data using Excel’s built-in functions, formulas, and tools. Additionally, you can also export the dataset as a CSV file for further analysis on other platforms.

Let’s consider another example to demonstrate how you can use the data to track your portfolio performance efficiently.

Example 2: Track a Custom Portfolio’s Performance

Suppose you have a portfolio of stocks – Amazon, CVS, Facebook, Google, and Bank of America. To track its performance and compare it with Dow Jones, one way is to generate a dataset like in the previous example. Another way is to use the “Functions” and “Adjusted”.

You might set up a sheet for portfolio tracking like this:

Track a Custom Portfolio’s Performance

To retrieve the latest price using the IDC Function Tool, select “Functions” in the IDC Function Tool window and choose the IDC_ClosePrice function.

How To retrieve the latest price using the IDC Function Tool

IDC function tool Input cells

Change the inputs to cell locations.

IDC function tool Input cells2

Then you can apply this formula to all the cells below and apply adjusted closing price function to historical prices.

IDC function tool Input cells3

Then you can fill the rest of the cells using basic excel formulas.

IDC function tool graph

You are done! After setting this up, you can even make this fully automatic if you let Excel automatically update the dates. Then, everything you need to do is open the sheet. A sheet of detailed portfolio performance will show in just a few seconds.

Once you get familiar with the functions, you can skip using selecting in the IDC Function Tool, but it is always a good helper for you not having to memorize every function.

The IDC Excel Add-in is powerful, easy to learn, flexible, and convenient tool for anyone who is interested in the US equity market. It pulls market data from its database fast and has a lot of potential for customization. I hope this introduction demonstrates the capabilities of this add-in. Please make sure you check other blogs on investmentdatacloud.com to find more interesting content.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top

Try Free demo!

Please enter your email address and hit the submit button and we will email you Excel Add-In with Complete Instructions