Examples
Examples
Try the starting example
- Roster [category,purchase cost currency,current valuation currency]; enter JSON (USD)
- [["Loco",100,120],["Wagon",30,25],["Wagon",40,35]]
- Purchase total (USD)
- $170.00
- Current value by category (JSON) (USD)
- {"Loco":120,"Wagon":60}
- Total valuation change (USD)
- $10.00
Try another scenario
- Roster [category,purchase cost currency,current valuation currency]; enter JSON (USD)
- [["Loco",150,130],["Wagon",50,45]]
- Purchase total (USD)
- $200.00
- Current value by category (JSON) (USD)
- {"Loco":130,"Wagon":45}
- Total valuation change (USD)
- -$25.00
Calculation method
Calculation method
Purchase total (USD)
Sum purchase cost.
Current value by category (JSON) (USD)
Group by category and sum entered current valuations.
Total valuation change (USD)
Sum current valuation minus purchase cost.
Symbols and units
- a
- Roster [category,purchase cost currency,current valuation currency]; enter JSON (USD)
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Assumptions & limits
Assumptions & limits
- User-entered valuations, without market appraisal. Supported limits: All numeric inputs and computed intermediates must remain finite. Supported numeric input magnitude is zero or 1e-12 through 1e12 in absolute value; reject values outside this bounded range. All lists/JSON record tables are limited to 100 records unless a stricter bound is stated; reject malformed record arity and wrong member types. All numeric values must be finite. Lists contain at most 100 records; required lists must be nonempty. Rates, probabilities and fractions are entered as fractions, not percentages; fractions must be between 0 and 1. Use a single consistent user-selected currency for all amounts; no exchange-rate conversion.
Are these inputs private?
These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.