# C2SYSTEMS table values

**URL:** https://forums.collective2.com/t/c2systems-table-values/11377
**Category:** C2 Explorer
**Created:** [February 7, 2018, 1:25am UTC](https://forums.collective2.com/t/c2systems-table-values/11377 "2018-02-07T01:25:32Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![jozsika](https://yyz2.discourse-cdn.com/flex028/user_avatar/forums.collective2.com/jozsika/32/1487_2.png) [@jozsika](https://forums.collective2.com/u/jozsika)
#### Post date: [February 7, 2018, 1:25am UTC](https://forums.collective2.com/t/c2systems-table-values/11377/1 "2018-02-07T01:25:32Z")

</div>

I retrieve the values from the C2SYSTEMS table and they seem to be off, relative to the values on the C2 UI (Statistics tab.)

Here is a sample record for the System TrendCounterTrend

{“SystemId”:105929505,“SystemName”:“Trend Countertrend”,“Added”:“2016-09-17T01:47:59”,“MonthlyFee”:60,“TrialDays”:30,“  
OpenPositionsPL”:-1293, — on the UI -1717  
"StartingCash":10000,

-------- These I don’t understand. On the UI cash is 20392 and buying power is 18674. The UI (the chart) also says that total equity is 19,884. I would THINK  
that ClosedPL + OpenEquity should be around 19,884. It is nowhere close. --------

“Cash”:12467,  
“MarginUsed”:0,  
“OpenEquity”:-1293,  
“ClosedPL”:12843,

“Started”:“2016-09-17T01:47:59”,“NumTrades”:44,“TradeFreq”:42664652,

“NumWins”:33, -------- UI says 32. Close enough, but sort of an indication that the UI works from a different dataset.

“NumLoss”:11,“DollarWin”:14426,“DollarLoss”:2877,

“AvgWin”:437.15, ---------- UI says 450.09  
"AvgLoss":261.55} ---------- UI says 322.58