Dear all,
I need an excel file (or a program that can export in excel file) that, using the free versione of Betfair API, can import the followig info in two separate sheet:
1. My account statement
The query have to be launched by a button.
I would like to be able to select the period range of data; for example, if I select from 01.01.2012 to 20.01.2012, the result in excel file sheet will be all the transaction made in that period.
Everytime I refresh the query the old value have to be cleared and the new will appear
In attachement you can find a template file (MY_ACCOUNT_V2) that describe the fields that I need.
2. Sport Market data
The query have to be launched by a button.
Before to launch the query I would like to be able to select the following data:
- Sport Market (Soccer, Tennis, etc); if it is not possible, I am interested in soccer market)
- Period range of Event data; for example, if I select from 01.01.2012 to 20.01.2012, the result in excel file sheet will be all the event that will be occur in that period.
- Event (multiple choice)
- Subevent (multiple choice)
- Subevent Selection (multiple chioce)
In attachement you can find a template file (MARKET_DATA) that describe the fields that I need.
This excel file contains few lines of the result of importing data from:
[login to view URL]
and then choosing Soccer --> UK back and lay prices
[login to view URL]
If it possible, I'd like to have the possibility to choose the language or to set Italian as default.
The whole excel file (sheets and code) have to be freely modifiable.
Please respond only if really interested and if you already know how to use Betfai API.