Extract value from cell(s) at a specific time

Hello guys, I am a stock trader who is trying to build a scanner for some of my strategies, and Excel is crucial to my daily operations. However, I am not at all familiar with macros so I was wondering if someone could get me started on one of my Excel-challenges here.

One of the numbers I look at are the so called Opening Range of the first 15 minutes from 09:00-09:15 (Highest point of the first 15m and the Lowest point of the 15m of a session)

I have the highest point of the day and the lowest point of the day live fed into two columns (High in H-Column and Low in I-Column, so I need to collect those numbers at 09:14:59.

I have attached a workbook here and I hope I explained it well enough.

Thanks

Something that you might run into is getting the document to fire at a specific time. To my knowledge (which, please someone correct me if I am wrong) Excel cannot fire a macro at a certain time. What it can do is fire a macro after a certain amount of time has passed. You can do this several ways, but it requires you to run the macro prior or get the process going some other way.

What I would probably do is create a secondary excel enabled macro document that pulls information from the source document and set the macro to run upon opening the workbook. Once completed you can use windows Scheduled Task to make sure that the excel document is opened every day at a certain time.

There might be other, more elegant, ways of doing this, but this is the method I would take.

Thank you for the response Frabulator,

I do think it is possible to have this data extracted based on the system clock. There was a thread on a forum about it, but I could not 100% relate to the solution in it, mostly because I am a super newbie to macro. But if you can extract data from certain dates, I think logically you should be able to do it from a clock also.

I obviously can do this manually to, of course... Hope there is an automated solution to this

It IS possible of course.

Google about;

Application.OnTime

Originally Posted by jindon

It IS possible of course.

Application.OnTime

Good to know! Thank you

Thanks! Never heard about Google. Interesting stuff