Data Recording Gruss to Excel using VBA - Horse Racing

Cerrado Publicado hace 7 años Pagado a la entrega
Cerrado Pagado a la entrega

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.

Excel Visual Basic

Nº del proyecto: #11157137

Sobre el proyecto

8 propuestas Proyecto remoto Activo hace 7 años

8 freelancers están ofertando un promedio de £162 por este trabajo

abhinovpankaj

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 vari Más

£166 GBP en 7 días
(58 comentarios)
5.4
robertal

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 h Más

£200 GBP en 5 días
(8 comentarios)
4.7
bhupendrayadav

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 presentat Más

£300 GBP en 5 días
(20 comentarios)
4.2
TulyakovN

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 en 5 días
(5 comentarios)
2.8
vijaypallampati

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 en 4 días
(1 comentario)
0.8
spkaran92

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 en 3 días
(0 comentarios)
0.0