Excel Macro to capture Open / High / Low / Close value from a dynamic cell (X11) into cell AP11 to AS11 every 5 mins

[mahmad558]

I need a Macro to capture details from X11 cell which dynamically changes every second, i want to capture "Open / High / Low / Close" value data at an interval of every 5 mins and store in a new row from AP11 to AS11. This macro should fire up when values in S11 & S12 are filled by the user.

Open Value will be captured at 09:15:00 Hrs, Close Value will be captured at 09:19:59, between this time Highest and Lowest Value will also be captured, this will go on until the data feed in X11 is stopped i.e 03:30:00

I have little to no knowledge of VBA and Macros. Not sure if I can attach my fine here but have attached a screeshot

 

[mahmad558]

I need a Macro to capture details from X11 cell which dynamically changes every second, i want to capture "Open / High / Low / Close" value data at an interval of every 5 mins and store in a new row from AP11 to AS11. This macro should fire up when values in S11 & S12 are filled by the user.

Open Value will be captured at 09:15:00 Hrs, Close Value will be captured at 09:19:59, between this time Highest and Lowest Value will also be captured and stored in their respective cells, this will go on until the data feed in X11 is stopped i.e 15:25:00. FYI .... X11 has a formula =IF(COUNT(W15)=1,W15*25,"")

I have little to no knowledge of VBA and Macros. Not sure if I can attach my fine here but have attached a screeshot

 

[mahmad558]

I need a Macro to capture details from X11 cell which dynamically changes every second, i want to capture "Open / High / Low / Close" value data at an interval of every 5 mins and store in a new row from AP11 to AS11. This macro should fire up when values in S11 & S12 are filled by the user.

Open Value will be captured at 09:15:00 Hrs, Close Value will be captured at 09:19:59, between this time Highest and Lowest Value will also be captured, this will go on until the data feed in X11 is stopped i.e 03:30:00

I have little to no knowledge of VBA and Macros. Not sure if I can attach my file here but have attached a screenshot