Me again!!
Would there be the slimmest of chances (this time maybe not neccesarily on a wet wednesday) that the full and proper course-name could be added to the betangel interop routine (not dictating where, but anywhere in the currently unused cells in the I1:K6 range would be perfect [even adding it in the row below marketId in the hidden column A would work]).
The reason being, I have a lookup function that is derived from the actual betfair data, per course, and don't wish to have to introduce yet another lookup (of a lookup) to coerce Strat to Stratford etc. etc. As it stands, the race identifier comes in as a single string along the lines of: Strat 10th Jun - 14:45 2m5f Nov Hcap Chs. Obviously, this is easily parsed, but the truncation of the name still exists.
I know this is a simple change but am aware that there are potentially bigger fixes that need to be tackled. However, not having the proper data for the course-name really limits or inhibits simple development inside VBA (in terms of slotting against betfair data).
[edit] - a non functional fix of course would be to provide a simple lookup file of BA course-name->Betfair course-name, e.g:
Attaching a sheet similar to the above, as a response, would do the trick
TIA
Excel -Course Name
-
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
On my phone so can't view the file but I know they messed around with the abbreviations so probably best to download the latest as some are now 5/6 letters whereas I'm sure it used be limited to 4 at one time
https://docs.developer.betfair.com/disp ... reviations