search

FX31337 / FX-BT-Scripts

:page_facing_up: Useful scripts for backtesting.
MIT License
35 stars 39 forks source link

issue in converting #116

Open lion2131 opened 1 week ago

lion2131 commented 1 week ago

I got the error you see in the image while converting a csv into fxt

can someone be so kind to help?

image

source csv format

timestamp,askPrice,bidPrice,askVolume,bidVolume 2024-11-01 02:00,41786.197,41780.615,0.000045000000682193786,0.00004999999873689376 2024-11-01 02:00,41785.173,41779.663,0.000045000000682193786,0.00004999999873689376 2024-11-01 02:00,41785.673,41780.187,0.000045000000682193786,0.00004999999873689376

kenorb commented 1 week ago

Which pair is that? Is it BTCUSD? From where you've downloaded these CSV files?

lion2131 commented 1 week ago

US30, Dukascopy via Dukascopy node with this query

npx dukascopy-node -i usa30idxusd -from 2023-01-01 -to 2024-11-08 -t tick -f csv --date-format "YYYY-MM-DD HH:mm" -utc +120 --volumes

kenorb commented 1 week ago

Most likely the format of date is not expected, since you're specifying custom one with dashes. Valid datetime string is 2022.01.02 22:03:54.650. Please have a look at this sample CSV files: https://github.com/FX-Data/FX-Data-EURUSD-DS/blob/EURUSD-2022/EURUSD/2022/01/2022-01-02--22h_ticks.csv