Anyone know how to get the account P&L history from the site?
It will not open with excel or as a csv?

__________________
RaceCensus - powerful system testing software.
Now with over 399,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 31/03/2024
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg

Chrome

I've had to open them in OpenOffice first since Excel 2010 went on this machine. Resave using OpenOffice and then they'll open in Excel.

__________________
Pixie

"It's worth remembering that profit isn't profit until it's spent off the racecourse." -- Crash

Thought i had posted a reply, i open mine in XP mode in the windows 7 system or tey to upload to hotmail skydrive thing then re download.

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

Thanks for the replies guys, I'll give it a shot.
Normally it would just open in compatability mode by default, so something is screwy with their files. I remember a while back it had something to do with leading characters or something in the format.

__________________
RaceCensus - powerful system testing software.
Now with over 399,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 31/03/2024
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg

I don't have Open Office but tried the Skydrive thing, but it came back with some Rights Management error.

It's one of two things.
The first line is blank with no data, then on line 2 are the column headings, which is why Excel thinks it's corrupt (possibly).
One field name on line 2 is missing (blank).
Importing to Access also fails.

This applies to the betting history download to spreadsheet option.

I have written a small database which will successfully import that file and can share it if anyone wants it. It's in Filemaker Pro, but I can make it a runtime, so you don't need to have the program to run it.

I'm currently investigating the betting profit and loss statement.

__________________
RaceCensus - powerful system testing software.
Now with over 399,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 31/03/2024
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg

Never mind, the profit and loss statement doesn't contain the right info either.
No breakdown just a summary, so I'd rather input summary fields into the statement. Of course commission isn't included in the betting history and there is no option to download the account statement to spreadsheet.
Probably because they don't want people calculating commission paid

It's easy if you are a not betting many races, but so far in March, I've layed over 5,000 horses!

__________________
RaceCensus - powerful system testing software.
Now with over 399,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 31/03/2024
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg

Chrome, one way to work out your commission is as follows -

a) download your 'Betting History' for required period - this shows net profit/loss figures for each bet prior to deductions for commission

b) download your 'Betting Profit & Loss' - this shows net profit/loss per race after deductions for commission

a minus b gives total commission paid for period.

I have found I can download the files & open them in excel 2007 but for example to use the data, I had to multiply the profit figures by 1 to be able to sum them, dunno what that's about.