Skip to content
Gallery
Ultimate Crypto Trading Journal and Portfolio Manager v-0.3
User Manual (Start Here)
Dashboard
Config
Portfolio Management
Positions
Journal
Trade Review
Stats
Backtesting Lab
Other Tools
Databases
Change Log
Share
Explore

icon picker
Change Log

v-0.3

Updated positions column title
From: Calc - (C) - Total Number of Tokens Bought (Lev'd)
to: Calc - (C) - Total Number of Tokens (Lev'd)

Fix bug in calculation of P/L for short positions by updating the Calc - (C) - Total USD Out (Lev’d) on the positions table formula
If(
thisRow.[Exit - Avg Price Over Ride (USD)].IsBlank(),
Sum(
[Position Changes].Filter(
Postion = thisRow AND
CurrentValue.[Add or Subtract?] = [Subtract from Position]
).[Cost or Earnings (USD - Lev'd)]
),
If(
thisRow.[Position - Direction] = Long,
thisRow.[Exit - Avg Price Over Ride (USD)]*thisRow.[Calc - (C) - Total Number of Tokens (Lev'd)],
thisRow.[Calc - (C) - Total USD In (Lev'd)] + (thisRow.[Calc - (C) - Total USD In (Lev'd)] - thisRow.[Exit - Avg Price Over Ride (USD)]*thisRow.[Calc - (C) - Total Number of Tokens (Lev'd)])
)
)

Fix bug in calculation of Now (C) - Cost Basis (incl. realized P/L) on the Positions table for short positions
If(
thisRow.[Closed?],
"",
If(
thisRow.[Position - Direction] = Long,
// Long calculation
((thisRow.[Now - (C) - Size (Tokens - Lev'd)] * thisRow.[Now - (C) - Cost Basis]) - thisRow.[Now - (C) - Realized P/L])
/
thisRow.[Now - (C) - Size (Tokens - Lev'd)],
// Short calculation
thisRow.[Now - (C) - Realized P/L]/thisRow.[Now - (C) - Size (Tokens - Lev'd)] + thisRow.[Now - (C) - Cost Basis]
)
)

Fix bug in calculation of (C) - Price Per Token on the Position Changes table for short positions
If(
thisRow.Postion.[Position - Direction] = Long,
thisRow.[Cost or Earnings (USD - Lev'd)]/thisRow.[Number of Tokens (Lev'd)],
thisRow.[(C) - Cost Basis at Time of Change] -
(
(thisRow.[Cost or Earnings (USD - Lev'd)]-thisRow.[(C) - Cost Basis at Time of Change]*thisRow.[Number of Tokens (Lev'd)]) /
thisRow.[Number of Tokens (Lev'd)]
)
)

⁠

v-0.2

Add AI Agent token category
Put Useful Links section into callouts and rearrange them
Update Portfolio table column titles
Positions - Open - After Last Cash Update → Positions - Opened After Last Cash Update
Positions - Closed - After Last Cash Update (no changes) → Positions - Closed After Last Cash Update
Update formulas on Portfolios table to fix cash balance bug
Positions - Opened After Last Cash Update
Positions - Closed After Last Cash Update
Position Changes - Additions - After Last Cash Update
Position Changes - Subtractions - After Last Cash Update

⁠

v-0.1

Initial beta release

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.