Inet Stock Data in Excel – Barebones Example
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):

If you do use this for anything or have ideas on what to do with the data, leave a comment.
Get answers right away at our AE Excel Support Forums!


