External realtime feed

I trade bitcoin. I have some related questions:

1. Does ASCII Mapping support streaming datafeed?

2. Can anyone offer a sample code of writing a MC compatible DDE server?

3. What's the cost and eligibility of getting the MultiCharts Data API?

The goal is to feed bitcoin exchange streaming price data feed into MC and use MC to algo trade them.

What's the best way to approach this?

Hello balabinba,

1) Using ASCII mapping that is possible to get both historical and realtime data. ASCII mapping creates a link from the software to the ASCII file with data. ASCII mapping does not import data into MultiCharts database (Edit data window of QuoteManager will be empty). Each time you plot an ASCII mapping symbol-the data is taken from the file directly. That is possible to map multiple ASCII files at the same time. You do not need to create ASCII mapping instrument manually-it is created automatically upon mapping.
If you want the data to be continuously plotted on the chart you need to continuously add the lines one by one to the end of a txt file.

2) With the help of Universal DDE one can get realtime data via DDE protocol (ex. Excel, MT).
To get the data from Excel please do the following:
Create a book - book1.xls and save it to “My documents”.
In Excel set the coordinates to R1C1format (Excel options-formulas- working with formulas-activate R1C1 reference style).
All other fields that should be filled will look like:
=EXCEL|'[Book1.xls]Sheet1'!*
it means:
=EXCEL<vertical line>[<file name with the extension>]!*

Adding a symbol:
For example R2C2, where R - the row number, С - the column number.

3) With MultiCharts Data API one can create his own data provider connected to his infrastructure with data. This is not something that is required for a regular user to get data from an external source.

Hello, I found this post very interesting. I am using Capital IQ and can download historic daily data into Excel. I would like to map the excel data directly into MC without creating a txt file. I did not understand the following:

All other fields that should be filled will look like:
=EXCEL|'[Book1.xls]Sheet1'!*
it means:
=EXCEL<vertical line>[<file name with the extension>]!*

Adding a symbol:
For example R2C2, where R - the row number, С - the column number.

Can you draw up an example please how this would look in excel. Thanks.

Hello, I found this post very interesting. I am using Capital IQ and can download historic daily data into Excel. I would like to map the excel data directly into MC without creating a txt file. I did not understand the following:

All other fields that should be filled will look like:
=EXCEL|'[Book1.xls]Sheet1'!*
it means:
=EXCEL<vertical line>[<file name with the extension>]!*

Adding a symbol:
For example R2C2, where R - the row number, С - the column number.

Can you draw up an example please how this would look in excel. Thanks.

Hello smashthepound,

With the help of Universal DDE you can get only realtime data via DDE protocol (ex. Excel, MT), not historical data from Excel.

If you want to get values from multiple columns (C1, C2, C3, etc) into a single symbol, then you need to call the symbol as the row number (R1).
In the DDE feed settings the data fields should be configured to the respective columns:
Bid
Price =EXCEL|'Book1.xls'!*C1
Volume =EXCEL|'Book1.xls'!*C2

Ask
Price =EXCEL|'Book1.xls'!*C3
Volume =EXCEL|'Book1.xls'!*C4
etc

Please see screenshot attached.

Henry: do you know of any freelancers that would be able to create an application to stream data from my broker into MC?

Henry: do you know of any freelancers that would be able to create an application to stream data from my broker into MC?

davidcolin, I've sent you an email on the matter.