An Alternative to Spreadsheets
Many traditional spreadsheet tasks are much faster in Looper.
Math with Variables
Define variables and use them to power your calculations.
| rent = $900 | $900 |
| car = $600 | $600 |
| rent + car | $1,500 |
Multiply by the Loop Keyword
Any equation that references the loop keyword will turn purple and be evaluated for each iteration of the loop e.g. [0,1,2,3]
| loop = 3 | 3 |
| rent = $900 | $900 |
| car = $600 | $600 |
| (rent + car) * loop | $4,500 |
Publish Arrows
Use the arrows to the left of an expression to publish results for each iteration of the loop.
| → | loop = 3 | 3 |
| → | rent = $900 | $900 |
| → | car = $600 | $600 |
| → | (rent + car) * loop | $4,500 |
Use Live Asset Prices
Use the $symbol to reference common stock or crypto tickers and we'll automatically fetch their current price.
| $tsla | $803 |
| $aapl | $220 |
| $btc | $101,660 |
Real Market Data
Combine $symbols with special classes to pull detailed market information.
| $btc.marketCap | $2.015T |
| $btc.volume | $45,024,981 |
| $btc.yearLow | $3,421 |
| $btc.yearHigh | $103,000 |
| $btc.dayLow | $99,822 |
| $btc.dayHigh | $101,660 |
Write Custom Functions
Define a function and then plug in different values to compare ideas.
| mortgagePayment(rate, loan) { loan * (rate / 12) } |
|
| mortgagePayment(2.75%, 3M) | $6,875 |
| mortgagePayment(3%, 2.5M) | $6,250 |
Sum to Last Empty Line
Use the sumSection keyword to add all the values above (until the nearest empty line). Great for turning a list into a variable sub-total.
| rent = $900 | $900 |
| car = $600 | $600 |
| groceries = $450 | $450 |
| trombone_oil = $99 | $99 |
| cable = $130 | $130 |
| dogwalker = $225 | $225 |
| bills = sumSection | $2,404 |
Do Advanceded Loop Calculations
Reference specifc iterations of the loop with loop.first() loop.last() and loop.previous().
| loop = 3 | 3 |
| loop.first() | 0 |
| loop.last() | 3 |
| loop.previous() | 2 |
Download Example Files
Common patterns to get you started with the app.
| Compound Interest |
| Amortization Schedule |
| Sales Projection |
| Burnrate/Runway |
| Expense Tracker |
