# Open positions vs equity ratio

**URL:** <https://forums.collective2.com/t/open-positions-vs-equity-ratio/8398>\
**Category:** C2 Explorer\
**Created:** [January 19, 2016, 6:00am UTC](https://forums.collective2.com/t/open-positions-vs-equity-ratio/8398 "2016-01-19T06:00:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![c2-auto-trader](https://yyz2.discourse-cdn.com/flex028/user_avatar/forums.collective2.com/c2-auto-trader/32/21425_2.png) [@c2-auto-trader](https://forums.collective2.com/u/c2-auto-trader)\
**Post date:** [January 19, 2016, 6:00am UTC](https://forums.collective2.com/t/open-positions-vs-equity-ratio/8398/1 "2016-01-19T06:00:33Z")

</div>

Hi!

With C2 Explorer is it possible to show the ratio of funds reserved to maintain open positions to total equity for particular system for each day? For example, for stocks it will be simply ratio of open positions cost to equity, for futures and options - ratio of required margin to equity. Not sure what it should be for forex.

---

<div class="post-metadata">

**Author:** ![ACA](https://yyz2.discourse-cdn.com/flex028/user_avatar/forums.collective2.com/aca/32/1701_2.png) [@ACA](https://forums.collective2.com/u/ACA)\
**Post date:** [January 19, 2016, 7:07am UTC](https://forums.collective2.com/t/open-positions-vs-equity-ratio/8398/2 "2016-01-19T07:07:21Z")

</div>

If you are not looking for a TimeSeries plot, you can use the below code to get a table of the desired data.

```
TABLE = (from sys in C2SYSTEMS 
// where sys.SystemId == 97468745
         select new {sys.SystemId, sys.SystemName, sys.MarginUsed, sys.OpenEquity, sys.Cash}
         );

```

If you need a TimeSeries plot, it’s possible and easy for stocks systems like you pointed out. For futures systems, you will however need to maintain a list for Margins per symbol as provided [here](https://www.collective2.com/symbols).

Feature Request to C2 - Will be great, if in the future C2Explorer would provide a Database interface for querying margin based on symbol (C2SYMBOLS).

Regards,  
ACA

---

<div class="post-metadata">

**Author:** ![c2-auto-trader](https://yyz2.discourse-cdn.com/flex028/user_avatar/forums.collective2.com/c2-auto-trader/32/21425_2.png) [@c2-auto-trader](https://forums.collective2.com/u/c2-auto-trader)\
**Post date:** [January 19, 2016, 1:47pm UTC](https://forums.collective2.com/t/open-positions-vs-equity-ratio/8398/3 "2016-01-19T13:47:51Z")

</div>

Thank you for your answer. Actually I was looking for time series plot. Something similar to equity plotted for this ratio.