Created
March 22, 2020 07:04
-
-
Save rwilkes/49675aca0805622c4cd9c729116b9387 to your computer and use it in GitHub Desktop.
TOS Strategy Export
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<# | |
.SYNOPSIS | |
Output statistics from a thinkorswim strategy file exported as csv. | |
.PARAMETER File | |
Name or of csv file to process. | |
.PARAMETER ShowFileContents | |
If true, will output the contents of the csv file and calculated properties. | |
.NOTES | |
Author Kory Gill, @korygill | |
.LINK | |
https://github.com/korygill/technical-analysis | |
#> | |
[CmdletBinding()] | |
param ( | |
[string] | |
$File = 'D:\temp\StrategyReports_SPX_GapWithStop.csv', | |
[switch] | |
$ShowFileContents | |
) | |
# | |
# functions | |
# | |
function Convert-CurrencyStringToDecimal ([string]$input) | |
{ | |
((($input -replace '\$') -replace '[)]') -replace '\(', '-') -replace '[^-0-9.]' | |
} | |
function Add-Statistic ([string]$statistic, [double]$data) | |
{ | |
$dbl = [math]::Round($data, 2) | |
$dblStr = "{0:N2}" -f $dbl | |
#Write-Information "$statistic $dblStr" | |
$null = $outData.Add( | |
[PSCustomObject]@{ | |
'Statistic'=$statistic | |
'DblData'=$dbl | |
'Data'=$dblStr | |
} | |
) | |
} | |
function Write-Header | |
{ | |
Write-Output "$("="*78)" | |
} | |
# | |
# start of main script | |
# | |
# Makes debugging from ISE easier. | |
if ($PSScriptRoot -eq "") | |
{ | |
$root = Split-Path -Parent $psISE.CurrentFile.FullPath | |
} | |
else | |
{ | |
$root = $PSScriptRoot | |
} | |
Set-Location $root | |
if (-not (Test-Path $File)) | |
{ | |
throw "Cannot open file '$File'." | |
} | |
# read csv file | |
$outData = [System.Collections.ArrayList]::new() | |
$content = Get-Content -Path $File | |
$csvdata = $content | ? {$_ -match ";.*;"} | ConvertFrom-Csv -Delimiter ';' | |
$tradeUnitSize = 0; | |
if ($csvdata.Count) | |
{ | |
$tradeUnitSize = [math]::Abs($csvdata[0].Amount) | |
} | |
Write-Header | |
Write-Output "Trade Unite Size is '$tradeUnitSize' (FYI: 1 ES == 50 SPX units)`r`n" | |
# convert currency strings to decimal | |
# calculate properties | |
foreach ($item in $csvdata) | |
{ | |
$item.Amount = [double]($item.Amount | Convert-CurrencyStringToDecimal) | |
$item.Price = [double]($item.Price | Convert-CurrencyStringToDecimal) | |
$tpl = [double]($item.'Trade P/L' | Convert-CurrencyStringToDecimal) | |
$item.'Trade P/L' = if ($tpl -eq 0) {""} else {$tpl} | |
$pl = [double]($item.'P/L' | Convert-CurrencyStringToDecimal) | |
$item.'P/L' = if ($pl -eq 0) {""} else {$pl} | |
if ($tpl -eq 0) | |
{ | |
$item | Add-Member -MemberType NoteProperty -Name "Points" -Value 0 | |
} | |
else | |
{ | |
$apl = [math]::Abs($item.Amount) | |
$item | Add-Member -MemberType NoteProperty -Name "Points" -Value ($tpl/$apl*($apl/$tradeUnitSize)) | |
} | |
} | |
if ($ShowFileContents) | |
{ | |
$csvdata | ft -AutoSize | |
} | |
# | |
# get only lines that have Trade P/L | |
# | |
$tradepl = $csvdata | ? {$_.'Trade P/L'} | |
Write-Header | |
Write-Output "Trade distribution by trade size (1 ES == 50 SPX units)" | |
$tradepl | Group Amount | Sort {[int]$_.Name} | Select @{n='Trades'; e={$_.Count}}, @{n='TradeSize';e={[int]$_.Name*-1}} | ft | |
# | |
# calc trade length stats | |
# | |
$openCloseTrade = [System.Collections.ArrayList]::new() | |
$firstOpen = $false | |
$openTrade = $null | |
$closeTrade = $null | |
foreach ($item in $csvdata) | |
{ | |
if ($item.Side -match "to Open" -and $firstOpen -eq $false) | |
{ | |
$firstOpen = $true | |
$openTrade = $item | |
} | |
elseif ($item.Side -match "to Close") | |
{ | |
$closeTrade = $item | |
} | |
# for trades that open and close on the same day, TOS report has close trade before open trade in the file. | |
# use this logic to match them. | |
if ($firstOpen -and $closeTrade) | |
{ | |
$null = $openCloseTrade.Add( | |
[PSCustomObject]@{ | |
'FirstOpenTrade'=$openTrade | |
'CloseTrade'=$closeTrade | |
} | |
) | |
$firstOpen = $false | |
$openTrade = $null | |
$closeTrade = $null | |
} | |
} | |
# | |
# all trades | |
# | |
$tradeDuration = [System.Collections.ArrayList]::new() | |
foreach ($trade in $openCloseTrade) | |
{ | |
$openDate = [datetime]::Parse($trade.FirstOpenTrade.'Date/Time') | |
$closeDate = [datetime]::Parse($trade.CloseTrade.'Date/Time') | |
$numDays = $closeDate - $openDate | |
$null = $tradeDuration.Add($numDays) | |
} | |
Write-Header | |
Write-Output "Trade Size by Duration" | |
$tradeDuration.TotalDays | group | sort {[int]$_.Count}, {[int]$_.Name} | Select @{n='TradeSize'; e={$_.Count}}, @{n='Days';e={$_.Name}} | ft | |
# | |
# buys only | |
# | |
$buys = $openCloseTrade | ? {$_.FirstOpenTrade.Side -match "Buy to Open"} | |
$tradeDuration = [System.Collections.ArrayList]::new() | |
foreach ($trade in $buys) | |
{ | |
$openDate = [datetime]::Parse($trade.FirstOpenTrade.'Date/Time') | |
$closeDate = [datetime]::Parse($trade.CloseTrade.'Date/Time') | |
$numDays = $closeDate - $openDate | |
$null = $tradeDuration.Add($numDays) | |
} | |
Write-Header | |
Write-Output "Long Trade Size by Duration" | |
if ($tradeDuration.Count) | |
{ | |
$tradeDuration.TotalDays | group | sort {[int]$_.Count}, {[int]$_.Name} | Select @{n='TradeSize'; e={$_.Count}}, @{n='Days';e={$_.Name}} | ft | |
} | |
else | |
{ | |
Write-Output "NONE" | |
} | |
# | |
# sells only | |
# | |
$sells = $openCloseTrade | ? {$_.FirstOpenTrade.Side -match "Sell to Open"} | |
$tradeDuration = [System.Collections.ArrayList]::new() | |
foreach ($trade in $sells) | |
{ | |
$openDate = [datetime]::Parse($trade.FirstOpenTrade.'Date/Time') | |
$closeDate = [datetime]::Parse($trade.CloseTrade.'Date/Time') | |
$numDays = $closeDate - $openDate | |
$null = $tradeDuration.Add($numDays) | |
} | |
Write-Header | |
Write-Output "Short Trade Size by Duration" | |
if ($tradeDuration.Count) | |
{ | |
$tradeDuration.TotalDays | group | sort {[int]$_.Count}, {[int]$_.Name} | Select @{n='TradeSize'; e={$_.Count}}, @{n='Days';e={$_.Name}} | ft | |
} | |
else | |
{ | |
Write-Output "NONE" | |
} | |
# | |
# stats! | |
# | |
Add-Statistic "Total trades:" $($csvdata.Count) | |
# get only lines that have Trade P/L | |
# $tradepl = $csvdata | ? {$_.'Trade P/L'} | |
Add-Statistic "Total orders:" $($tradepl.Count) | |
$n = $tradepl.'Trade P/L' | Measure-Object -Maximum -Minimum -Sum -Average | |
Add-Statistic "Total P/L:" $($n.Sum) | |
Add-Statistic "Min Trade P/L:" $($n.Minimum) | |
Add-Statistic "Max Trade P/L:" $($n.Maximum) | |
$winners = $tradepl | ? {$_.'Trade P/L' -ge 0} | |
Add-Statistic "Winners:" $($winners.Count) | |
$losers = $tradepl | ? {$_.'Trade P/L' -lt 0} | |
Add-Statistic "Losers:" $($losers.Count) | |
$n = $winners.'Trade P/L' | Measure-Object -Maximum -Minimum -Sum -Average | |
Add-Statistic "Winner Total P/L:" $($n.Sum) | |
Add-Statistic "Winner Min Trade P/L:" $($n.Minimum) | |
Add-Statistic "Winner Max P/L:" $($n.Maximum) | |
$n = $losers.'Trade P/L' | Measure-Object -Maximum -Minimum -Sum -Average | |
Add-Statistic "Loser Total P/L:" $($n.Sum) | |
Add-Statistic "Loser Min Trade P/L:" $($n.Minimum) | |
Add-Statistic "Loser Max P/L:" $($n.Maximum) | |
$points = $tradepl.Points | Measure-Object -Sum -Average -Maximum -Minimum | |
Add-Statistic "Average Points:" $points.Average | |
Add-Statistic "Maximum Points:" $points.Maximum | |
Add-Statistic "Minimum Points:" $points.Minimum | |
$shortTrades = [System.Collections.ArrayList]::new() | |
$tplShort = $tradepl | ? {$_.Amount -gt 0} | |
if ($tplShort) {$shortTrades.AddRange($tplShort)} | |
$longTrades = [System.Collections.ArrayList]::new() | |
$tplLong = $tradepl | ? {$_.Amount -lt 0} | |
if ($tplLong) {$longTrades.AddRange($tplLong)} | |
Add-Statistic "Short Trades:" $shortTrades.Count | |
Add-Statistic "Long Trades:" $longTrades.Count | |
$shortPoints = if ($shortTrades.Count) {$shortTrades.Points} else {0} | |
$points = $shortPoints | Measure-Object -Sum -Average -Maximum -Minimum | |
Add-Statistic "Short Average Points:" $points.Average | |
Add-Statistic "Short Maximum Points:" $points.Maximum | |
Add-Statistic "Short Minimum Points:" $points.Minimum | |
$longPoints = if ($longTrades.Count) {$longTrades.Points} else {0} | |
$points = $longPoints | Measure-Object -Sum -Average -Maximum -Minimum | |
Add-Statistic "Long Average Points:" $points.Average | |
Add-Statistic "Long Maximum Points:" $points.Maximum | |
Add-Statistic "Long Minimum Points:" $points.Minimum | |
$exitType = ($tradepl | ? Strategy -Match 'StopLossLX') | |
$exit = if ($exitType) {$exitType.Count} else {0} | |
Add-Statistic "Exit StopLossLX:" $exit | |
$exitType = ($tradepl | ? Strategy -NotMatch 'StopLossLX') | |
$exit = if ($exitType) {$exitType.Count} else {0} | |
Add-Statistic "Exit NOT StopLossLX:" $exit | |
# | |
# Output Statistics | |
# | |
Write-Header | |
Write-Output "Statistics for '$($tradepl[0].Strategy)' from '$File'." | |
Write-Output "From: $($tradepl[0].'Date/Time')" | |
Write-Output " To: $($tradepl[-1].'Date/Time')" | |
$outData | Select Statistic, Data | ft | |
# Just a line that does nothing so you can set a breakpoint if needed before script exits. | |
Start-Sleep -Milliseconds 100 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment