Author Topic: Recording markets  (Read 5870 times)

Tags:
  • All members
  • Posts: 123
Recording markets
« on: 27 Nov 2013, 22:14 »
Hi!

Is there a way to record market info to Excel spreadsheets?

For example volume % in different situations (goes in-play, suspended) and final results.

Thanks.

  • Élite
  • Posts: 3698
  • Gender: Male
*
Re: Recording markets
« Reply #1 on: 02 Dec 2013, 05:58 »
hi
the only advise that i can give,is to use a trigger action write to excel.
with this you can write to excel whatever information that you want.
markv posted in this topic.
http://community.welldonesoft.com/triggered-betting-10/write-data-to-excel/


mcbee
Please read the following  disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • Moderator
  • Posts: 3597
*
Re: Recording markets
« Reply #2 on: 02 Dec 2013, 20:31 »
Hi
The attached trigger file will:
write selection volume % to column N on the market sheet at in-play
write selection volume % to column O on the market sheet at market settlement

Please ensure this setting is not checked:
Settings > General Options > Market Settings > Delete settled events automatically
Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 123
Re: Recording markets
« Reply #3 on: 02 Dec 2013, 21:32 »
Hi
The attached trigger file will:
write selection volume % to column N on the market sheet at in-play
write selection volume % to column O on the market sheet at market settlement

Please ensure this setting is not checked:
Settings > General Options > Market Settings > Delete settled events automatically

Thanks MarkV!  ;D

  • All members
  • Posts: 123
Re: Recording markets
« Reply #4 on: 05 Dec 2013, 21:37 »
Hi
The attached trigger file will:
write selection volume % to column N on the market sheet at in-play
write selection volume % to column O on the market sheet at market settlement

Please ensure this setting is not checked:
Settings > General Options > Market Settings > Delete settled events automatically

Could you please modify this to record

- Market's Matched Volume 0.1 minutes before start
- Market's Matched Volume at market settlement
- All selection's back price 0.1 minutes before start

With Market's name so I can search for example different track and time.

Hugely appreciated!!  :D

  • Moderator
  • Posts: 3597
*
Re: Recording markets
« Reply #5 on: 05 Dec 2013, 23:04 »
Hi
Please find attached the amended trigger file.

Market volume at 0.1 min before start will be in cell N1
Market volume at settlement will be in cell N2
Selection's back price at 0.1 min before start will be in column N
The market_name is available at cell B1 on all market sheets and is searchable using Excel Search.

I should draw your attention to Betfair rules relating to collecting market data.
http://bdp.betfair.com/index.php?option=com_content&task=view&id=31&Itemid=62#Historical%20Data%20License
I think what you have at the moment is OK, but any more could be pushing it a bit. Just so you know.
Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 123
Re: Recording markets
« Reply #6 on: 05 Dec 2013, 23:07 »
Hi
Please find attached the amended trigger file.

Market volume at 0.1 min before start will be in cell N1
Market volume at settlement will be in cell N2
Selection's back price at 0.1 min before start will be in column N
The market_name is available at cell B1 on all market sheets and is searchable using Excel Search.

I should draw your attention to Betfair rules relating to collecting market data.
http://bdp.betfair.com/index.php?option=com_content&task=view&id=31&Itemid=62#Historical%20Data%20License
I think what you have at the moment is OK, but any more could be pushing it a bit. Just so you know.

Do you mean recording maybe too many variables..? I'm not sure if I have courage to test it..

Just want to see if there are some patterns in certain greyhound races matched volumes. Over 10 000 in certain track and maybe around 5 000 on other.

If anyone has knowledge, I appreciate your help. Before trying...  ???

  • Moderator
  • Posts: 3597
*
Re: Recording markets
« Reply #7 on: 05 Dec 2013, 23:15 »
Hi
From the link the following is an example of collecting data which is not licenced:

"1.Allowing users to archive data from live before a market is settled so that the data can be interrogated in a database after settlement"

Basically, any data collected should be deleted after the market is settled and not retained.
Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 123
Re: Recording markets
« Reply #8 on: 05 Dec 2013, 23:23 »
Hi
From the link the following is an example of collecting data which is not licenced:

"1.Allowing users to archive data from live before a market is settled so that the data can be interrogated in a database after settlement"

Basically, any data collected should be deleted after the market is settled and not retained.


Forget this.. Read wrong :)

Maybe I just write those values down, if no-one knows where to get total matched volumes for greyhound results (for different tracks)?

  • Moderator
  • Posts: 3597
*
Re: Recording markets
« Reply #9 on: 05 Dec 2013, 23:25 »
 I don't think there will be any problem doing this using Time Machine, because all the Time Machine market data is fully licensed and can be used over and over again.
Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 123
Re: Recording markets
« Reply #10 on: 05 Dec 2013, 23:26 »
I don't think there will be any problem doing this using Time Machine, because all the Time Machine market data is fully licensed and can be used over and over again.

Yes. I will test it there but later when I have bought more races.

  • All members
  • Posts: 123
Re: Recording markets
« Reply #11 on: 05 Dec 2013, 23:31 »
Yes. I will test it there but later when I have bought more races.

Realized that data.betfair.com data includes VOLUME_MATCHED (sums the stakes of both back and lay bets). Will check it out.

EDIT. Anyone know if Betfair in data.betfair.com rounds VOLUME_MATCHED to tens, hundreds or thousands? Almost all volumes for greyhounds are less than 1000 and that isn't certainly correct. I bet it's tens...?

Great, got first minus vote. Maybe I have to write less.

  • Élite
  • Posts: 3698
  • Gender: Male
*
Re: Recording markets
« Reply #12 on: 06 Dec 2013, 06:44 »
hi GoalScorer
don not worry about to many variables as there is no way that betfair would know how many variables you use.
as for the betfair historical data, they are only interested IF you start monitoring every market from about 12 hours before the start time through to the actual finnish.
a few punters accounts have been closed due to this, because they monitored football matches for a long period through to the finnish,but when they explianed there system, betfair re-opned there accounts.


mcbee
Please read the following  disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

 

Please note, BetFair is seems to be currently OFFLINE