Hello, I have 10 years of experience in VBA and other similar technology. I have already created a similar project which takes data live and refresh the chart as ticker charts. I think what you are looking for, I would create in google spreadsheet rather than excel. we can discuss this if you want.
look forward working with you.
Regards,
Vats