Author Topic: Possible to open the tm.db file in Excel ?  (Read 772 times)

Tags:
  • All members
  • Posts: 9
  • Gender: Male
Possible to open the tm.db file in Excel ?
« on: 13 Jul 2019, 12:45 »
Hi

Is it possible to open the tm.db file in MS Excel (Or even MS Access) and review the information from there rather than having to play it through the Time Machine?

The reason I'm asking is that I'm looking to identify the first horse in a race to trade at 1.7 In Play. It would seem a far more efficient use of my time to search for this entry in a database than it would be to watch the replay of each race (And even then if two horses are running closely together In Play then it can be difficult to tell which one traded at 1.7 first)

If I try to open the tm.db file via Excel I am prompted with a Data Link Properties screen identifying the Data Source (Which correctly points at the tm.DB file) and to supply a Username ('Admin' is pre-populated) and password (Which I don't have) 

Is it even possible to open the tm.db file in Excel ? and if so - How can I do this? 

Or can anyone suggest a more efficient way to analyse the data to get the information that I need

Thanks
Hughsiepops

  • Administrator
  • Posts: 8821
  • Gender: Female
*
Re: Possible to open the tm.db file in Excel ?
« Reply #1 on: 14 Jul 2019, 09:48 »
Hello!

The terms and conditions of the BetFair Historical Licence, which is at the core of Time Machine, directly forbid storing the price and volume data in open format, so you will not be able to open the database with any tools other than Time Machine.

If you are interested in a set of data containing the names of horses who reached the price of 1.7 first, you can request a customised historical data report, and we can discuss the pricing and other details.

If that sounds like an option, then please either email me at oxa at welldonesoft.com or send me a private message.
Always try your triggers in Test Mode before switching to real money!

Follow us on Twitter.

Join our WhatsApp chat!

Присоединяйтесь к официальному Telegram-каналу!

 

Please note, BetFair is seems to be currently OFFLINE