Find Jobs
Hire Freelancers

Data Recording Gruss to Excel using VBA - Horse Racing

£20-250 GBP

Closed
Posted over 7 years ago

£20-250 GBP

Paid on delivery
Knowledge of horse racing useful but not essential. Requires detailed knowledge of VBA for latest version of Excel. Does not require experience of Betfair and Gruss Betting Assistant. If you need to test the VBA in a live environment I can walk you through the steps for linking the Spreadsheet to the Gruss software. This will involve creating a Betfair account (free) and downloading the Gruss Software for Betfair which is also free to use for one month. At no time will you have to place any bets while testing or deposit money into a Betfair account. I will be available during the project to carry out live testing if you do not wish to download the software or create a Betfair account. Obviously it will be much easier to measure progress if you have the software and account active. The Spreadsheet you will be working on is set up for data collection only, it will not trigger any bets. I have attached an image of the area of the spreadsheet that requires the VBA. Basically, I want to set it up so that at a set time it will activate the VBA and then work its way through the race times and record different bits of data as in the image. I have entered the data in the image manually to illustrate what I [login to view URL] sheet can move to the next race in the list by placing a special trigger in one of the cells. I will provide the correct triggers for each action once the project is underway. The reason for needing a Set Time option is that the Excel sheet will sit on a VPS so can then run autonomously 24/7 if required. If I decide I'd like to activate the VBA before or after the set times I'd like to use the START and STOP buttons on the sheet. The four buttons in the top right currently run with very basic macros behind them. The start and stop buttons are not connected to anything yet. I have formulas on the sheet so a "Y" in a column will signify that the race it's currently viewing is a qualifier and the race time needs to be recorded. For other races I will need odds recording if the race being viewed matches one in the FTYA column. The FTYA column entries are generated elsewhere. The 'Stop' button should end the VBA. This is just in case I begin an update by accident or already have all the info I need. When there are days with lots of meetings and races it's going to take a good few minutes for the update to run through every race, I'm prepared for that. There is a small delay when moving to the next race in the list. This is due to the link between the Spreadsheet and the software. I just need the data recording side to be slick and quick. Once it scrolls through all the races in the quick pick list and records the data change Status Cell from IN PROGRESS to DONE. End the VBA. I have mapped out the order in which the VBA actions should operate. I can forward that to anyone interested in bidding on this project. I think I've covered everything, if you have any questions please feel free to ask.
Project ID: 11157137

About the project

8 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
8 freelancers are bidding on average £162 GBP for this job
User Avatar
Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
£166 GBP in 7 days
4.9 (58 reviews)
5.4
5.4
User Avatar
Hello there - I am an Excel Genius so I can get Excel to do what I need it to. I also have an interest in horse racing and knowledge of Betfair directly, having written an auto-scalping modeller. Unfortunately you have not attached your examples to the project specification so I cannot follow your text inline, however I can understand that it is a simple automation task using the Gruss Betting Assistant. I have just looked at the GBA and it is trivial to interface with so that should not be an issue, especially if we are just collecting data. More than happy to discuss this with you and ensure you get what you need so drop me a message and we can touch base. /RAL.
£200 GBP in 5 days
5.0 (8 reviews)
4.7
4.7
User Avatar
I am a postgraduate in finance (MBA) with more than 5 years of experience having expertise in Excel and VBA. Currently working in an MNC Analytical company on a large financial model including dashboards and presentations to board for a leading US bank. Please have a look at my portfolio or contact me for more details on my previous completed projects. I can help you with your current requirement as well as any further requirement with low cost of work. I can deliver the work in lesser time than others while maintaining the superior quality of work.
£300 GBP in 5 days
4.7 (20 reviews)
4.2
4.2
User Avatar
Understand, how to do this job. Skills in VBA, experiance of working in excel, access two years. No problem with this job and those tasks from discription.
£30 GBP in 5 days
4.3 (5 reviews)
2.8
2.8
User Avatar
I am having 6+ years of experience in VBA automation and I have developed many tools and I can assure that I will deliver an right product please award me the project
£222 GBP in 4 days
5.0 (1 review)
0.8
0.8
User Avatar
Hi, As said in my profile i am VBA developer I have good knowledge in MS office application If you are interested , please let me know Regards Prabhakaran S 7506014371
£150 GBP in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SERBIA
belgrade, Serbia
0.0
0
Member since Apr 28, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.