Data Recording Gruss to Excel using VBA - Horse Racing

Completado Publicado hace 7 años Pagado a la entrega
Completado 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. They are also included in the documents attached to this project post.

I think I've covered everything, if you have any questions please feel free to ask.

Excel Visual Basic

Nº del proyecto: #11152396

Sobre el proyecto

8 propuestas Proyecto remoto Activo hace 7 años

Adjudicado a:

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. I am also a native Eng Más

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

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

cgullapalli

Hi, I am good at Excel and vba.I have already seen the attached files. Looking forward to discuss in the chat.

£175 GBP en 2 días
(856 comentarios)
7.9
sargardon

Hello sir/madam, However, I am new here in freelancer.com I have over 10 years of experience in .Net programming. I have developed several applications that use betfair API and will be happy to work on your project Más

£222 GBP en 5 días
(109 comentarios)
6.8
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

£194 GBP en 6 días
(58 comentarios)
5.5