Mount Inflection logo Mount Inflection

MOUNT INFLECTION · ALPACA SETUP

Setup help

← Back to the three-phase setup

Google permissions: what to click and what you are accepting

Why Google asks for permission

Your private Sheet contains a Google Apps Script. Google asks you to authorize it before it can read your newsletter, open its controls, check its own file, contact Alpaca, run on a schedule or send your setup receipt. Copying the Sheet does not grant that access.

  1. At Authorization required, click OK or Review permissions, whichever Google shows.
  2. Select the same Google account that receives your MI newsletter and owns this copy.
  3. Read the requested access below. If Google shows permission checkboxes, select the required permissions only if you accept them. Then click Allow or Continue, as shown. Leaving required access unchecked can prevent setup or scheduled checks from working.
  4. Return to your private Sheet. Reopen ⚙ MI Paper or ⚙ MI Live → Trading controls if the window closed.

What you are accepting

  • Read Gmail: Google grants mailbox-wide read-only access. This code searches for MI issues; the permission is not limited to MI messages. It cannot edit or delete email.
  • Use this Sheet and show its controls: manage this copy’s setup and activity display.
  • Contact external services and manage timers: connect to Alpaca and run the schedule after you explicitly start it.
  • Send email: Google’s send-mail permission is broader than one recipient. This code uses it for the setup receipt to your connected Gmail account after Start.
  • Read Drive file metadata: Google grants metadata access across Drive, not file contents through this scope. This code requests only its own Sheet’s ID, type, Trash status and version for the stop safeguard.

If Google says “Google hasn’t verified this app”: the copied script has not completed Google’s OAuth verification. This warning is separate from our software tests. Read it and review the requested access yourself; proceed only if you trust the code and accept that access. If Google blocks access or your work account needs administrator approval, stop and ask for help.

Google may ask again when a new copy or an update needs authorization. Accepting Google permissions does not start trading. Saving also leaves trading off. Only the separate preview, confirmation and Start action enables the schedule.

Google’s explanation of Apps Script permissions ↗ · Google’s unverified-app warning ↗

Stop automation, restore a Sheet or delete a copy

Use Pause before deleting. Closing a browser or deleting a worksheet tab does not turn automation off.

  1. Open ⚙ MI Paper → Pause trading or ⚙ MI Live → Pause trading in your private copy. Confirm Trading is OFF in Trading controls.
  2. Check Orders and Positions in the matching Alpaca account. A request already in progress or accepted by Alpaca may still fill. Pausing does not cancel orders or close positions.
  3. Keep the original Sheet and its journal while you need them to review an order or holding. After checking the account, you can move your copy to Trash.

What the file safety check does

The updated templates read only their own Google Drive file’s ID, type, Trash status and version. They check before scheduled account work and again before each new order submission. If the file is trashed, unavailable, cannot be verified or changed since Start, the script turns trading off, removes its scheduled check and retry timers, and clears the old preview and real-money confirmation.

The version check also blocks a file that was moved to Trash and restored between checks. It is conservative: editing or renaming the Sheet while trading is enabled can require a fresh preview and Start. Ordinary closing and reopening does not stop the schedule.

This is a check before submissions, not an instant Google Drive deletion event. It cannot undo an in-flight request or an order already accepted by Alpaca.

Recover your original copy

  1. Restore the original file from Google Drive → Trash. Do not reset its journal or start a second copy against the same account.
  2. Open Trading controls and check the reason trading stopped. Review orders and positions in Alpaca.
  3. If no unfinished run needs reconciliation, click 1. Preview to start or restart, review it, check the confirmation box and click Start Paper or Start Live. Live requires typing I ACCEPT LIVE TRADING again.
  4. If a prior run is unfinished or an order’s outcome is uncertain, keep trading off and ask for help with the displayed error. Keep keys out of email. Do not bypass the journal or make another copy to force a restart.

Restoring a stopped copy does not enable it. Deleting a Sheet does not cancel your newsletter subscription or Pro billing.

Check timers or a copy you cannot open

Sign in to the same Google account at Google Apps Script → My Triggers ↗. After Pause or a detected file-safety stop, this copy should have no runScheduled or continueRun trigger. Remove only triggers belonging to that copy. Other copies and trading systems have separate schedules.

If you cannot regain access, review or revoke that dedicated API key pair in Alpaca. Review already accepted orders and holdings separately.

Permission and older copies

Google requires read-only Drive metadata permission for this check. Google scopes that permission across Drive metadata; this module requests only its own Sheet’s file metadata, not other files or their contents. Review Google’s permission screen yourself.

New copies from the current website include this safeguard. Existing private copies do not update automatically. Pause an older copy before updating its module in the same Apps Script project; preserve its keys, account binding and journal. A new copy does not import the old copy’s ownership journal. Find the files for your Sheet →

Help me find my Alpaca keys
  1. On a computer, sign in to Alpaca ↗. In the account selector, choose Paper Trading for a Paper Sheet or Live for a Live Sheet.
  2. Open API Keys on the dashboard. If the card is missing, look under Manage Accounts or Account Management and find the matching account.
  3. Copy the Key ID and its matching Secret Key. Use Generate New Key if you need a pair. Alpaca shows the secret when it generates the pair. A replacement can disconnect apps using the old key.

Enter both values in the ⚙ MI Paper or ⚙ MI Live → Trading controls dialog in your own private Sheet copy. Google Apps Script saves them in User Properties, outside the worksheet cells. See how the keys are stored and how to keep the copy private →

Google’s Make a copy creates a separate Sheet and script project in your Google account. Mount Inflection gets no access to either through the copy action. See what a Google copy includes → · Live limits, alerts and disconnect →

Alpaca → your private Google panel · button map, not a connected account
Copy from the correct card
Key ID → Key ID field
Copy its matching secret
Secret Key → Secret Key field

See Alpaca’s illustrated key guide ↗

Return to Phase 2 · Save & close →

Setup limits and sizing examples

THE AMOUNT, IN PLAIN ENGLISH

A $100,000 account. Use 100%.

Account equity$100,000
Strategy capital100%
Base used to size entries$100,000

If a newsletter’s new entry uses 5% of strategy capital, its reference size is $5,000. The 5% is illustrative, not a current signal or a fixed size for every entry.

100% does not mean “spend $100,000 now.” Each supported new signal gets its own calculated amount. Equity is rechecked at execution. The website example does not save a setting or change your account.

Try the example with your own numbers

Calculator only. These numbers stay in this page and do not save or change your account.

Enter all three numbers to see the calculation.

WHEN YOU GET TO SETTINGS

What do the other boxes mean?

These checks can pause new orders. They are not stop-losses or guarantees against losses. Use numbers without a dollar sign, comma or percent sign.

How much of my account?

Strategy capital (%) sets the base for sizing newsletter entries. In this guide: 100 on a $100,000 account = $100,000 of strategy capital.

Code name: CAPITAL_PERCENT

How big can one new order be?

Maximum new order ($) is the dollar ceiling for one new entry. Example: a $5,000 entry fits a $5,000 cap. A $4,000 cap pauses it; it does not turn it into a $4,000 order. Exit orders are not capped by this setting.

Code name: MAX_ORDER_DOLLARS · illustrative caps, not recommendations

How much exposure altogether?

Maximum gross exposure (%) adds the absolute size of longs and shorts. On $100,000 equity, $60,000 long + $20,000 short = 80% gross exposure, not 40%.

The Free Sheet is long-only and uses a 100% gross ceiling. It does not enable shorts or leverage.

In Pro Paper, find this under Pro exposure limit. A 100% cap corresponds to $100,000 total exposure in this example. A higher cap is a separate margin/risk decision; allocating 100% does not automatically authorize it.

Code name: MAX_GROSS_PERCENT

Can it sell stocks short?

In Pro Paper, Enable paper shorts appears during setup and under Trading controls → Edit settings afterward. Eligible short entries use whole shares and require an account and a stock that qualify. With shorts off, an issue containing a short entry pauses. Short positions can lose more than their initial allocation.

Use Edit settings to change the account percentage or max per new order with your paper keys still connected. See the Pro Paper steps.

Free Paper also lets you change the account percentage or max per new order under Trading controls → Edit settings. See the Free Paper steps.

Code name: ALLOW_SHORTS
Two more settings in the manual code-editor route

MAX_ENTRY_PERCENT — one entry as a share of the whole account. On $100,000 equity, 5 means a $5,000 entry ceiling. Both this ceiling and the dollar cap must allow the entry. The Sheet templates set this to 100 internally and ask you for a separate dollar cap.

CASH_BUFFER_DOLLARS — cash to keep aside. The manual route lets you enter a dollar reserve. The current Sheet templates use 0 internally. That is a software setting, not a recommendation to hold no cash.

These are different from strategy capital. Do not copy 100 into every box.

Choose your guide

Older Google Sheets sidebar guide

MOUNT INFLECTION · GOOGLE + ALPACA

Set up using the older sidebar

Use this guide if your Sheet shows an MI Paper or MI Live menu and opens a sidebar.

Live means real money. Try Paper first. Connecting and previewing leave trading paused; starting the timer is a separate choice.

Have these ready first

  • A computer and Gmail — use the Google account that receives your ordinary Free or Pro issue. Have an issue from the past eight days, not just a welcome email.
  • An unused Alpaca account — no positions, open orders, or other bot. Paper is simulated; no deposit is needed.Live must already be approved and funded.
  • That account’s Key ID and Secret Key — these let your private Google copy connect to Alpaca. Show me where to find them ↓

Allow extra time for first-time Google permission screens. You can complete the Sheet route without a code editor or an AI subscription.

YOUR PRIVATE GOOGLE SHEET · FIVE STAGES

Set up Free Paper.

Use the steps below if you prefer the original MI Paper or MI Live sidebar in your private Sheet.

  1. STEP 1 OF 5

    Make your own copy.

    Click the green link below. Google opens in a new tab. Check the Google account at the top right, then click Make a copy. Your new Sheet opens automatically.

    1 · Make my Free Paper copy ↗1 · Make my Pro Paper copy ↗1 · Make my Pro Live copy ↗

    Keep the copy private. If Google shows a shared preview instead, choose File → Make a copy. Copying does not connect Alpaca or start trading.

    In the Google copy dialog
    2 · Click in Google
    Make a copy
  2. STEP 2 OF 5

    Open the setup panel.

    At the top of your Sheet, click MI PaperMI Live, then Open setup & status. A panel opens on the right. If the menu is missing, wait for the Sheet to finish loading, then refresh once.

    Click Check my Free emailCheck my Pro email. Check that it finds the issue you expect. You can stop here if you only want to read the newsletter.

    If Google asks for permission

    Choose the same Google account as your newsletter inbox and review the requested Gmail-read, external-request and timer permissions. Grant them only if you accept that access. If a security warning blocks you, stop; do not bypass it. Permission by itself does not start trading.

    If the panel closes after permission is granted, open the MI menu and Open setup & status again.

    In your own Google Sheet
    1 · Top menu
    MI PaperMI Live ▾
    2 · In that menu
    Open setup & status
    3 · In the right panel
    Check my Free emailCheck my Pro email
    See where to click in Google Sheets
    Click MI Paper in the top menu. Then click Open setup & status.
  3. STEP 3 OF 5

    Make sure the Sheet sees your Alpaca account.

    In the right-hand panel, expand 2. Optional: set up simulated trading. Scroll down inside the panel to the key fields.

    In your private Google Sheet, paste the Key ID into the first field and its matching Secret Key into the second. Click Check account (read only).

    Compare the result with your Alpaca dashboard:

    1. Account. Match Paper or Live and the last four digits of the account number.
    2. Equity. Compare the total account value shown in both places.
    3. Two zeros. Existing positions and Open orders should both show 0 for a new setup.

    If those match and the limits appear, go to Step 4. The account check places zero orders.

    If the account is wrong or the check fails, stop here. Make sure the Key ID and Secret Key came from the same Alpaca account and that the account mode matches your Sheet.

    Find your Alpaca keys ↓

    In the setup panel on the right
    1 · Paste Key ID
    PaperLive Key ID
    Your private key goes here
    2 · Paste Secret Key
    PaperLive Secret Key
    ••••••••••••
    3 · Click
    Check account (read only)

    What a successful check looks like

    Illustration with sample values

    PaperLive account ending 1234
    Paper equityLive equity · $100,000.00
    Existing positions · 0
    Open orders · 0

  4. STEP 4 OF 5

    Choose the amount. Save while paused.

    The settings appear after the account check. For the example in this guide, the account is worth $100,000 and strategy capital is 100%. Type 100 in the capital-percentage field to use that example allocation.

    You do not type a $100,000 balance into the setup. Alpaca supplies your actual equity. A different account balance produces different dollar amounts.

    Maximum new order ($) is a separate limit you choose. It must allow an entry’s calculated amount or that action pauses; it is not silently made smaller. See easy examples for every setting ↓

    Open Exposure and shorts and review both choices before continuing. A Pro short signal pauses the issue if shorts are disabled. Do not turn on margin or shorts just to clear an error.

    Click Save & continue. Your settings are saved and trading is paused. There’s one last check: preview your newsletter.

    In the limits section that opens after the check
    Example allocation
    Use this much of my Paper account (%)Strategy capital (% of paperlive equity)
    100
    Choose your own cap
    Maximum new order ($)
    Your dollar limit
    Open and review
    Exposure and shorts ▾
    Maximum gross exposure (%)
    Allow eligible stock shorts
    Save, still paused
    Save & continue
  5. STEP 5 OF 5

    Preview your newsletter. You’re done for now.

    In the same panel, click Preview newsletter. Check that the issue date and Alpaca account are the ones you expect. The preview shows what the issue proposes, including any new entries, exits and estimated amounts. An issue with no new entries is normal.

    Your setup is saved. Trading is paused.

    Once you’ve reviewed the preview, you can close the Sheet and come back later. If the preview shows an error or anything looks wrong, leave trading paused.

    In the setup panel after you save
    Click
    Preview newsletter

Come back when you’re ready

Start and first-run checks are separate from setup. Open these only when you need them.

What did I just test?

Check account (read only) verifies that your keys can read the intended Alpaca account. Preview newsletter checks that the Sheet can read the issue and show what it would do with your settings. Both checks run while setup is paused and place zero orders.

If you want to see an order go through the full workflow, use a separate Paper account and the Paper guide. After you start its timer, check Refresh status and look for the matching order in Alpaca when a qualifying issue calls for a trade. An issue with no new trades may produce no order.

A practice order placed directly in Alpaca only tests Alpaca’s order screen. Keep practice orders in Paper. In a Live account, an order can fill before you cancel it, and cancellation cannot undo a fill. Alpaca order statuses.

Optional: start simulated tradingOptional: start real-money trading

Reopen your private Sheet. In the top menu, choose MI PaperMI Live → Open setup & status. Click Preview newsletter and review the current issue before starting.

  1. Check the box confirming you reviewed the preview and settings.
  2. Click Start paper timer. This uses simulated money.
  1. Check the real-money authorization box.
  2. Type I ACCEPT LIVE TRADING exactly.
  3. Click Start live timer. This enables future real-money orders. Losses are possible; short-sale losses can exceed the initial allocation.

Starting turns on future scheduled checks. It does not submit an order immediately or buy all existing model holdings.

After you start: check the first run or pause

The Free timer checks on Fridays around 9:45 a.m. New York time (approximately ±15 minutes).

The Pro timer checks daily around 9:45 a.m. New York time (approximately ±15 minutes); trading depends on the market session and a qualifying issue.

After the first scheduled session, reopen the setup panel and click Refresh status. Check Alpaca for actual orders and fills. Missing email, account changes or exceeded limits can pause the workflow.

To stop future submissions, click Pause. It does not cancel accepted orders or close positions.

Beta: a complete fresh-subscriber scheduled order-and-fill cycle has not been verified for these public templates. The illustrations identify controls; they do not prove an executed trade or promise model returns.

Free Paper details and recovery notes

Pro Paper details and recovery notes

Pro Live details and recovery notes

Current Google Sheet templates and files

For a new setup, use Make a copy. Google copies the Sheet and its Apps Script into your account. Keep your copy restricted. The script already comes with the Sheet.

For an existing private copy, pause trading and use the recovery notes and files for its exact tier and Paper or Live mode. Update the original Apps Script project to preserve its account binding and position journal.

Legacy manual Apps Script setup

For a current Google Sheet, use the files for your template.

This separate route uses a new Google Apps Script project. It takes more steps. Do not combine it with the Sheet route or overwrite an existing connected setup.

  1. STEP 1 OF 11 · EMAIL

    Find your newsletter in Gmail.

    Open Gmail in the Google account you will use for this setup. Your subscription must deliver to this inbox.

    Search for Mount Inflection Free weekly view. Free arrives weekly on Friday. Not subscribed? Join Free first.

    Search for Mount Inflection Pro daily view. Use your ordinary daily issue. Not subscribed? See Pro.

    Open your latest ordinary issue from the past eight days. Scroll to Automation data · JSON near the bottom. That block tells the script which new entries and exits the model issued.

    You should see

    An ordinary delivered issue with the automation block. A welcome email, sample, or private test does not count. If it is missing, you can prepare Steps 2–8, but wait for a qualifying issue before previewing.

    In Gmail · control map
    Search at the top
    Mount Inflection Free weekly viewMount Inflection Pro daily view
    Open latest ordinary issue
    Email subject → open message
    Scroll to the bottom
    Automation data · JSON
  2. STEP 2 OF 11 · ALPACA

    Choose an empty account for this setup.

    Open Alpaca in a new tab ↗. Sign in, then use the account switcher.

    No Alpaca login yet? Use Alpaca’s sign-up option and complete its registration yourself, then return here. If you have no unused account available, stop and ask Alpaca about your account options. Do not reset or empty an account just to follow this guide.

    Choose an unused Paper account. The Paper banner means simulated money, not your real brokerage funds. No deposit is needed.

    Choose your approved, funded Live brokerage account. This is real money. If you do not have an approved and funded account, finish that with Alpaca first.

    Start with no positions, no open orders, and no other trading bot in this account. Use separate accounts and Google projects for Free and Pro. The script does not buy all existing model holdings when you start.

    You should see

    The exact account and mode you intend to use. Do not reset an account that another system is using.

    In Alpaca · control map
    Upper-left account menu
    Your account name ▾
    Choose account mode
    PaperLive
    Check before continuing
    Positions: 0 · Open orders: 0
  3. STEP 3 OF 11 · API KEYS

    Get the two keys from Alpaca.

    Click the account name at the upper left, then Account Management. Find the API Keys card for the account you chose. Some dashboard layouts show the card directly.

    This page can show Live and Paper keys together. Check the endpoint printed inside the card. The banner at the top is not enough.

    Confirm the endpoint says https://paper-api.alpaca.markets. Use that Paper account’s Key ID and Secret Key.

    Confirm the endpoint says https://api.alpaca.markets. Use that Live account’s Key ID and Secret Key.

    For a new, unused account, use Alpaca’s key-generation control and complete its security check yourself. Copy both values to a private password manager. Alpaca shows the secret when it is generated; do not expect to reveal it again later.

    Do not regenerate keys another app uses. Paper keys cannot be used for Live. Keep the two values private—you will paste them into Google in Step 8, not here.

    You should have

    A Key ID and its matching Secret Key for this one account. The screenshots deliberately exclude both secrets.

    In Alpaca Account Management · control map
    Find the matching card
    API Keys
    Read the endpoint
    paper-api.alpaca.marketsapi.alpaca.markets
    Copy the two values
    Key ID + Secret Key → private storage
  4. STEP 4 OF 11 · GOOGLE

    Create a blank Google project.

    Open Google Apps Script ↗

    This link opens Google’s code editor. It does not install or start anything. Google runs the finished script on its servers, so your computer does not have to stay on.

    1. Check that Google is using the same account as your newsletter inbox.
    2. Click New project.
    3. Click Untitled project at the top. Rename it MI Free Paper.

    Keep the project private. Do not replace code in an existing trading project.

    You should see

    A file called Code.gs with a small starter function. Keep this Google tab open.

    Google Apps Script home · button map, not a connected account
    1 · Upper left
    New project
    2 · New project title
    Untitled project → MI Free Paper
  5. STEP 5 OF 11 · CODE

    Replace the starter code.

    You do not need to write code. Copy the complete file below without changing it. This is the common v1.0.1 beta script for Free/Pro and Paper/Live—not the separate Google Sheet-copy template.

    Open the code instead ↗

    1. In Google, click Code.gs, then click inside the editor.
    2. Select all the starter text: Control+A on Windows or Command+A on Mac.
    3. Paste the copied code. Click Save project (the disk icon).

    Do not paste your Alpaca keys into the code. They go in separate settings in Step 8.

    If Copy pastes the wrong thing, click Open the code instead, select all of that file, and copy it with Control+C (Windows) or Command+C (Mac). Return to Code.gs, select all, and paste again. The first line begins /* MI newsletter automation.

    You should see

    A long script, with checkConnections available in the function menu beside Run. Saving code does not start trading.

    In Google Apps Script · control map
    1 · Left file list
    Code.gs
    2 · Inside the editor
    Select all → paste the complete script
    3 · Top toolbar
    Save project · disk icon
  6. STEP 6 OF 11 · GOOGLE SETTINGS

    Show the hidden settings file.

    1. Click the gear icon: Project Settings.
    2. Under General settings, check Show “appsscript.json” manifest file in editor.
    3. Click Editor in the left sidebar.

    “Manifest” is Google’s name for this project’s settings file.

    You should see

    appsscript.json listed beside Code.gs. Click it for the next step.

    In Google Apps Script · control map
    1 · Left side
    ⚙ Project Settings
    2 · General settings
    ☑ Show “appsscript.json” manifest file in editor
    3 · Return to files
    Editor · < > icon
  7. STEP 7 OF 11 · PERMISSIONS SETUP

    Paste the Google settings.

    Open the settings instead ↗

    1. Click appsscript.json on the left. Check that this filename is highlighted—not Code.gs. Select all the original text.
    2. Paste the settings you copied. Click Save project. If copying failed, use “Open the settings instead,” select all, and copy with your keyboard.
    3. Look under Services. If Gmail is missing, click + → Gmail API → v1 → Add. Review any terms yourself.

    The script needs to read Gmail, contact Alpaca, and manage its timer. Google grants mailbox-wide read-only access, not access limited to one sender. This script searches for MI issues; it cannot change or send email. Google asks you to approve these permissions when you first run it in Step 9.

    You should see

    The saved settings file and Gmail under Services. You have not authorized an order by pasting either file.

    In Google Apps Script · control map
    1 · Left file list
    appsscript.json
    2 · Inside the editor
    Select all → paste the Google settings
    3 · Top toolbar
    Save project · disk icon
    4 · Left side
    Services → Gmail
  8. STEP 8 OF 11 · KEYS + TRADING AMOUNT

    Paste the keys. Choose how much to use.

    In Google, open Project Settings → Script Properties → Add script property. The left box is the property name. The right box is its value. Add one row for each setting below, then click Save script properties.

    For dollar and percentage settings, enter numbers without symbols: use 20, not 20%; use 100, not $100. Copy text values such as free, paper, and false exactly as shown. The examples explain the math—they are not recommended settings.

    Account equity means the account’s total value after liabilities—not its available buying power. CAPITAL_PERCENT scales each newsletter entry; it does not set a separate spending ceiling for all positions. MAX_GROSS_PERCENT is the separate combined-exposure check: it counts long and short positions together, rather than subtracting one from the other.

    MI_TIER
    free
    ALPACA_MODE
    paper
    ALPACA_PAPER_KEY
    Paste the Paper Key ID from Step 3.
    ALPACA_PAPER_SECRET
    Paste its matching Secret Key.
    ALPACA_LIVE_KEY
    Paste the Live Key ID from Step 3.
    ALPACA_LIVE_SECRET
    Paste its matching Secret Key.
    CAPITAL_PERCENT
    The share of total account equity assigned to this strategy. Choose a number greater than 0 and no more than 100. This is a percentage, not a dollar balance.
    MAX_ENTRY_PERCENT
    The most one new entry may use, as a percentage of total account equity (greater than 0, up to 100).
    MAX_ORDER_DOLLARS
    Your dollar cap for one new order (at least 1). It does not cap exit orders.
    MAX_GROSS_PERCENT
    Your cap for combined long-plus-short exposure, as a percentage of total equity. Free: greater than 0, up to 100.Pro: greater than 0, up to 200; above 100 requires margin. This is an order check, not a guaranteed loss limit.
    ALLOW_SHORTS
    false — Free is long-only.
    Choose true only if you allow short selling and the account has margin and available borrow. With false, an issue containing a short entry pauses instead of skipping that trade. Short losses can exceed the initial allocation.
    CASH_BUFFER_DOLLARS
    The cash amount you want kept aside. Enter 0 only if you choose no reserve.

    The same $100,000 example

    Account equity $100,000 × CAPITAL_PERCENT 100 = $100,000 of strategy capital. A 5% newsletter entry is $5,000. Both entry caps must permit it, or it pauses.

    Use the calculator · Understand every limit

    Project editors can read these properties. Keep the project private. Step 9 supplies one final property: EXPECTED_ACCOUNT_ID.

    You should see

    Your chosen settings and matching key pair saved in Script Properties—not in the code, a spreadsheet cell, or an AI chat.

    Google → Project Settings → Script Properties · button map, not a connected account
    Left box
    CAPITAL_PERCENT
    Right box · example
    100
    After all required rows
    Save script properties
  9. STEP 9 OF 11 · READ-ONLY CHECK

    Connect and pin the exact account.

    1. Return to Editor. In the menu beside Run, select checkConnections. Click Run.
    2. If Google asks, review the requested access yourself. Use your newsletter’s Google account. If access is blocked or the warning is unfamiliar, stop—do not bypass it.
    3. Open Execution log. Look for connections_ok_no_orders. Compare accountSuffix with the last four digits of your account number in Alpaca. The mode should say paper.
    4. Copy the exact value labeled accountId. Go back to Script Properties. Add EXPECTED_ACCOUNT_ID and paste that value. Save.

    The account ID is not your account nickname. This check reads the account; it does not place orders.

    You should see

    connections_ok_no_orders with the correct tier, mode, and account. If it fails, fix the reported problem before continuing.

    In the Apps Script editor
    1 · Function menu
    checkConnections
    2 · Toolbar
    Run
    3 · In the log
    connections_ok_no_orders · check accountSuffix
  10. STEP 10 OF 11 · PAUSED PREVIEW

    Install the timer, then preview.

    1. In the function menu, select installSchedule. Click Run. This creates the timer but leaves trading paused.
    2. Select previewLatestIssue. Click Run.
    3. Read the Execution log. Check the account, issue date, entries, exits, reference dollars, and limits.

    The Free timer checks on Friday around 9:45 a.m. Eastern.

    The Pro timer checks daily around 9:45 a.m. Eastern. Closed-market/review-only issues create no orders.

    Google’s time can vary by about 15 minutes. If there is no ordinary issue with the required footer, wait for one. An older preview is not permission to trade historical signals today.

    A successful preview does not guarantee every order will pass later checks. At execution, exits can fill before a new entry fails a cash, combined-exposure, or whole-share limit. A paused script may therefore still leave you with changed positions.

    You should see

    First schedule_installed_trading_paused, then preview_no_orders. No new actions can be a valid result. Do not enable if you do not understand the preview.

    You can stop here and leave trading paused. Step 11 is only for when you choose to enable future orders.

    Use the function menu beside Run
    1 · Select, then Run
    installSchedule
    2 · Select, then Run
    previewLatestIssue
    3 · Look in the log
    preview_no_orders
  11. OPTIONAL · YOUR FINAL CHOICE

    Turn it on—or leave it paused.

    Enable Paper · simulated money

    After reviewing the preview, select enablePaperTrading in the function menu and click Run.

    Enable Live · real money

    1. In Script Properties, add LIVE_CONFIRMATION.
    2. Enter the exact value I ACCEPT LIVE TRADING and save.
    3. Return to Editor. Select enableLiveTrading, then click Run yourself.

    This enables future real-money orders. It can buy or sell supported stocks; Pro may also short or cover. Losses, slippage and fees are possible. This beta has not completed a verified fresh-subscriber live trading cycle.

    Enabling submits no immediate order. The next eligible timer run can trade. Do not run runScheduled manually.

    Click Triggers (the clock icon), edit the installed trigger, and set failure notifications to immediately. After the next scheduled run, open Executions to check its result. Then return to Editor, select showStatus beside Run, and click Run. Read the Execution log and check actual orders and fills in Alpaca.

    To stop future orders

    Select pauseTrading and click Run. This removes this script’s timers. It does not cancel accepted orders or close positions; an in-flight order may still fill. Check Alpaca.

    You should see

    trading_enabled for the chosen mode, or paused if you stop it. A Google “Completed” row alone does not prove a broker fill. If you see paused_needs_review, inspect the account before resuming; never erase the journal to bypass it.

    Live only · Google Script Properties · control map
    Left box
    LIVE_CONFIRMATION
    Right box
    I ACCEPT LIVE TRADING
    Save this explicit choice
    Save script properties
    To start or pause in the Apps Script editor
    To enable · select, then Run
    enablePaperTradingenableLiveTrading
    To pause · select, then Run
    pauseTrading

That is the setup.

Google reads the matching newsletter on its timer. The script starts with new signals; it does not copy the existing model portfolio. It exits only positions it owns, then checks eligible new entries. You still need to review errors and broker activity.

Beta, not a guarantee: the common v1.0.1 package passed 48 mocked software tests. A private Free predecessor completed a paper cycle; a fresh subscriber installation, Pro broker cycle, and live-money cycle for this package remain unverified. Paper uses simulated money. Execution, costs, borrow availability, and results can differ from the model. Only supported US equities are covered; no crypto or cash borrowing for long entries.

Full setup and recovery notes ↗ · Download the full package

OPTIONAL · AFTER THE WALKTHROUGH

Stuck in the manual code-editor route?

This prompt is for the separate 11-step manual route. If you get stuck there, tell your AI the step number and the error—not your keys. The main Sheet route above uses its own setup panel.

Read or manually copy the prompt

Help with the manual code-editor route

Google is signed into the wrong account

Use the Google account that receives your MI newsletter. If you have multiple accounts open, try a separate browser profile with only that account signed in. Do not move an already-connected trading project to a different account.

Run is greyed out or the functions are missing

Save the complete Code.gs from Step 5. Select checkConnections beside Run. If Google reports a syntax error, check that you copied the whole file, not the webpage around it.

Google blocks access or Gmail permissions fail

Stop at the permission screen. Check the account, manifest and Gmail service in Steps 4–7. A managed Google account may require administrator approval. Do not bypass an unfamiliar security warning.

The account check or preview fails

Confirm the Paper/Live choice and matching keys, the exact EXPECTED_ACCOUNT_ID, and your required sizing fields. The account must be dedicated, without untracked positions or open orders. Read the error. Do not loosen your limits or reset the account just to make an error disappear.

I want to change the trading amount later

After a completed cycle: run pauseTrading, edit the sizing properties, run installSchedule, preview again, then explicitly enable the same mode. Preserve the existing journal. For a different account, tier or Paper/Live mode, use a separate project and dedicated account; do not strand existing holdings by repointing this project.

Official UI references: Google projects · Google settings files · Alpaca API keys. Screenshots show the real apps with private details excluded; labels may vary as those apps change.

AI tools and Paper test results

OPTIONAL ALTERNATIVE · CHATGPT OR CLAUDE

Read the issue. Review the plan. You decide.

You can work through the newsletter with your AI agent instead of setting up a Google script. Start with the research. Connect a brokerage only if you want help checking the newsletter against positions you already hold.

  1. Give your AI the newsletter.

    Add the Mount Inflection Free Reader to ChatGPT or Claude. It finds published Free issues and links to the original research: dated hypothetical model signals, not brokerage fills. It cannot read private Pro issues or place trades.

    On MI Free? Email works too. Ask your AI to read the latest MI Free email through an email connection you choose to authorize. No email connection? Paste just the newsletter into the chat, without private account details. No broker or Google script is needed to review it.

    On Pro? Give the AI your own Pro issue by email or paste. The public Free Reader will not fetch it. Before connecting email, review the app’s mailbox permissions; paste just the issue if you do not want broader inbox access.

    Read or manually copy the prompt

    These are custom reader connections, not approved public-directory listings. AI app access, usage limits and workspace rules vary. “MI Free” means your newsletter plan—not a promise that every AI feature is free. Browse the public research without an AI connection.

  2. Link your brokerage separately, if you want to.

    Only reviewing the newsletter? Skip this step.

    Use your broker’s official connection instructions. Check the account and Paper or Live mode with a read-only balance check. Never use a trade to test the connection, and never paste brokerage passwords or API keys into the chat.

    Alpaca’s ChatGPT Live plugin cannot place orders. Its Paper plugin can place simulated orders. Other connections need their own capability check.

    Which connections can actually place orders?
    • ChatGPT + Alpaca Paper: can submit simulated orders. Official Paper plugin ↗
    • ChatGPT + Alpaca Live plugin: can monitor a live account, but cannot submit, change or cancel live orders. Official Live plugin ↗
    • Claude + Alpaca Trading API MCP: a separate, more technical setup can support orders. Its account mode, enabled tools and permissions determine what it can do. This is not the MI reader. Alpaca’s setup instructions ↗

    Checked November 5, 2026 against Alpaca’s plugin guidance. Other brokers and AI apps have different limits. Do not assume a connected account has an order-placement tool.

  3. Ask for a preview—not an immediate trade.

    Have the AI show the issue date, new entries (model buys), exits (model sells), and the source. If you connected a broker, review the account, quantities, order type and estimated dollars too. You choose the amount to allocate; the AI should not invent it.

    Then decide. Where an order-capable broker connection is available, you can ask your AI to submit a specific order after reviewing it. Approve each order yourself and check its status in the broker. An accepted order is not necessarily a fill. If the connection cannot trade, use your broker’s own order screen.

One method per account. Do not have an AI agent and the Google timer trade the same account independently. They could duplicate orders or disagree about positions. Connecting apps does not create an unattended trading schedule.

AI can misread a newsletter or propose an incorrect order. Check the original issue and broker records. Paper uses simulated money; live trading can lose real money. MI supplies research, not personal allocation advice or trade execution.

Using a different broker?

The Google templates and manual trading script are for Alpaca. An AI agent can still help review the newsletter without a broker. Account read access, if requested, depends on the broker and the app; this guide does not enable AI trading.

Read the detailed AI setup guide.

What was tested?

VERIFIED PAPER RUN · OCTOBER 23, 2026

The email became an exit, then an entry.

Our private Free test ran on Google’s timer. It sold the SNOW shares tracked by the strategy, waited for the fill, then bought HOG. Gmail, Google logs and Alpaca order records matched.

  1. 9:52:19 a.m. ET: SNOW exit filled.
  2. 9:54:18 a.m. ET: HOG entry submitted after the exit fill.
  3. 9:54:20 a.m. ET: HOG entry filled.
  4. 9:55:15 a.m. ET: Google confirmed the cycle complete.

The five retained positions kept their quantities. No duplicate orders or historical backfill were observed.

Actual Google execution row: continuePaper, Time-Driven, October 23 at 9:55:12 a.m., Completed
This Apps Script row shows that the October 23 Paper job completed. We confirmed the simulated fills separately in Alpaca’s order records.

Paper uses simulated money. This verifies the private Free workflow, not a fresh subscriber installation, Pro execution, live trading or investment returns.