FIN310 • Course Hub Fall 2026

Build a simple stock-data tool using Google Sheets + Apps Script.

1. Let the user enter a stock ticker and starting date.
2. Use GOOGLEFINANCE to pull the stock name and daily closing prices.
3. Summarize the data into monthly closing prices.
4. Calculate monthly stock returns.
5. Create a simple interface or web app that allows the user to run the tool.
6. Submit the Google Sheet link, Apps Script code, sample output, and a short explanation of how the system works.

// Apps Script outline

function doGet() {

  return HtmlService.createHtmlOutputFromFile('index');

}

// Use GOOGLEFINANCE in the sheet for price/name fields,

// then summarize the last close of each month and compute monthly returns.

Scenario: A JU-type small private university is considering allowing students, especially international students, to pay tuition using a U.S. dollar stablecoin such as USDC.

This is a system-design project. You do not need to create a new stablecoin, use real money, or build a full blockchain system.

1. Design the payment flow: show how a student would pay tuition with USDC and how the university would receive the payment.
2. Choose the payment structure: explain whether the university should use a provider such as Coinbase or receive stablecoins directly in its own wallet.
3. Student-account matching: explain how the payment would be linked to the correct student ID, invoice, and tuition balance.
4. USD conversion: explain whether USDC should be converted immediately to U.S. dollars and transferred to the university bank account.
5. Compare payment methods: compare stablecoin payment with credit/debit card, ACH/e-check, bank wire, and international payment services in terms of cost, speed, convenience, and availability.
6. Risk and controls: address incorrect amounts, wrong blockchain/network, refunds, stablecoin depegging, wallet/custody risk, transaction records, and compliance.
7. Who benefits? discuss whether the system is more useful for domestic or international students and explain why.
8. Recommendation: should a small private university offer stablecoin tuition payments? Support your conclusion.

Required output: a written analysis plus one clear system-flow diagram. A webpage or prototype is optional.

Example flow: Student → USDC payment → Coinbase/payment provider → USD conversion → University bank account → Student tuition account updated.