Hi, i am trying to get the value. I have this stock market software which displays data on spread sheet. The column C updates automatically every sec and changes its value(Some time it does and sometimes it doesn't. Depends on the market). All i want is to calculate how much money traded in last sec if there was money it should shows me the money traded or else just zero. Somebody suggested this method but it didnt work.
You can do this by activating Iterative calculations in excel. Go to File>Excel options>Formula and enable iterative calculation
now you have to add reset and counter cells in one cell. Counter will update when ever your target cell change and value is recorded.
If Reset Cell (named as reset) will have value of 0 or 1. Counter(named as count) will have formula of =IF(reset=1,,count+1)
As you can see there is circular reference in formula for count as count=IF(reset=1,,count+1<wbr>). But you will not get error as you have activated Iterative calculation
Add serial number in Row A and your target values can be recorded in row B.
I
in Cell B52 add formula as =IF(reset=1,"",IF(count=$<wbr>A52,time,B52))
This is again circular referencing.
Drag this formula and your sheet will start recording with every refresh. your workbook should be open for this to function.
I had developed this sheet to capture and analyse stock quotes that changes frequently. I had taken data from web query with 15 sec refresh rate.
i am sorry i am new in excel and i am stuck with this thing please help me. i have created an image to show you guys how my data looks like in excel file and what exactly i want please help me.
You can do this by activating Iterative calculations in excel. Go to File>Excel options>Formula and enable iterative calculation
now you have to add reset and counter cells in one cell. Counter will update when ever your target cell change and value is recorded.
If Reset Cell (named as reset) will have value of 0 or 1. Counter(named as count) will have formula of =IF(reset=1,,count+1)
As you can see there is circular reference in formula for count as count=IF(reset=1,,count+1<wbr>). But you will not get error as you have activated Iterative calculation
Add serial number in Row A and your target values can be recorded in row B.
I
in Cell B52 add formula as =IF(reset=1,"",IF(count=$<wbr>A52,time,B52))
This is again circular referencing.
Drag this formula and your sheet will start recording with every refresh. your workbook should be open for this to function.
I had developed this sheet to capture and analyse stock quotes that changes frequently. I had taken data from web query with 15 sec refresh rate.
i am sorry i am new in excel and i am stuck with this thing please help me. i have created an image to show you guys how my data looks like in excel file and what exactly i want please help me.