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"]