Excel REST Stock Data Uploader

I track daily stock prices in an Excel workbook and now need those figures pushed automatically to a financial platform that exposes a REST API. The task is limited to sending data; the script never needs to pull anything back.

Here is what I’m after:
• Code in either VBA (embedded in the workbook) or Python (run from the same folder) that gathers the latest rows of ticker, date, open, high, low, close, volume, packs them into the JSON body expected by the API, and posts it over HTTPS.
• Flexible mapping so I can add or rename columns without rewriting the whole macro.
• Simple authentication handling—right now the API uses a bearer token that refreshes every 90 days; please make the token value easy to update in one place.
• Clear status feedback inside Excel or the console confirming “sent” or describing any HTTP errors.

Acceptance will be a short live test: I’ll supply the endpoint, token, and a dummy spreadsheet. Your script should return a 200-OK and I must see the stock price record appear on the platform.

Please comment the code generously and include a one-page setup note so I can tweak ranges or tokens in future.