Record real time changing values horizonal at time interval

langa209

New Member
Joined
Aug 21, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
File Link

I would like to thank you all for your assistance to the excel community beforehand.

I have real-time stock information in Excel on column K for each ticker. I want to capture the price information at regular intervals horizontally for each day for example (every 1,5,10 or 15 minutes) in columns L for 9:30, column G for 9:45, N for 10:00 AM etc. (this is an example of capture the price that constantly changed for each ticker in column K every 15 minutes).

The link to the file is here File Link you will need the Microsoft stock plugin for this to work but it may work for you automatically if you have the latest version of excel.

Can someone please assist with this task ?
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

langa209

New Member
Joined
Aug 21, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
I have attached an image of what the spreadsheet looks like.
 

Attachments

  • Dashboard 2.PNG
    Dashboard 2.PNG
    30.2 KB · Views: 3

Forum statistics

Threads
1,144,571
Messages
5,725,059
Members
422,590
Latest member
Mikeyyy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top