The Cash Flow Options Tracker

1. Make your own copy

Open the tracker and make your copy. When Google asks, click Make a copy. If it opens read-only instead, use File → Make a copy. Rename it whatever you like.

2. Turn on the ⚡ Cash Flow Tools menu

At the top of your sheet there's a menu called ⚡ Cash Flow Tools. The first time you click anything in it, Google asks you to approve it. Here's exactly what you'll see, so nothing surprises you:

• "Authorization required" → click Continue, then pick your Google account.
• "Google hasn't verified this app" → click Advanced, then Go to Cash Flow Options Tools (unsafe).
• Click Select all, scroll down, and accept. This lets the menu work with your spreadsheet and show its pop-up windows.

Don't let the word unsafe worry you. It only means this is a small private tool rather than a big public app. It can reach this one spreadsheet and nothing else. Not your other sheets, not your documents, not your email. You only do this once.

3. Two boxes, and you're done

Go to the Settings tab along the bottom. Enter your Starting Capital, the amount you're trading with, and your First Trade Date. Everything else fills in automatically as you log trades.

If a button says it doesn't have permission

That almost always means you're signed in to more than one Google account in your browser. Open the sheet in a window or Chrome profile where the account you made the copy with is the default account, and it'll work.

You don't step through versions one at a time. Pasting the latest file brings you current from wherever you are, however many releases you've missed.

The four steps

• Open your tracker, then Extensions → Apps Script.
• In the code window (Code.gs), click inside it, select all, delete, and paste in the new code. Save with Cmd-S or Ctrl-S.
• Go back to your spreadsheet tab and reload the page. The menu wakes up on reload.
• In the ⚡ Cash Flow Tools menu, click ⚙️ Apply Latest Updates.

You'll see a short confirmation of what changed. That's the whole update.

Good to know

• Your data is safe. Apply Latest Updates only refreshes formulas and structure. It never touches your Trade Log, notes, or cash moves.
• It's safe to click more than once. If you're already current, it says "Nothing to update."
• No new permission prompt. The update uses the access you already approved.
• If you see an "An update is ready" pop-up when you open the sheet, that's just the nudge. Do the four steps when it's convenient.