Copying Data from Betfair to Excel.

Questions about integrating Excel and Cymatic, programming, formulae, etc

Copying Data from Betfair to Excel.

Postby xtrader2 » Wed Sep 21, 2016 12:36 pm

Hi Everyone,

I currently have an Excel file which I attach to Bet Angel. as I am using Cymatic more and more often (better software IMO) I am having to learn all about connecting my Excel sheet to Cymatic.

All my sheet does is (A) takes the names of horse racing times/date (B) takes the name of each horse in the race and (C) its current back price then copies them into columns in Excel.
As below:

(A) Good 21st Sep - 14:00 1m1f Mdn Stks

(B) Dick Tracy 3.35 3.95 3.90 3.95 3.90 3.95 4.00

(C) Dick Tracy 31.7% 40.9% 41.1% 40.5% 40.8% 40.6% 40.7% 30.3%

In order to do this I use a basic command of ='Bet Angel'!G9 which will copy the current back price of Horse Dick Tracey at any one point. The command is pulled from a Bet Angel sheet somebody else set up.

My question is how to I replicate that in Cymatic Trader?
xtrader2
 
Posts: 22
Joined: Thu Apr 30, 2015 10:14 pm

Re: Copying Data from Betfair to Excel.

Postby Gavin » Wed Sep 21, 2016 10:11 pm

Hi xtrader2,

I think the equivalent would be:

='Cymatic'!I8

(I8, that's a column I, as in the first letter of the word Idea).

Row 8, is the first row of selection data in the Cymatic spreadsheet.

Kind regards,

Gavin
User avatar
Gavin
Site Admin
 
Posts: 3886
Joined: Wed Jan 23, 2013 9:11 pm
Location: United Kingdom


Return to Excel - Help / Support

Who is online

Users browsing this forum: No registered users and 0 guests

cron