Inet Stock Data in Excel – Barebones Example

March 21st, 2005 | Categories: XML/Services | Tags:

I put together a quick demo of getting Inet data into Excel.
The worksheet requires Excel 2003 pro and a developer token from Inet (after you register for Inet, click the Get Developer Token Link).

As the title states it’s a barebones example, you can download it here. (you need to enter your developer token in cell B1). The spreadsheet gets the last transaction info, and downloads the buy/sell book orders to a single list. You can build from there, I’ll post what I come up with when I get some free time.

What’s interesting is the Inet data in Excel is more accurate than their online viewer. Here is a picture of the Inet Spreadsheet vs. the Island viewer for the stock Google (notice the online version is delayed, however the Excel version was real time):

inetbarebones

If you do use this for anything or have ideas on what to do with the data, leave a comment.

No comments yet.