Percentage change in dynamic price

Yes - it will be possible though a sample file would help to better illustrate your actual requirements in terms of ranges etc...

It might help if you outlined some results - are we to assume you want to use the last close price of the prior date as the basis for comparison ?
(i.e. time comparison is an irrelevance per se)

It might be simplest to add this value to each transaction and then use a Pivot Table with Calculated Field

See attached for very basic example though note:

a) I modified your formula in Col A
b) I reduced amount of data being stored for sake of sample file size
c) Pivot created in XL2007+ format will not work (interactivity) with earlier versions
d) Pivot is sourced from Dynamic Named Range (_PTData see Name Manager for more info.)

Originally Posted by Hidai

I am trying to produce the same pivot table you created in the file without success. could you explain how did you create the pivot table so that the dates will follow through in the right order ( when i create it, they dont come in the right chronolgical order)

Originally Posted by DonkeyOte post#6

See attached for very basic example though note:

a) I modified your formula in Col A

Given I can't see what you have it's hard to comment but note that per the above the first thing I did was adapt the formula in Column A so as to coerce the date strings to date serials.

If your dates remain as "strings" you won't get a date serial based sort, rather they will sort alphabetically (they are strings)