Freezing live external data in a cell after a set time period ?

[DJ88888]

Hi,


I was wondering if it is possible to freeze the live data linked to a cell from an external source after a certain time period, say 10 mins. The live data would then continue to feed into the next cell down until the next 10 mins is up and so on ...


I would like to create my own moving average from the cells that have had their 10 allotted mins used up.


I have no trouble getting the live data (in this case it is a currency pair, EURUSD) into the cell of a spreadsheet.

Creating the moving average should also not be a problem.


It is this next step of freezing the cell or at least taking an automatic reading of the value of the cell when the allotted time is used up, that I need help with.


Thank you

 

[NARAYANK991]

Hi ,


You say that when the 10 min. time period has expired , live data will continue to feed into the next cell until the next 10 mins. are up. How are you doing this moving on to the next cell ?


Won't the act of moving on to the next cell , itself ensure that the contents of the cell which was earlier receiving the live data are frozen at their last value ?


Narayan

 

[DJ88888]

Hi Narayan, thanks for your response.


That should actually have been part of the original question, is it possible to program the data to move to another cell, and how do I do that ?


Or do you have another suggestion of taking a reading of the live data at certain time intervals and those readings ending up in a column one below the other ?


Thank you


DJ

 

[NARAYANK991]

Hi ,


The Timer event can be used to carry out a specified action at a frequency.


So each time the action is carried out , the activecell can be moved , so that the cell in which the data is stored changes.


Narayan