Using Excel I would like to log the prices of say the top 5 in the market. Would be very grateful if someone can point me in the right direction by replying with some VBA code that log prices.
Many thanks
Price Logging
Moderator: 2020vision
4 posts
• Page 1 of 1
Price Logging
by Northern Wizard » Sat Sep 19, 2009 2:10 pm
- Northern Wizard
- Posts: 6
- Joined: Fri Jul 25, 2008 5:17 pm
by alrodopial » Sat Sep 19, 2009 8:47 pm
- alrodopial
- Posts: 1384
- Joined: Wed Dec 06, 2006 9:59 pm
by Northern Wizard » Sun Sep 20, 2009 11:48 am
Many thanks, think I can just about decipher what is going on and adapt to my needs.
From the code it looks like it copys the data to a new sheet once the next event is scanned. Am I right with that thinking?
Much appreciated.
From the code it looks like it copys the data to a new sheet once the next event is scanned. Am I right with that thinking?
Much appreciated.
- Northern Wizard
- Posts: 6
- Joined: Fri Jul 25, 2008 5:17 pm
by alrodopial » Sun Sep 20, 2009 6:29 pm
It copys the odds at sheet 'temp' when race is in running and when the race is just finished it back ups the data in sheets 'back' and 'lay' with calling the sub 'backupodds'
If Sheets("Data").Range("D9") = "Finished" And Sheets("Data").Range("D18") <> "Done" Then Call BackUpOdds
If Sheets("Data").Range("D9") = "Finished" And Sheets("Data").Range("D18") <> "Done" Then Call BackUpOdds
- alrodopial
- Posts: 1384
- Joined: Wed Dec 06, 2006 9:59 pm
4 posts
• Page 1 of 1
Who is online
Users browsing this forum: Google [Bot] and 41 guests