I am a CFD stock trader. I need data of bid and ask price of a particular stock. The stock trading platform I use allows DDE export. And I am trying to create a sheet where data is automatically entered via Dynamic Data Exchange(This part i can do). The data coming from the dde source changes frequently. And I need a record of all the those individual data's. So every time the Bid/Ask price of the sheet changes, the data needs to be copied to a new cell or sheet and when again this bid/ask price changes the data needs to be stored in some other cell without erasing my previous data. By using my eyes it is virtually impossible to store or record all those data. Any help is greatly acknowledged. If this question is not understood please tell me i shall edit this post or create a new post.