How to get an ascii file with unixtime to work with MC?

Questions about MultiCharts and user contributed studies.
Tresor
Posts: 1104
Joined: 29 Mar 2008
Has thanked: 12 times
Been thanked: 53 times

How to get an ascii file with unixtime to work with MC?

Postby Tresor » 29 Apr 2013

Hi,

I have a file with data in ticks that reads like this:
unixtime, price, volume
1366646385,122.620000000000,0.020000000000

Is there a way to plot the data in MC?

User avatar
Henry MultiСharts
Posts: 9165
Joined: 25 Aug 2011
Has thanked: 1264 times
Been thanked: 2957 times

Re: How to get an ascii file with unixtime to work with MC?

Postby Henry MultiСharts » 29 Apr 2013

Hello Tresor,

MultiCharts does not work with unixtime format. You need to convert unixtime into one of the supported date/time formats in order to import the data into MultiCharts.
Image
Attachments
date_time_formats.png
(5.84 KiB) Downloaded 613 times

Tresor
Posts: 1104
Joined: 29 Mar 2008
Has thanked: 12 times
Been thanked: 53 times

Re: How to get an ascii file with unixtime to work with MC?

Postby Tresor » 29 Apr 2013

Hello Tresor,

MultiCharts does not work with unixtime format. You need to convert unixtime into one of the supported date/time formats in order to import the data into MultiCharts.
Do I convert unixtime in the original file using e.g. Excel or do I convert unixtime using MC? If the latter then I have a problem doing this. Explained in the picture.
Attachments
unixtime.png
(71.34 KiB) Downloaded 533 times

Tresor
Posts: 1104
Joined: 29 Mar 2008
Has thanked: 12 times
Been thanked: 53 times

Re: How to get an ascii file with unixtime to work with MC?

Postby Tresor » 29 Apr 2013

BTW,

I want to get historical data to plot in MC from this http://api.bitcoincharts.com/v1/csv/

If someone has any idea how to get the 15 minute delayed feed http://bitcoincharts.com/about/markets-api/ to work in MC, please let me know.

User avatar
Henry MultiСharts
Posts: 9165
Joined: 25 Aug 2011
Has thanked: 1264 times
Been thanked: 2957 times

Re: How to get an ascii file with unixtime to work with MC?

Postby Henry MultiСharts » 29 Apr 2013

As I said above, MultiCharts does not work with unixtime format. You need to convert unixtime into one of the supported date/time formats in order to import the data into MultiCharts. You need to do that in any application that can do that. MultiCharts cannot do that.


Return to “MultiCharts”