Create an Excel Macro (using VBA) to automatically refresh stock data

In this Excel tutorial, I will be walk you through how to write a simple macro using Excel VBA to automatically refresh stock data table in Excel.

PS: This is one of the most requested video and I thought I finally have the time to record the tutorial.

Buy Me a Coffee? Your support is much appreciated!
----------------------------------------------------------------------------------------------------------------
Venmo: @Jie-Jenn

Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------

#ExcelTutorial #Stock

[Jonowl]

Used this for tracking updates to a job board XML feed. Works perfectly! Thank you.

[chrisbowyer]

Thanks! Finally, something that is not only simple but works!

[MohitSharma-hyst]

thanks man, this is exactly what I wanted

[chetandudhane]

Thanks.... this was really helpful.... wanted just this 👍🏽

[sivamani]

Thanks, your videos is very use full, i am trying to create macro to auto refresh AFO file, but i am keep on getting errors, macro not working correctly, can you please help?

[robertcameron]

Hey Im trying to track stock data and I don't want each current days info to change ever again, so how would I tell excel to have the stocks of today to no longer update after 8pm on the current day they were entered

[SS-ubqz]

Im having difficulty with the Sub Main(). It says that sub or function not defind. It also doesnt change colour like yours does to red. The Sub is blue and the Main is in a black font

[DrezelRS]

What if you wanted to store the data and date for historical trend purposes?

[claded]

Can this be applied to a protected sheet macro that unprotects and reprotects the sheets on refresh over and over? And if so can someone tell me how to input my refresh macros to this. Here is my refresh macro that protects and unprotects the sheet

Sub Macro1()
'
' Macro1 Macro
' Queries Refresh
'

'
ActiveSheet.Unprotect
ActiveWorkbook.RefreshAll
ActiveSheet.Protect DrawingObjects:=False, Contents:=True, Scenarios:= _
False, AllowFormattingColumns:=True, AllowFormattingRows:=True, _
AllowInsertingHyperlinks:=True, AllowUsingPivotTables:=True
End Sub