How to Automatically Refresh Stock Data in Excel

Learn how to configure your Excel spreadsheets to automatically update stock information at set intervals. This guide helps you keep your financial data current without manual intervention.

Emma Chieppor
13 steps
2 minutes

Microsoft Excel

Select Currency Data

Select the currency-pair data range starting at B4.

Open the Data tab.

Select Currencies.

Click Insert Data.

Select Price.

Refresh Data Settings

Select the currency-pair data range starting at B4.

Open the context menu for the selected currency cells.

Open Refresh Settings.

Select the Stocks data type.

Set the refresh frequency to Automatically every 5 minutes.

Click Refresh All.

Close the refresh settings pane.

Finish the Workflow

Done!

How to Automatically Refresh Stock Data in Excel

Learn how to configure your Excel spreadsheets to automatically update stock information at set intervals. This guide helps you keep your financial data current without manual intervention.

Emma Chieppor
13 steps
2 minutes

Microsoft Excel

Select Currency Data

Select the currency-pair data range starting at B4.

Open the Data tab.

Select Currencies.

Click Insert Data.

Select Price.

Refresh Data Settings

Select the currency-pair data range starting at B4.

Open the context menu for the selected currency cells.

Open Refresh Settings.

Select the Stocks data type.

Set the refresh frequency to Automatically every 5 minutes.

Click Refresh All.

Close the refresh settings pane.

Finish the Workflow

Done!