I require assistance for which I would be happy to pay for the help.
I have managed to connect my Betfair/Betangel market to a excel spread sheet and require a bit of help in one area. How can I add some other columns that I have in my Market View screen into the spread sheet (I have attached a screen shot to illustrate what I would like)?
I particularly want to add the L.T.P. / High / Low and perhaps one or two other columns into the spread sheet.
I have been in contact with the Bet Angel support technician who could not help.
Thanks in anticipation.
Help Desperately Needed
I checked with support and they did respond to your questions and advised that the data you see in the spreadsheet is the only available data.
The LTP is available in column K in the standard spreadsheet.
Data such as high/low traded range is not available as standard in the spreadsheet.
One way around this would be to connect the sheet many hours prior to the start of an event and record the data every so often. But I'm not sure how viable this would be in terms of resources consumed by Excel when connecting to multiple markets.
Perhaps someone has already done this?
The LTP is available in column K in the standard spreadsheet.
Data such as high/low traded range is not available as standard in the spreadsheet.
One way around this would be to connect the sheet many hours prior to the start of an event and record the data every so often. But I'm not sure how viable this would be in terms of resources consumed by Excel when connecting to multiple markets.
Perhaps someone has already done this?
Off the top of my head I think the brilliant bit of work that Switesh did last week may have this info on if you connect it up earlier.
He connects his up 5 min(s)? before the race. Maybe if you extended that to 15mins it may do the job. Because of the way the markets behave and the way the money arrives - The late money is more relevant anyway. Worth a look viewtopic.php?f=31&t=8896
You may want to contact Switesh - He is one of the most intelligent and generous guys on this forum - Top guy
MG
He connects his up 5 min(s)? before the race. Maybe if you extended that to 15mins it may do the job. Because of the way the markets behave and the way the money arrives - The late money is more relevant anyway. Worth a look viewtopic.php?f=31&t=8896
You may want to contact Switesh - He is one of the most intelligent and generous guys on this forum - Top guy
MG
as 6th sense says ltp is already available.
it is possible to record/log the max and min ltp but only from the moment you open the market in excel, using circular references. in principle the min/max functions should do this but they often fail (why i do not know).
see this fred viewtopic.php?f=19&t=7461&p=59597&hilit=high+low#p59597
it is possible to record/log the max and min ltp but only from the moment you open the market in excel, using circular references. in principle the min/max functions should do this but they often fail (why i do not know).
see this fred viewtopic.php?f=19&t=7461&p=59597&hilit=high+low#p59597