I'm trying to create a database of stock and currency prices which i can go
on to analyse.

The problem is that when Excel updates the information (which it sources
from a table on a website) it overwrites the old information with the new
information. How can I configure Excel to insert the new information after
the old information, so that it builds up a historical account of prices,
rather than continuously writing the new information over the old?

I dont want to be stuck with a "historic" account of prices that cant go
back any further than 6 days!

Thanks in advance for your help.

Josh