DDE Data Recording Macro problem?

Hi Guys,

New here. I am building a spread to analyze several securities trading indicators by extracting data from my trading platform. I found a template on your forum from 2012 that works great. The information updates in the cells and I have already applied a macro to record the entries as they change on any time interval I need.

My issue is how it is recorded. At the moment it simply begins filling in a column in a descending fashion to whatever range I want then essentially stops once it fills up the allotted cells. This is no good as I need the data to scroll like a live feed from top to bottom (Most recent to oldest). Basically have the live cell at the top then after each update have it bumped down a cell until it reaches...say 100 then is pushed out of the data range.

The current code is below. There are stop and start timer entries which aren't relevant to my problem.

Please Login or Register  to view this content.

Through my other research I found another code which does exactly what I need but, despite it being used live in a YouTube video I can't get it to work properly. Any thoughts on combining the two would be glorious.

Please Login or Register  to view this content.

The live data feed is at the top of the recorded data. But it does not insert the data right below it. So the first recorded entry would be right. So the live data is in say A1, Then the first recorded entry goes in A2 then the next is inserted into A3 and so on. What I need is for every new recorded entry to insert into A2 and bump the next oldest down one.

I have it working. All fixed. Thanks anyways.