1) Market Price
3) Instrument Type
4) Previous Close
5) Post close Pricing
It uses an VBA httpRequest and Yahoo finance API to Yahoo Finance Pricing.
Excel and VBA Craftsman offers experienced VBA Development: Complete GUI Driven Applications, Automated Reconciliations, VBA ODBC Database Data Mining, VBA Excel, Access, Outlook and Word Customization. VBA Custom Functions, VBA Concept Assessment, VBA integration of MS office applications into powerful single seamless solutions, Excel Help, Automate Excel, Excel Automation