spreadsheet

[jimmy]

I downloaded this spreadsheet http://betfairtradingmindgames.blogs...maginable.html from another site in an attempt to gain some more knowledge about my trading,but I have not got a clue how to get my Betfair P&l on to excel.Has anyone got any ideas as to how to do this thanks.

[pez]

If you go into your p and l there is and bit to the right i think that says download p and l which then downloads all your data fro whichever time period or sport you specified

[jimmy]

Ok mate i have downloaded the spread sheet,have you got any idea what to do next?

[jimmy]

For example how do I save the spreadsheet to desktop?

[1/4 of a millionaire fund]

Right click on the link and select "save link as" then navigate to the desktop and save

[jimmy]

Cheers mate,once it is on the desktop do i import it or what.I pushed update and got an error message. you are trying to import trades dated date this date already exists in your date history sheet. any ideas?

[pez]

It sounds like it has already imported the data,if you go into the spreadsheet and delete any data that is in then,then import it it might work

[1/4 of a millionaire fund]

There's a reset button that I guess deletes any existing data, just press that then press the update button to load the data. I'm guessing it keeps track of any loaded data so only need to update the new data once a day so you don't get duplicates

[jimmy]

I think I got it on to an excel sheet,but it does not look any thing like the spreadsheet in the blog.