Cymatic Trader Community

[cunninp6]

HI,

I've been using Cymatic for a while now and I've amended my excel spreadsheet to pull in data from another external source. The external source uses the horse ID (horse order) from the racecard but when I have non runners, these are reordered in Cymatic to the bottom.

Is it possible for me either i)Show the horse ID in Excel(I can see it in the Cymatic window) or ii)to have it so non-runners stay in their original place or iii)alteritively is there an API I can use to lookup the selection ID to see which horse it is?

Many Thanks.

[Gavin]

Hi cunninp6,

Sorry, the order in which the horses appear is determined by Betfair, Cymatic just displays the data. I am not sure, but perhaps you could re-order them alphabetically in your spreadsheet, by putting formulae in a separate sheet (for example Sheet2) that links back to the prices in the Cymatic sheet, so that the prices are shown in your new sheet2. Then you could sort the horses in sheet2.

Kind regards,

Gavin