Getting complete Account Statement List for day

[Happy Harry]

I have searched but have not been able to find an example of how to do this. I want to be able to put every transaction for a given date range - an example of a race is below - into a spreadsheet so when both betting and laying in a race I can calculate the correct final after commission amount for all individual transactions throughout the day..

2013-02-21
18:15 2592373692 2013-02-21
18:09 AUS Bunb (AUS) 21st Feb / 18:11 R6 1200m Mdn / 2. Carson City
Back SP 22.43 113.00 Lost (113.00) xxxxxx
2013-02-21
18:15 2592373693 2013-02-21
18:09 AUS Bunb (AUS) 21st Feb / 18:11 R6 1200m Mdn / 12. Hells Lady
Lay SP 75.00 9.45 Won 9.45 xxxxxx
2013-02-21
18:15 2592373636 2013-02-21
18:09 AUS Bunb (AUS) 21st Feb / 18:11 R6 1200m Mdn / 9. Da Verrazzano
Back SP 5.10 100.00 Won 410.00 xxxxxx

Thanks

HH

[alrodopial]

The best you can find is under My Account / Account Statement
and then copy - paste.
If I remember correctly it's the same format with what you get when you ask for past records/results.They send you an Excel file with bets of the same format (?)

[Happy Harry]

The best you can find is under My Account / Account Statement
and then copy - paste.
If I remember correctly it's the same format with what you get when you ask for past records/results.They send you an Excel file with bets of the same format (?)

Yep that is exactly where it comes from. I would like to be able to obtain it for a date range [preferably] or just today and have it pasted into a spreadsheet. It should be possible because it looks like it is available from the api so hopefully someone can point me in the direction of a bit of VB code which grabs the information and shoves it into a spreadsheet.

HH