Skip to content

Instantly share code, notes, and snippets.

View DarqueWarrior's full-sized avatar

Donovan Brown DarqueWarrior

677 followers · 1 following
View GitHub Profile
@DarqueWarrior
DarqueWarrior / TickerSymbol.txt
Created March 12, 2024 01:36
Populates a column with ticker symbol for each row of the Fidelity transaction history download if it was an option trade.
=IF([@[Option Trade]],
MID([@Action], FIND("(", [@Action]) + 1, FIND(")", [@Action]) - FIND("(", [@Action]) - 1),
"")
@DarqueWarrior
DarqueWarrior / OptionContractsCount.txt
Created March 12, 2024 01:38
Populates a column with the absolute value of the number of contracts for the option trade.
=IF([@[Option Trade]], IF([@[Sell To Open]], [@Quantity] * -1, [@Quantity]), "")
@DarqueWarrior
DarqueWarrior / Exposure.txt
Created March 12, 2024 01:42
Populates a column with the total value of the strike price multiplied by the number of contracts sold.
=IF([@[Sell To Open]], [@Contracts] * [@[Strike Price]] * 100, "")
@DarqueWarrior
DarqueWarrior / Put.txt
Created March 12, 2024 01:48
=LEFT([@Description],4) = " PUT"
@DarqueWarrior
DarqueWarrior / Call.txt
Created March 12, 2024 01:49
=LEFT([@Description],5) = " CALL"