Hi!
Born in 2020 and updated constantly, THT is the biggest Torn spreadsheet, that will simplify your game experience, increase your daily profits, help you obtain honors easily, let you check your daily, weekly, monthly, yearly stats gain, give you meaningful notifications, and much more... Everything in one place!
You don't need excel skills at all and I'll provide a detailed guide. It works on mobile and computer.
Here are some screenshots (thanks to Girthmasterr [2908290] for uploading them) and features with my data, but obviously once you put your API key, it will show your info.
You'll be the only owner of your spreadsheet: your data and API key will be visible only to you.
Travel 2

Here you'll find the list of destinations, with the time of flight, based on your airstrip/WLT/Business Class Ticket. This info is then used to calculate your daily income and your suggestions for your next trip in the "Travel" sheet.
The API will populate your destinations and it will keep count of all your trips in the last 7 days. It will calculate your potential gain for each day, and the weekly average.
Travel

Travel sheet uses APIs to calculate the current market values and lowest bazaar price of all items abroad, their availabilities, and it will give you suggestions about your next trip, based on the best profit, your next OC (Organized Crime), bank time left, education time left, cool-downs, and some custom timers. In this way you don't have to check all this stuff before flying, you just depart for your suggested destination!
It will also tell you the minimum money to bring for each destination. This will help you maximize your flight gains. With just this, I've increased my flight gains by 45 mil per month
Money

Money just tells you where your money are and what's your average daily income (based on flights, stocks, crimes, company wage, bank, pi rent, city finds, mugs, bounties, etc...) and your average daily expenses (rent, DP, Xanax, rehab, pi rent, etc...). Both lists are editable and you can add your own income/expenses or remove the default ones. Most of them use formulas and APIs to get your actual gains and losses
StockList
(updated with Stocks 3.0)


StockList is a list of all the stocks in Torn, sorted by yield (%) and thanks to the APIs it will tell you the current weekly gain for all BBs, current price, increment info.
You can also set notifications when a specific stock reaches a price you set.
StockPortfolio
(updated with Stocks 3.0)

StockPortfolio contains the stocks you currently have, with gain (or loss) for each transaction
Stock Trades
(updated with Stocks 3.0)

New Stock Trades sheet, with the list of all the stock trades made during the current month, with their price sold, price bought, profit, current price
Stock Trading Summary
(updated with Stocks 3.0)

New Stock Trading Summary sheet, with the data of your tradings for each month.
On the top, there's a summary and 2 types of averages: an AVG for all the previous months and an AVG of the last X months (you can change X to any number)
Market

It's a combination of 5 tables:
- Top left, cans vs FHC vs xanax price/energy, it also calculates your faction specials automatically
- Top right, worth opening packs and boxes of supplies (updated every 5 minutes)
- Middle left, suggestion about renting or buying a PI.
If you don't have bank investments or all the stocks with high return on investments, this is what you'd see:

If you have all the best stocks, it'd suggest to buy it instead.
- Bottom right, most profitable items to buy from the city shops (updated every 5 mind)
- Bottom left, item price scanner (you put in item name or item ID and it'll give you an avg of lowest bazaar price and market value - market value updated every minute, bazaar price updated every 10 minutes)
Honors
Honors is a list of all the honors in Torn. Here you can keep track of each of them, with a count for each specific honor. (example: for Use 50 Speed, the current count is 22). There are also explanations for the tricky ones, with link to the forums when needed
Since i've started using this, I was able to obtain 30 honors in 1 month
Medals
Daily, Weekly, Monthly stats


Stats will tell you your current Battle Stats, Working Stats, Xanax consumption, and Rehab fees, with your daily, weekly, monthly gain/usage, and with week, month, year predictions
Time to reach specific goals you set, based on your avg monthly gain or avg weekly gain
HOF with rank differences from the previous month (https://www.torn.com/halloffame.php)
MyCompany



MyCompany sheet, with info about the company, available positions, stat gains, wage, company bonus, and your effectiveness (Working Stats bonus, Settled In bonus, Director Education bonus, Addiction malus).
Also, if you're the company director, you'll find: stock info and availabilities, employee applications with their working stats (you can check them even if you're flying), complete employee list with their wages, working stats, effectiveness (Working Stats bonus, Settled In bonus, Director Education bonus, Addiction malus), last actions, and last date you trained your employees (the oldest one is in green; X are for new employees with no trainings received)
You'll also receive an email once a day if there are inactive employees and when you "on order" stock gets delivered.
Companies

The Companies sheet contains a list of company specials and an estimated value you can get from them. This is then automatically reported in your daily income (money sheet)
Company Stalker

This is super useful if you're trying to join a specific company type (e.g. Grocery or Lingerie 10*).
Choose the company type (e.g. Lingerie) and the ratings (e.g. 9* and 10*) and THT will show the companies in that range. You can also decide to receive an email notification when there is an available position or if there is at least 1 inactive employee, in one of those companies.
City Finds

The values are added to the money sheet, so you know how much you gain per day
Properties

Here you can find your properties and rentals. Your income or expenses are added to the Money sheet, so you know how much you gain/pay per day. Plus, a notification will be sent when there are 3, 2, 1 days left on your rent
Revives
It will show the list of your last 1,000 (active and passive) revives, and 4 stats table that will show the number of revives by reviver, target, reviver's faction, and target's faction.
Obviously, if you're a reviver, you'll look at target and target's faction; if you are NOT a reviver, you'll look at reviver and reviver's faction (I'm not a reviver, as you can see by these screenshots
)

Wheels Tracker

Do you play Wheels at the casino? Here you can keep track of your spins and see how much you will make if you continue playing
Gym Info + Nice merit calculator
Bars + Personal Stats
Weapons

Suggestions for the weapons to use for each finishing hit merit (with cost and current hits).
Nerve


Nerve, keeps track of your Natural Nerve Bar, with some suggestions to improve it.
Inventory (temp removed, see this post)

Inventory sheet (accessible at any moment), with filter of "sellable" items. The value of "sellable items" is then used in the money sheet, to calculate how much "cash" you have
Bazaar

Bazaar sheet (accessible at any moment)
Education List

Here you can find all the edu courses in Torn, with the outcome, duration, costs.
It automatically marks the classes you've already completed and the one you're currently doing.
----
If you prefer browsing the spreadsheet instead of looking at screenshots, here is a sample file: this is just an example, with fake data and no formulas. The data in this file won't change, while your file will update every minute with the data coming from the API: view test file (it does not have the latest updates - last update of this test file is Oct 2020)
PRICE 89m
If you're interested in this spreadsheet and when you're ready, you can just send the payment, including your google email address in the comment of the payment. Please also fill out the form to enter the queue and make sure I don't miss your payment.
I'll prepare the file and send it when ready. It's usually done within a day, but it might be slower on weekends.
---
- Are you a faction leader (or co) and do you want your faction members to get THT at a discounted price? Send me a PM and I'll explain how it works.
- Do you want to gift it to a low-net-worth player? Contact me and I'll match your gift to another random player!
- If your NW < 10b, you can join our THT Raffle!
What's included when you buy it?
- Full ownership of your file
- Setup instructions
- Fully customizable options and notifications
- Detailed guide, with explanation of each sheet
- Main shared script: free bug fixes, free updates, free new features
- Local script: free bug fixes. Updates and new features are available on demand (cost depends on type of changes/features)
FEATURES REQUESTED:
- cool-downs (done)
- stats predictions (done)
- weapon exp (done)
- company info (done)
- events (done)
- HOF (done)
- HOF changes from previous month (done)
- Gym gains (done)
- Events: store latest 1000 (done)
- Plushies/Flowers availability abroad (done)
- Daily notification if investment forecast becomes negative (done)
- Turn on/off specific email notifications (done)
- Drugs abroad (done)
- Stock payouts historical tracker (done)
- Ignore Energy/Nerve lose for longer flights (done)
- Rehab fees track (done)
- Wheels track (done)
- company detailed info for directors (done)
- Date last training employee (done)
- Item list and bazaar list (done)
- Stock trading history (done)- Education tracker (done)
- Time to reach specific stats, based on the daily/weekly/monthly avg (done)
- Use types in filter of Inventory sheet (done)
- Number of flights per destination (done)
- Revive list (done)
- Split Stocks "All Stocks" and "MyStocks" (+ Add filters + remaining money left to get a stock BB) (done)
- Stats sheet (add drugs, net-worth, offences, revives, travels, attacks, defends, busts, respect, energy drinks, Stat enhancers) (done)
- Wheels tracker with Logs API (done)
- Add Lingerie 10* benefits to Destination sheet (done)
- Add other items to the BestPrices sheet, other than plushies, flowers, and drugs (done)
- StockPortfolio % gain/loss (done)
- Notification for specific stock threshold (greater than and less than) (done)
- Company list from API & Track company income based on company star level (done)
- Company Stalker update: daily customer, weekly customer, and company age (done)
- Notification for company directors when the on-order stock get delivered (done)
- Add medals (done)
- Stock Payouts history (done)
- Turn off the emails that someone in my own company is inactive (done)
- Inactive employee notification at 17.30 TCT (done)
- Lowest stock prices (done)
- Add attack log link to the attacks sheet (done)
- Add to the Stats tracker (done)
- City Finds tracker (logs api) (done)
- Nerve sheet configurable (logs api) (done)
- Property manager and rental notification (done)
- Refresh all company info for CompanyStalker (done)
- Market value scanner (done)
- Notifications for ended cooldowns and energy/nerve full (done)
- Track faction income (done)
- Settings sheet (done)
- Add new Settings: xanax & num refills paid by your faction (done)
- Add trainings/tax section in MyCompany (done)
- Keep last training date for each employee (done)
- Casino profit (done)
Future functionalities, to be implemented:
- Property calculator
- Job point estimate
- Items buy and sell report
- Add profit % column to the StockTradingThisMonth sheet
- Add point listing
- Add % completion to Honors & Medals page
- Use real item sales to calculate the travel profit avg
- Keep track of number of trainings given, for each employee
- Notification for item market value
- Add contraband items to Travel2
- Select specific alcohol/energy drink/stat enhancer items to use in Settings
- Use Torn API v2
Currently working on:
If you want to provide a feedback or if you have specific requests or functionalities that you would like to see in THT, just write here, adding all the details, and I'll add them to the list above.
RELEASE NOTES (2 parts: local file + main script)
LOCAL FILE (manually updated on request - here listing only major versions + latest minor versions)
- v1.0 (26-Nov-2020): First version
- v2.0 (26-Apr-2021): Torn API request list defined in the API, instead of local file (easy to update in case of changes to the API or new functionalities)
- v3.0 (11-Nov-2023): Torn API requests now only every 5 mins and manual updates in the other 4 minutes (fix the error "Service invoked too many times for one day: urlfetch")
- v4.00 (1-Apr-2024): Block fetch requests if API key is wrong, empty, or inactive
- v5.00 (2-May-2024): Request list coming from Origin sheet, instead of fetching it (to resolve Google limit issue)
- v6.00 (09-April-2025): Add pastBoosterCooldownNotification, pastDrugCooldownNotification, pastEnergyFullNotification, and pastNerveFullNotification
- v7.00 (21-June-2025): Move setup settings (apiKey, email, notifications) from App Scripts to the Settings sheet
- v8.00 (06-Jul-2025): Update formulas in the Money sheet, following update v7.03
- v9.00 (5-Oct-2025): Add self-troubleshooting in Apps Script
-
v9.01 (12-Oct-2025): Add self-troubleshooting icon in the Settings sheetg
- v9.02 (14-Oct-2025): Fix target xanax/day avg for new accounts
- v9.03 (16-Oct-2025): Update stats prediction (weekly from 1.05 to 1.025, monthly from 1.25 to 1.2, yearly from 1.75 to 1.35)a
-
v9.04 (10-Nov-2025): Use a safer faction income formula in the Stats sheet
-
v9.05 (18-Nov-2025): Fix troubleshoot function (v9.00) to set correct data
-
v9.06 (19-Nov-2025): Add new Settings: xanax & num refills paid by your faction
- v9.07 (26-Nov-2025): For Company Directors: Add trainings/tax section in MyCompany and add it to the Company profit
- v9.08 (4-Dec-2025): Fix faction income in the Stats sheet showing as #REF! for older versions
- v9.09 (1-Jan-2026): Add flight profit to the Stats sheet
-
v9.10 (4-Jan-2026) Fix flight profit and company gain in the Stats sheet
-
v9.11 (4-Jan-2026) Add 'Ignore Faction Balance Resets' setting to the Settings sheet
-
v9.12 (6-Jan-2026) Fix flight profit when always 0 in the Stats sheet
-
v9.13 (10-Jan-2026) Update reset references from Stats to Data sheet
-
v9.14 (11-Jan-2026) Remove option to "ignore days with low flying time"
-
v9.15 (11-Jan-2026) Add "Smuggling for Beginners" book perks to the total of items you can bring on flights
-
v9.16 (11-Jan-2026) Fix flight profit in the Stats sheet showing as #REF! for older versions
-
v9.17 (11-Jan-2026) Stop extra troubleshooting, if file was not set up
-
v9.18 (26-Jan-2026) Fix incorrect company profit in the Stats/Money sheet
-
v9.19 (27-Jan-2026) Update MyCompany sheet to use the daily income rather than avg of weekly income for the profit
-
v9.20 (1-Feb-2026) Change attribute name in the Settings from Ignore Faction Balance Resets to Ignore Faction Balance Decreases
-
v9.21 (11-Feb-2026) In case of faction income issues, prevent failures and try again at the next check
- v9.22 (12-Feb-2026) While troubleshooting, if the API key is valid, force-unpause the file updates
- v9.23 (22-Feb-2026) Add tax for selling items on the Item Market
-
v9.24 (13-Mar-2026) Update labels on current time and file update time in the Settings sheet
-
v9.25 (4-Apr-2026) Update MyCompany LastTraining format to DateTime
-
v9.26 (28-Apr-2026) Add casino income to the Stats and Money sheets
-
v9.27 (5-May-2026) Remove local time from the Settings sheet
-
v9.28 (6-May-2026) Use formulas for the bars data in the Stats sheet
-
v9.29 (1-Jun-2026) Fix money sheet formulas with negative values
-
v9.30 (5-Jul-2026) Travel 2.0: Update flight times
- v10.00 (24-Jul-2026) Use MIN/MAX Ratings for the CompanyStalker (fix CompanyStalker Torn API change)
- ...
MAIN SCRIPT (automatically available/updated - here listing only the updates of the past 12 months)
... [not showing older versions] ...
- ...
-
v145 (Oct 2025)
Fix FactionIncome with multiple items received from OCs
-
v146 (Nov 2025)
Resolve bug for pause range introduced with v12.00.05
-
v147 (Jan 2026)
Add flight income to the Stats sheet
-
v148 (Jan 2026)
Fix flight profit and company gain in the Stats sheet
-
v149 (Jan 2026)
Add support for ignoreBalanceResets
-
v150 (Jan 2026)
Move travel updates after stats update
-
v151 (Jan 2026)
Reset Travel History with the Daily Processes
-
v152 (Jan 2026)
Update reset references from stats to data sheet
-
v153 (Jan 2026)
Remove temp reset changes
-
v154 (Jan 2026)
Fix wrong data in the Stats sheet
-
v155 (Jan 2026)
Put dailyProcesses after the daily, weekly, monthly, yearly updates
-
v156 (Feb 2026)
With ignoreBalanceResets, now faction balance resets AND decreases are skipped
-
v157 (Feb 2026)
Remove sumCompanyGain
-
v158 (Mar 2026)
Add logging when ignoring faction income
-
v159 (Apr 2026)
Add casino income to the Stats sheet
-
v160 (Apr 2026)
Add casino income to the Stats sheet
-
v161 (May 2026)
Add casino tokens left
-
v162 (May 2026)
Remove writeBarsDataOld
-
v163 (May 2026)
Do not update casino income/tokens in the first minutes of the day
-
v164 (July 2026)
Use MIN/MAX Ratings for the CompanyStalker
-
v165 (August 2026)
Update sorting for company stalker
-
...
ToS:
| Data Storage | Data Sharing | Purpose of Use | Key Storage & Sharing | Key Access Level |
| Will the data be stored for any purpose? | Who can access the data besides the end user? | What is the stored data being used for? | Will the API key be stored securely and who can access it? | What key access level or specific selections are required? |
Your data will be present in your file until sheet deletion |
Only you and whoever you grant access to your file |
For you to view/analyze |
It's stored in your file's code details / Only you and whoever you grant access to your file |
Depending on what info you want to see: from limited to full access, you can choose, based on the features you want to use |












