Skip to content

Instantly share code, notes, and snippets.

@DarqueWarrior

DarqueWarrior/StrikePrice.txt

Created March 12, 2024 01:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save DarqueWarrior/e5beea50120d10758a71bc7b4a5ee0d3 to your computer and use it in GitHub Desktop.
Save DarqueWarrior/e5beea50120d10758a71bc7b4a5ee0d3 to your computer and use it in GitHub Desktop.
Download ZIP
Populates a column with strike price for each row of the Fidelity transaction history download if it was an option trade.
Raw
StrikePrice.txt
=IF([@[Option Trade]],
NUMBERVALUE(MID([@Action], FIND("$", [@Action]) + 1, FIND(" ", [@Action], FIND("$", [@Action])) - FIND("$", [@Action]) - 1), "."),
"")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment