Author Topic: Writing numbers and currency to csv  (Read 55 times)

Tags:
  • All members
  • Posts: 53
  • Gender: Male
Writing numbers and currency to csv
« 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"]

  • Moderator
  • Posts: 3720
*
Re: Writing numbers and currency to csv
« Reply #1 on: 05 May 2026, 08:22 »
Hi
In the trigger if you leave out quotation marks for the numbers it should work ok when importing to Excel e.g. the last two fields here import correctly as numeric

["now_time_datestr"],["now_time_timestr"],["market_venue"],["sel_name"],[back_price],[back_amount]  


Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

 

Please note, BetFair is seems to be currently OFFLINE