Excel help required

Find a developer for your Excel triggered betting needs and advertise your development service here.

Moderator: 2020vision

Excel help required

Postby Spinner » Thu Apr 01, 2010 3:26 pm

Hey, just started to trade as of late and want to keep track of all my trades in excel. I found a file that is used when trading horses. Now I trade football/tennis etc along with horses. Anyone able to modify this spreadsheet to accommodate my needs? I'd like it to link with my P&L from Betfair.

Here's the link - http://betfairtradingmindgames.blogs...maginable.html

I'd like someone to explain to me how to do it rather than just supply me with a solution! Then I can obviously apply it to other files in the future...

Thanks!
Spinner
 
Posts: 13
Joined: Fri Mar 26, 2010 4:39 pm

Postby 2020vision » Thu Apr 01, 2010 4:25 pm

Hi Spinner :)

hope you don't mind the little correction to your link?

Here's the link - http://betfairtradingmindgames.blogs...maginable.html

Have a nice day - Michael :)
User avatar
2020vision
Moderator
 
Posts: 604
Joined: Sun Feb 17, 2008 10:24 pm
Location: Nottingham

Postby Spinner » Thu Apr 01, 2010 4:35 pm

Woops! Thanks for that :)

When I saw that someone replied I thought someone had a solution :wink:
Spinner
 
Posts: 13
Joined: Fri Mar 26, 2010 4:39 pm

Postby Spinner » Fri Apr 09, 2010 11:29 am

No takers then? :(
Spinner
 
Posts: 13
Joined: Fri Mar 26, 2010 4:39 pm

Postby avago » Thu Apr 29, 2010 7:38 pm

As author of the sheet in question, I would like to say that it would be very difficult to change any of the code the sheet contains but it would be possible to add another module and write your own code to suit your needs.

I have never traded any other sports apart from horse racing, so have no idea of the data layout of the downloaded betfair spreadsheets.

You may have noticed that it does not accomodate any 'foreign' tracks, again because I've never traded them.

Ideally, it would be great if we could make something up that included most other sports, but that would need sample sheets from anyone interested.

Excel is a hobby of mine, and anything created would be free of charge.
Thanks,Nigel
avago
 
Posts: 7
Joined: Wed Jun 24, 2009 11:06 am
Location: uk

Postby xraymitch » Sat May 08, 2010 10:04 am

avago wrote:As author of the sheet in question,


Nigel, I just wanted to say a big thankyou for your excellent code which I am now using as a guide to learning VBA.

Thought you might be interested in a fix to your code that was causing me and others a problem (not able to find BettingPandL) which I have posted on

http://betfairtradingmindgames.blogspot ... nable.html

Keep up the great work :)


Ray 8)
xraymitch
 
Posts: 410
Joined: Wed Jun 25, 2008 7:06 am
Location: UK

Postby avago » Sat May 08, 2010 3:47 pm

Thanks for the fix Ray. Hope you find it useful.

Nigel
avago
 
Posts: 7
Joined: Wed Jun 24, 2009 11:06 am
Location: uk

Postby greenfingers » Wed May 12, 2010 10:29 am

Hi Nigel & Ray, If you have an updated version of the spreadsheet that you want to make available then I'd be glad to post it on the blog. You can send it to me at betfairtradingmindgames at yahoo.co.uk :)
Last edited by greenfingers on Sat May 15, 2010 6:01 pm, edited 1 time in total.
User avatar
greenfingers
 
Posts: 214
Joined: Mon Mar 23, 2009 3:10 pm

Postby smithdwsn » Thu May 13, 2010 5:08 pm

Yes, really you solved my same type problem. I was facing this type of problem and i was finding on internet but i could not got the proper solution. I tried it and i got success in it. Thank you.
smithdwsn
 
Posts: 3
Joined: Thu May 13, 2010 5:05 pm

Postby smithdwsn » Thu May 13, 2010 5:11 pm

You can easily solve because that option is there. I have used this option before many years but now i dont remember it. Please search or see the option in excel it will help definitely.
smithdwsn
 
Posts: 3
Joined: Thu May 13, 2010 5:05 pm


Return to Find an Excel developer

Who is online

Users browsing this forum: No registered users and 6 guests

Sports betting software from Gruss Software


The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.

Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.

Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.

He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.

We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.

cron