{"id":186,"date":"2021-03-02T03:45:58","date_gmt":"2021-03-02T03:45:58","guid":{"rendered":"https:\/\/algomojo.com\/blog\/?p=186"},"modified":"2025-02-27T07:46:08","modified_gmt":"2025-02-27T07:46:08","slug":"how-to-retrieve-opening-balance-total-turnover-realized-and-unrealized-mtm-using-python","status":"publish","type":"post","link":"https:\/\/algomojo.com\/blog\/how-to-retrieve-opening-balance-total-turnover-realized-and-unrealized-mtm-using-python\/","title":{"rendered":"How to Retrieve Opening Balance, Total Turnover, Realized and Unrealized MTM using Python?"},"content":{"rendered":"\n

This tutorial explores how to access the limits API functionality in Algomojo using python to retrieve the Account Balance, Total Turnover, Realized, UnRealized PNL, Realized Intraday MTM, UnRealized Intraday MTM.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Supported Brokers<\/strong> : Aliceblue, Tradejini, Zebu<\/p>\n\n\n\n

How to Install Algomojo Python Library?<\/strong><\/p>\n\n\n\n

Install from PyPI using the simple PIP command<\/p>\n\n\n\n

pip install algomojo<\/code><\/pre>\n\n\n\n
It is highly recommended to use Python 3.x versions<\/p>\n\n\n\n
\"This<\/figure>\n\n\n\n
Algomojo provides in-depth functionality to explore various possibilities of implementing your own trading rules. For more detailed documentation visit algomojo documentation<\/a><\/p>\n\n\n\n
Sample Limits API Response<\/strong><\/p>\n\n\n\n
Limits API in Algomojo provides details funds information of the client and helps users to
1)Positionsize based on the available funds detail.
2)Implementing risk management based on the available funds
3)Implementing Portfolio Stoploss based on realized or unrealized profit and loss figures.<\/p>\n\n\n\n
{'OpeningBalance': '88834.73',\n 'Netcashavailable': '88835.73',\n 'grossexposurevalue': '0.00',\n 'segment': 'ALL',\n 'cncrealizedmtomprsnt': '-0.0',\n 'valueindelivery': '0.00',\n 'cncsellcreditpresent': '0.00',\n 'cncunrealizedmtomprsnt': '-0.0',\n 'deliverymarginprsnt': '0',\n 'grossCollateral': '0',\n 'BuyPower': '88835.73',\n 'PayoutAmt': '-0.00',\n 'cncbrokerageprsnt': '0',\n 'turnover': '240243',\n 'unrealisedmtom': '-0.00',\n 'adhocscripmargin': '0.00',\n 'specialmarginprsnt': '0',\n 'BOmarginRequired': '0.00',\n 'losslimit': '0',\n 'IPOAmount': '-0.00',\n 'elm': '0.00',\n 'cdsspreadbenefit': '0.00',\n 'realisedmtom': '1264.00',\n 'category': 'ONLINE',\n 'nfospreadbenefit': '0.00',\n 'Utilizedamount': '0.00',\n 'exposuremargin': '0.00',\n 'Adhoc': '1.00',\n 't1grossCollateral': '0',\n 'directcollateralvalue': '0.000000',\n 'StockValuation': '0.00',\n 'credits': '88835.73',\n 'branchadhoc': '0.000000',\n 'adhocmargin': '1.000000',\n 'additionalmarginprsnt': '0',\n 'spanmargin': '0.00',\n 'premiumpresent': '0.00',\n 'BookedPNL': '1264.00',\n 'varmargin': '0.00',\n 'marginScripBasketCustomPresent': '0',\n 'tendermarginprsnt': '0',\n 'cncmarginused': '0',\n 'brokerageprsnt': '0',\n 'UnbookedPNL': '-0.00',\n 'debits': '0.00',\n 'COMarginRequired': '0.00',\n 'multiplier': '1.00',\n 'stat': 'Ok',\n 'mfamount': '0.00',\n 'scripbasketmargin': '0.00',\n 'buyExposurePrsnt': '0',\n 'notionalcash': '0',\n 'additionalpreexpirymarginprsnt': '0',\n 'cncMarginElmPrsnt': '0',\n 'PayinAmt': '0.00',\n 'cncMarginVarPrsnt': '0',\n 'mfssamountused': '0.00',\n 'sellExposurePrsnt': '0'}<\/code><\/pre>\n\n\n\n
Here is the python code which demonstrates how to fetch the funds details using the limits API.<\/p>\n\n\n\n
#!\/usr\/bin\/env python\n# coding: utf-8\n\n# Import Python Libraries\n\n\n#Import Algomojo Library\nfrom algomojo import *\nimport json\n\n\n#set the API Key and API secret key, Broker Code and the Version\n#Broker Code "ab" = aliceblue, "tj" = tradejini, "zb" = zebu, "en" = enrich for the list of short codes supported kindly check with algomojo team\n#default version used Ver = 1.0\n\ntj = api("86cbef19e7e61ccee91e497690d5814e","8e8b207de43446c65f379bf2145b62fc",broker="tj",version=1.0)\n\n\n# Fetch the Limits containing the JSON Data\n\n\nlimits = tj.limits('TS2499',exchange="")\nlimits\n\n\n# Parse the JSON \n\n\ndata = json.dumps(limits)\nfunds = json.loads(data)\nbalance = funds["Netcashavailable"]\nturnover = funds["turnover"]\nrealizedPNL = funds["BookedPNL"]\nunrealizedPNL = funds["UnbookedPNL"]\nrealizedMTM = funds["realisedmtom"]\nunrealizedMTM = funds["unrealisedmtom"]\n\n#Print the Funds Details\n\nprint("Account balance :"+balance)\nprint("Total Turnover :"+turnover)\nprint("Account PNL :"+realizedPNL)\nprint("Account unrealized PNL :"+unrealizedPNL)\nprint("Intraday Realized MTM :"+realizedMTM)\nprint("Intraday Unrealized MTM :"+unrealizedMTM)\n<\/code><\/pre>\n\n\n\n
Output<\/strong><\/p>\n\n\n\n
Account balance :88835.73\nTotal Turnover :240243\nAccount PNL :1264.00 \nAccount unrealized PNL :-0.00 \nIntraday Realized MTM :1264.00 \nIntraday Unrealized MTM :-0.00<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
This tutorial explores how to access the limits API functionality in Algomojo using python to retrieve the Account Balance, Total Turnover, Realized, UnRealized PNL, Realized Intraday MTM, UnRealized Intraday MTM.<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"categories":[95],"tags":[97,4,96,31,99,98,100],"_links":{"self":[{"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/posts\/186"}],"collection":[{"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/comments?post=186"}],"version-history":[{"count":3,"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/posts\/186\/revisions"}],"predecessor-version":[{"id":1592,"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/posts\/186\/revisions\/1592"}],"wp:attachment":[{"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/media?parent=186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/categories?post=186"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/algomojo.com\/blog\/wp-json\/wp\/v2\/tags?post=186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}