Excel 2010: Retain changing cell values - web query

[John19]

Currency.xlsx

screenshot.png

I have a web query updated every 1 minute and returns live currency changes. It’s displayed in a column containing 127 currencies and against each, the percentage change (+/-) is shown, e.g

GBP/USD +0.15%.
EUR/USD -0.30%

What I need is to display in another column for each currency, a “+” or “-“ sign, only if the last 3 consecutive changes were + or - , if not leave blank.

I’m trying to indicate the direction each currency is going (either + or -).

The main issues is, at every minute updates, figures are refreshed and I can’t find a way for excel to store the last 3 changes (NOT JUST UPDATES BUT ACTUAL CONSECUTIVE CHANGES FOR EACH CURRENCY).

The percentage figures are refreshed every minute and so are overwritten - I have to keep a track of the last 3 changes constantly.

I spent a whole month of sundays reading excel questions online and stil going nowhere.

I have also posted this question at these sites:

http://www.excelguru.ca/forums/showt...ng-cell-values
http://www.excelforum.com/excel-gene...web-query.html
http://www.mrexcel.com/forum/excel-q...ll-values.html
viewto...p=20637#p20637
http://www.ozgrid.com/forum/showthread.php?t=192362

[NoSparks]

This will maintain the last 3 changes.
Required to be an .xlsm to use macros.
Just open the file and let it update.
Hope it is of some help.