forex software

Create and Test Forex Strategies

forex software

Skip to forum content

Forex Forum

Forex Software, Forex Strategies, Expert Advisors Generator

You are not logged in. Please login or register.


Forex Forum → Technical Matters → Representation of Time in Exported Data JSON File

Pages 1

You must login or register to post a reply

RSS topic feed

Posts: 4

Topic: Representation of Time in Exported Data JSON File

Hello Everyone,

Just wondering how the time stamp is derived in the exported json file from mt4? I'm having trouble converting it to a readable time/date format?

I've searched the forum for some answers but to no avail.

Thanks in advance.

Re: Representation of Time in Exported Data JSON File

The Data Export Script exports data intended to be read by EA Studio. Beside of that, the format is number of seconds after 01.01.2000.

Re: Representation of Time in Exported Data JSON File

Good night,

I'm trying to convert data from the QuantDataManager CSV to a json but initially I'm having problems with the date. You days You say the format is the number of seconds after 01.01.2000.

The first entry "time" in EURUSD_H4.json is 3682080.

If we execute the next Powershell command:

(Get-Date -Date "01/01/2000 00:00").AddSeconds(3682080) | Write-Host

the result is "12/02/2000 14:48:00" but when you export the data the column "From time" indicates the date "2007-01-01 00:00"

I think I must be missing something.

Re: Representation of Time in Exported Data JSON File

I have opened the script that exports from MT4 to JSON and I have checked that what it uses are not the seconds since 01/01/2000, but the minutes.

Using the minutes all the numbers match.

Posts: 4

Pages 1

You must login or register to post a reply

Forex Forum → Technical Matters → Representation of Time in Exported Data JSON File

Similar topics in this forum