News
Current BetFair Sports API status: online. Current BetFair Games API status: online.

WellDone Betting Bots -- May 23, 2012, 01:31
Pages: 1
Print
Author Topic: Exporting logs to Excel  (Read 162 times)
Tom
Just registered
*

Reputation: +0/-0
Posts: 2


« on: November 23, 2010, 10:22 »

Hi,

When I open the statement in Xfeeder it is layed our well and easy to read, when I import a log file into excel I can't seem to get the delimiter right to make it easy to read and as a consequence it is very hard to read and or filter because it is all over the place.

How would I import any of the channel log files into excel so they are easily readable (not to mention filterable) just as the statement is in Xfeeder itself?

Thanks.
Logged


WellDoneSoft
Tim Vetrov
Administrator
Hero Member
*****

Reputation: +21/-1
Thanks!
Gender: Male
Posts: 1014



WWW
« Reply #1 on: July 01, 2011, 13:18 »

Go to c:\program files\X-Feeder\logs\statement\ folder and copy files of the days you need to your folder.
Then change the extension of the files to csv and open them with Excel.
Delete first row.
Then click to the "Text to columns", select "delimiter" -> "comma".
The columns are:
Date/time, Channel name, Selection name, Type of the transaction, Amount, Price, Win/Lose, P/L, Funds after, Game ID, Market ID, Max market P/L
Logged


Pages: 1
Print
 
Jump to:  

Anone designed by pixelslot.
Powered by SMF 1.1.16 | SMF © 2011, Simple Machines