Spreadsheet: 690198d1596934919-formulas-using-named-ranges-automatically-turning-into-array-formulas-array_issue_sample
Sheet: Tracking

Symbol | BDate | Buy | BPrice | Cost | SDate | SPrice | Proceeds | P/L ($) | P/L (%) | Days | P/L (/D)
LITCF | 2020-08-10 00:00:00 | 300000 | 0.001
PNX | 2020-08-10 00:00:00 | 300000 | 0.001 | 321.95
EQE | 2020-08-05 00:00:00 | 200000 | 0.001 | 221.95
OSP | 2020-07-10 00:00:00 | 200000 | 0.001 | 221.95 | 2020-07-30 00:00:00 | 0.002 | 378.05 | 156.1 | 0.7033115566569048 | 20 | 7.805000000000001
OSP | 2020-07-31 00:00:00 | 200000 | 0.001 | 221.95
OSP | 2020-08-05 00:00:00 | 100000 | 0.001 | 121.95
STM | 2020-08-05 00:00:00 | 250000 | 0.001 | 271.95
TSO | 2020-07-20 00:00:00 | 50000 | 0.001 | 71.95 | 2020-08-04 00:00:00 | 0.002 | 78.05 | 6.099999999999994 | 0.08478109798471152 | 15 | 0.4066666666666663
KAI | 2019-07-29 00:00:00 | 500000 | 0.001 | 521.95 | 2020-07-02 00:00:00 | 0.002 | 978.05 | 456.0999999999999 | 0.8738384902768462 | 339 | 1.345427728613569
KAI | 2019-07-29 00:00:00 | 500000 | 0.001 | 521.95
KAI | 2020-07-08 00:00:00 | 312500 | 0.001 | 334.45
KAI | 2020-07-01 00:00:00 | 125000 | 0.001 | 146.95
KAIO | 2020-08-20 00:00:00 | 62500 | 0.001 | 84.45
ADN | 2020-06-25 00:00:00 | 200000 | 0.001 | 221.95 | 2020-07-06 00:00:00 | 0.0005 | 78.05 | -143.9 | -0.6483442216715476 | 11 | -13.08181818181818
[NAME] | 2018-01-29 00:00:00 | 55000 | 0.001 | 76.95 | 2018-10-04 00:00:00 | 0.0005 | 5.550000000000001 | -71.4 | -0.9278752436647174 | 248 | -0.2879032258064516
RMXOH | 2018-01-19 00:00:00 | 121589 | 0.001 | 143.539 | 2018-10-04 00:00:00 | 0.0005 | 38.8445 | -104.6945 | -0.7293801684559597 | 258 | -0.4057926356589147
RMXOH | 2018-01-16 00:00:00 | 178411 | 0.001 | 200.361 | 2018-10-04 00:00:00 | 0.0005 | 67.2555 | -133.1055 | -0.664328387260994 | 261 | -0.5099827586206896
AAJ | 2018-01-16 00:00:00 | 150000 | 0.001 | 171.95 | 2018-10-04 00:00:00 | 0.0005 | 53.05 | -118.9 | -0.6914800814190172 | 261 | -0.4555555555555555
88E | 2018-01-16 00:00:00 | 500000 | 0.001 | 521.95 | 2018-10-04 00:00:00 | 0.0005 | 228.05 | -293.9 | -0.5630807548615768 | 261 | -1.126053639846743
VXR | 2018-01-16 00:00:00 | 270000 | 0.001 | 291.95 | 2018-10-04 00:00:00 | 0.0005 | 113.05 | -178.9 | -0.6127761603014215 | 261 | -0.6854406130268198 |  |  |  |  |  | 43381 | Confirmed
ARDO | 2018-01-16 00:00:00 | 700000 | 0.001 | 721.95 | 2018-10-04 00:00:00 | 0.0005 | 328.05 | -393.9 | -0.5456056513608976 | 261 | -1.509195402298851 |  |  |  |  |  | 43118 | Confirmed
CCZ | 2018-01-16 00:00:00 | 80000 | 0.001 | 101.95
VRX | 2018-01-16 00:00:00 | 75000 | 0.001 | 96.95
ARDO | 2018-01-16 00:00:00 | 600000 | 0.001 | 621.95 |  |  |  |  |  |  |  |  |  |  |  |  | 0.019 | 19.95 | 9478.05 | 43381 | Confirmed
VRX | 2019-09-23 00:00:00 | 100000 | 0.001 | 121.95 |  |  |  |  |  |  |  |  |  |  |  |  | 0.01 | 19.95 | 5021.95 | 43118 | Confirmed
VRX | 2019-07-24 00:00:00 | 180000 | 0.001 | 201.95
VRX | 2019-05-30 00:00:00 | 200000 | 0.001 | 221.95
VRX | 2018-10-11 00:00:00 | 45000 | 0.001 | 66.95
CCZ | 2018-10-11 00:00:00 | 170000 | 0.001 | 191.95
ARDO | 2018-01-16 00:00:00 | 600000 | 0.001 | 621.95 | 2018-10-04 00:00:00 | 0.002 | 1178.05 | 556.0999999999999 | 0.8941233218104347 | 261 | 2.130651340996168