21
Triggered betting / Writing numbers and currency to csv
« Last post by djmotion on 04 May 2026, 18:33 »Hey everyone,
I'm just wondering if there is a way to write currency and numbers to csv so that when I import it into excel, they are easier to work with. The way I have it set up, imports everything as text and for some reason it won't let me convert them to numbers or currency in excel which means I can't filter data properly. I have the write to file programmed as below;
["curr_bet"],["now_time_datestr"],["now_time_timestr"],["market_venue"],["market_length"],["selName"],["volChange"],["backPrice"],["layPrice"],["avgBack"],["estLay"],["bspBack"],["bspLay"],["stkAmount"],["selResult"],["backPL"],["layPL"],["avgBackPL"],["EstLayPL"],["bspBackPL"], ["bspLayPL"],["setProf"]
I'm just wondering if there is a way to write currency and numbers to csv so that when I import it into excel, they are easier to work with. The way I have it set up, imports everything as text and for some reason it won't let me convert them to numbers or currency in excel which means I can't filter data properly. I have the write to file programmed as below;
["curr_bet"],["now_time_datestr"],["now_time_timestr"],["market_venue"],["market_length"],["selName"],["volChange"],["backPrice"],["layPrice"],["avgBack"],["estLay"],["bspBack"],["bspLay"],["stkAmount"],["selResult"],["backPL"],["layPL"],["avgBackPL"],["EstLayPL"],["bspBackPL"], ["bspLayPL"],["setProf"]


Recent Posts
