How to log multiple changing values 120 times over a 2 hour period.

Hi.
I'm looking to create a file that will log a minimum of 3 (but preferably up to 16 if it can include multiple worksheets) variables each minute for 120 minutes. The variables update every second.
The idea is that I can collect the various variable data 120 times and display it all in individual graphs graph formats.
After days of considering formulas and functions, I've realised there's going to have to be some coding involved but I have no experience of this whatsoever. Trying to adjust coding I've found on Youtube/web etc has been fruitless.
Any suggestions would be appreciated. Do I go through the commercial services route or post specifics here? I'm more than willing to pay or make a charitable donation etc...
Many thanks.
Michael.

How are you going to read the variables in to excel?

Assuming you can do that then all you need to do is to use ontime to kick of a simple macro to save your variables.

Look at this solution:

Please Login or Register  to view this content.

Originally Posted by mehmetcik

How are you going to read the variables in to excel?

Assuming you can do that then all you need to do is to use ontime to kick of a simple macro to save your variables.

My Excel sheet connects through Betangel to the changing odds in a soccer game on Betfair.com. I'm trying to track the varying prices throughout a match.
The variables are located as follows:
Sheet 1 at cells G9, G11 and G13
Sheet 2 at G9, G11
Sheet 3 at G9, G 11
Sheet 4 at G9, 11, 13, 17, 19, 21, 25, 27, 29

Many thanks for your code below. Do I just copy it into the 'View code' option on the tab?

MP