I'm a new user, fairly good with excel formulas and trying to put together a fairly simple automatic horse racing lay spreadsheet (no trading) but seem to be stuck at the first hurdle. I'll list the points of what I'm trying to do below. I've scouted the forums but have not really found what I'm looking for. Any advice or a pointer to another post would be much appreciated. Compared to the complexities that some of you guys are doing I'm guessing this might be very straightforward for some of you.
I'm using one single betangel worksheet, one worksheet of my own and guardian to cycle through the races x minutes before the off overwriting the same worksheet. I intend to do some calculations and place lay bets just after this point allowing guardian to cycle onto the next race leaving placed lay bets to remain until the off. I'm happy with the way it cycles. I just need to solve the next two points before I can continue.
1. I need to grab the prices from the betangel worksheet at a specific point just after x mins and put these in my own worksheet to enable further calculations on these specific prices.
2. Before,during or just after this price grabbing I need to clear out the orders,report,odds,stake and status of what was left on the sheet before the market changed from the previous market.
I'm pretty sure I can complete the rest of the job if I could get past these two things as I know I can write the formulas to do it but I'm just not sure how to deal with these two things.
As I said, any help or guidance to another post would be much appreciated. I'm guessing this might be heading down the vb route, if so please could you advise where to drop the vb (workbook or worksheet)
Cheers
Chris