Oct
10

Using Excel with NeoTicker Part 1

Overview

You need to take a snapshot of the current market prices of a list of symbols and format the data for presentation purpose. NeoTicker® can export data directly to Excel and reformat the data for this purpose.

Step by Step Guide

1. Create a quote window from a predefined quote window template, for example, the “Dow Jones 30” template.

step1

2. Send the quote window data to Excel by choosing the popup menu item Export Table>Excel.

step2

3. NeoTicker® will instruct Excel to open a worksheet and export the data in the quote window to this worksheet. The resulting Excel spreadsheet should look like this.

step3

4. You can then use one of the AutoFormat template in Excel to enhance the visual impact of the table.

step4

step5

5. The result can be used for presentation or you can apply more formatting to fit your need.

step6

Note: We created this example long time ago and it was placed in a spot very hard to find. As we are re-organizing our website, more useful posts and examples will be moved over to the blog site.

Blog Developed
By ContentRobot