Live scores for football

Samples developed by Cymatic and others. Please share your spreadsheets here.
Forum rules
Users can post their spreadsheets here, to share with others and for discussion purposes.
If you download a spreadsheet from here, please carefully test any strategies yourself before using it with real money. Cymatic accepts no liability for any spreadsheets in this forum.
Now bring on the robots! Happy automated trading... :)

Live scores for football

Postby Gavin » Mon Jul 27, 2015 4:08 pm

Hi,

I have attached a spreadsheet which aims to display the live score of a football game, by deducing it from the prices in the Correct Score market.

To use it, open the Correct Score market in Cymatic, then when connecting to Excel please type Correct Score as the worksheet name, instead of simply accepting the default suggested worksheet name (which is usually Cymatic or Cymatic2, etc).

Please note that it requires the Correct Score market to have money available to trade, otherwise the deductions can't be made and it will simply display the score as "UNKNOWN". So at least one score must have money available to back and to lay. It will therefore usually also display "UNKNOWN" when the market is suspended (assuming the money disappears when the market is suspended).

Please use in demo mode initially and add any other checks that might be necessary. Also, when creating a strategy you might want to add an extra condition to check whether the market is active or suspended, because the spreadsheet usually won't be able to calculate the score when the market is suspended, for the reasons already stated.

Another method of obtaining live scores in Excel, would be to create Visual Basic code that downloads the scores from websites (such as Goals365.com), but these websites might be delayed or not refreshing frequently, so you could run into trouble if you try to build a strategy that takes it scores from website sources.

Kind regards,

Gavin
You do not have the required permissions to view the files attached to this post.
User avatar
Gavin
Site Admin
 
Posts: 3832
Joined: Wed Jan 23, 2013 9:11 pm
Location: United Kingdom

Return to Excel - Sample Spreadsheets

Who is online

Users browsing this forum: No registered users and 0 guests

cron