Hi,
Can anyone help ? I want to be able to capture prices at certain times of the day i.e 2.00p.m, 3.00 p.m, 4.00 p.m and so on using the Bet Angel Multiple Spreadsheet and copy them into pre defined cells on another Sheet. The problem I'm getting is if I just copy a cell value to another cell it keeps updating in the other cell.
I've tried using formulas to do it but am not getting very far. My knowledge of VBA is pretty limited but I can do the basics. I'm assuming I need the Ontime VBA app to do it. Can anyone help ?
Capturing prices at certain times in Excel
-
evertonian
- Posts: 81
- Joined: Thu Apr 16, 2009 10:34 am
Yes but how do you get Excel to chart the prices at the various times.
For example, I have a basic template that has a countdown timer included til the start of the event. Say I want to log a price 3 hours, 2 hours, 1 hour, 30 min pre event what do I need to do to do this ? It's obviously not a problem if you're at your computer but if you're away from the computer I want Excel to log prices. I know Switesh had a similar spreadsheet for logging horse racing prices 5 mins from the off, which used charts and logged volume etc.
I'm assuming I need to run some kind of macro to log the prices at each interval ?
For example, I have a basic template that has a countdown timer included til the start of the event. Say I want to log a price 3 hours, 2 hours, 1 hour, 30 min pre event what do I need to do to do this ? It's obviously not a problem if you're at your computer but if you're away from the computer I want Excel to log prices. I know Switesh had a similar spreadsheet for logging horse racing prices 5 mins from the off, which used charts and logged volume etc.
I'm assuming I need to run some kind of macro to log the prices at each interval ?
-
evertonian
- Posts: 81
- Joined: Thu Apr 16, 2009 10:34 am
Yes I'll have a look at that.
Thank you. Very grateful for your advice.
Thank you. Very grateful for your advice.