Homework H08

They want more!

Learning Goal

Learn how to automate the gathering of business data from a cloud database, use dynamically generated SQL queries, and show the results in Excel.

Optional Prework

Consult my very short Introduction to SQL. If you need more, check the SQL readings in Resources. You will find reference materials to support your learning the SQL language.  Your favorite GenAI can help, too!

Context

It’s early morning, and you’ve barely taken the first sip of your coffee when Ms. Tradewell steps in. She doesn’t sit.
“That Excel app you built,” she says, “is quite useful.”
You straighten a little. “Glad to hear it.”
“None of my managers use the old reports anymore,” she continues. “They all use your app to check the largest recent trades.”
For a moment, you let yourself enjoy it. Ms. Tradewell is… almost cheerful, in her own way.
Then she tilts her head, already turning to the next task.  “I want something like that for our financial advisors,” she says. “They spend too much time hunting for historical stock data just to answer investor questions.”
“Well, Ms. Tradewell, I...”
“Good.” she cuts in, as if you’d already agreed. “Sometimes they need a basket of stock prices for a specific date. Other times they need a range of dates for a single stock. Can you handle that?” said she, now looking straight at you.
“I’m on it, Boss.”

Task

For this homework you must access HedgeTournamentBETA. Create two buttons and two comboboxes. When the user makes a selection and clicks on the button, the app connects to the DB, runs a dynamic query, and deposits the results in a well-formatted Excel list object.

Criteria/Requirements

Your work must satisfy the following requirements

• At start, the Excel spreadsheets does not show any data
• The 'Tickers for a date' button is light blue with black ink, the 'Dates for a Ticker' button is orange with black ink.  Neither button interferes with the data or the other buttons
• Show all columns from the StockMarket. Format the prices ($, commas, and two decimals) and the dividends
• There is only one list object to show the data. When the button is clicked, the list object changes style/color to match the button
• The column headers show the full names of the columns in the table. All names must be meaningful.
• Column size must not cut out data or headers (autofit).

-->

Hints and Tips

•  Google and GenAI are your friends as you learn the SQL language. Do not just hunt for the right homework answer. Ask 'why?' until you feel you understand what is going on.