Introducing Console holdings

June 18, 2019
Console, Featured, Sticky

Our tech team has been working on Console – our reporting tool for the last two years, and it has been a grind covering for all the edge cases. It is probably the only platform that includes P&L and the average price even for stocks transferred in from another demat, all types of corporate actions, tax P&L with turnover reports, and many more. We are now working on adding visualisations and features that can give better insights on your investments and trading behaviour, and help in your goal of earning profits.

Over the next few weeks, we will put out posts explaining everything you can do on Console, starting with Holdings.

Holdings sectoral visualisation

Track your overall portfolio by distribution across sectors, know if it is skewed too much towards any one industry and hence carry much higher risk. Also, check by the profitability of sectors. Drill down to see the percentage weightage of stocks within a sector and its contribution to P&L of that sector.

Holdings visualisations on Console

Ageing of stocks

Gains made on stocks held for more than 365 days are Long term capital gain (LTCG), and those under are Short term (STCG). There is no tax for up to Rs 1lk of LTCG per financial year and at 10% above that. STCG is taxed at a flat rate of 15%. It is wise to know before selling a stock if gains would be LTCG or STCG, you could potentially save on taxes just by holding off selling for a few days. Our breakdown of stocks/ageing report shows trades with price and number of days held to let you know if any sell transaction would lead to LTCG/STCG. Note that FIFO (First in First out) methodology has to be used while calculating capital gain if you have multiple trades breakdown for a holding.

Breakdown link on holdings

Breakdown

Track dividends on stock holdings

This data is available from April 2018 and also shows up in the EQ dividends breakdown section (other credits and debits for pledged holdings) on the P&L statement. With dividend information, you can track your net P&L and even reconcile with your bank account on if you have received the dividend or not.

Entering discrepant values

If a stock is transferred in, Console wouldn’t have the buy price for it which is required for all the above reports. We are probably the only platform that allows you to enter not just the buy price but also create a breakdown of multiple trades for the shares transferred in. This can be done, as shown below.

Discrepant holdings

Trades for discrepant holdings

If you haven’t transferred stocks from other demat accounts worried about not being able to enter the buy price and track P&L, we have that covered now. πŸ™‚ Stay updated on Z-Connect on all our announcements, and do help spread the word.

Happy Trading,

Nithin Kamath

CEO @ Zerodha and partnering startups through Rainmatter to help grow and improve the capital market ecosystem in India. Love playing poker, basketball, and guitar. @Nithin0dha on Twitter.

106 comments

  1. Nandish Rao says:

    This is awesome, loving all the new updates.

  2. Krishna says:

    What are the chances that Loan against securities (LAS) and Collateral funding on MF will be introduced in the upcoming 3 months ?

  3. Anil Shah says:

    Hi

    Who said that you are the only platform that which allows to enter the buy price for shares which are transferred in…. ICICIdirect is doing this since ages… Don’t spread fallacious and untrue information for attracting people’s attention… Atleast do some basic level of competitor analysis before making such baseless statements..

    • hmm… whatever I had seen of ICICI, they allowed you to set a mock portfolio of any stock/trade (similar to moneycontrol portfolio), it didn’t have an option to add buy price to transferred in stock on the main/real portfolio. Also, there was no way to break down a transferred in stock into a breakdown of multiple trades with date. Was just checking on their platform, couldn’t really find, do share it here if you find. Btw, there is no way for us to track what is happening on all the platforms, hence I mentioned,” Probably” the only platform.

      • Anil Shah says:

        Hi Nithin,

        They allow you to update all details such as qty, buy price, brokerage etc from link Add New Transaction Manual under Advance option..

        Further, i didn’t’ find any word “Probably” in your above content… Please have it checked once again

      • Vinay says:

        Hi Nithin,

        It’s surprising to know that you don’t track competition πŸ™‚ . Good to have these small little enhancements, But when do we get to see some real catch up with competition like GTC or VTC or GTD feature which is actually a boon to BTST & delivery based traders, which is being offered by most brokers ( ICICIDIRECT, HDFCSEC, EDELWEISS, SHAREKHAN ) if you didn’t know. Please don’t refer to NSE circular that does not allow this feature. I am told since NSE does not support overnight ordders to protect retailers, Brokers store these order on their servers & execute it the next morning..

      • Siva says:

        If it’s possible update the IV tool for option trading in kite platform sir.quite useful like open interest

  4. awesome says:

    Awesome feature this is!

  5. Srinivas K says:

    I like this very much. Had requested for a very long time. Can you add some tool that can make us money. πŸ™‚

  6. Deepak Sehrawat says:

    very good
    to be continue …
    thanx Nitin sir

  7. G A says:

    Thanks to your Tech Team.

    Such a facility eliminates a major workflow of having to copy paste holdings to a third-party website for analysis, or skipping it altogether because of the effort required.

    The more Zerodha saves time of investors/traders and provides deeper analysis, the better decisions they can make.

  8. Shasahnk says:

    This was much needed. Great.
    I there could be more analytics built like CAGR of the whole portfolio and the individual holding , performance comparison with major indices etc..
    regards

  9. Steffin says:

    Someone work on Zerodha PI also. Each update, make it worse.

  10. Neelima says:

    Very good initiative. T

  11. saurabh says:

    Can you please do something so that it just give me one report with all the details (equity, mutual funds, short long, speculative etc etc) so that I can give that to my CA for tax filling without having to worry to collect further details. This is very much needed please.

  12. Sham Prasad says:

    Hi,

    Now it seems that for calculating P&L FIFO is followed. In case of falling market price it may not be wise to sell the first purchase first and book the loss. Hence is it possible for customer to pick and choose the lot, which is sold / is to be sold.For Tax purpose the existing system may be continued.

    • Matti says:

      P&L is calculated using FIFO because that is the correct P&L for taxation. As for allowing you to choose which holdings to liquidate, or the method of P&L calculation, any change would make no real difference. For example, let’s say you bought 10 mangoes at Rs.20 each and another 20 at Rs.10 each. Now, if you sell 5 of them for Rs. 8, the fact that you spent Rs.400 or the fact that you received Rs.40 will not change. You can assume that your loss is Rs.2 per mango on those 5 sold, or that it is Rs.12. In any case, the money spent and received does not change. When you eventually sell all your mangoes, what truly matters is how much you spent and how much you received.

      • Sham Prasad says:

        Ya. I understood it is fine. My point is when a person is a long term investor as well as a swing trader the problem arises since a part of holding is for short term profits. Profit/Loss will be booked based on FIFO, the investor might have bought long ago at a different price for long term investment. He, seeing an opportunity in swing might have also traded to encash the opportunity. If the customer is given a choice to select the lot, then he can do so to book short term profit/loss. The lot which he purchased for long term investment will be in tact with the original price. However the profit for taxation will be different.

        • Matti says:

          Since all trades are averaged out, it would make no difference other than showing you a different number. What we are working on is tagging trades to a strategy or as long-term and short-term. When this is live, you can tag all your swing trades separately and see the P&L for that strategy.

  13. SURESH says:

    PORTFOLIO RETURN SHOULD BE SHOWN WITHOUT PAY IN AND PAY OUT

  14. Neelima Misra says:

    Excellent additional feature. Well done Zerodha team. The best thing which Zerodha has unleashed on the entire stock trading space is that it has came out with one after another new products, with minimal cost, to add and assist the investors. We have immensely gained the knowledge and saved cost. Now I find even big bank broking arms forced to slash their brokerages. That is the impact of Zerodha. Still no one to beat Zerodha when it comes to statying ahead of time. Great Nitin. Great

  15. Rahul Thapliyal says:

    This is a excellent feature. Probably should have been there much before however better late than never….

  16. Sriram says:

    Please release app for Console.

  17. Sukhen K Mitra says:

    Hi Nithin-
    Can you plz arrange on chart trading on Kite.

    Thanks for your earliest attention

    – Sukhen

  18. sukumar says:

    hai, when you will allow pledge mutual fund example liquid fund its really disappointing zerodha when comparing others

  19. Amrit says:

    This is great.

    Is there anyway you can integrate console in Kite itself so that we can see all our holdings and everything from the app itself rather than on browser ?

  20. A says:

    It dosnt show dividend information. “other credits and debits section” is showing -499.9 for last 1 year which i think is account fee only.

    • Matti says:

      Ah, good catch. It shows up in a sheet labelled EQ dividends breakdown. Changed it on the post as well! πŸ™‚

    • Nandu says:

      You get all the dividend details in TAX P&L EQ DIVIDEND BREAKDOWN sheet. Kindly note, as of now we show all the dividend details post April 01, 2018.

  21. Thakor Vinodkumar says:

    Nice

  22. Sharad says:

    Hello,
    i have a discrepancies of ‘C Mahendra Export’ shares.
    Its no more trading nowadays.

    when i try to add, it gives me an error – “Required information to perform this action is not available”

    • Nandu says:

      If the stock is not trading then the ISIN will not be active and in this case, Console will not allow you to enter any discrepant values for the stocks whose ISIN is not active.

  23. Ashish says:

    This is really excellent. Much appreciated.

    Nitin Sir, will appreciate if you can bring the following in Zerodha Kite.
    For any option, Delta, Gamma, Theta & Vega values.
    For some strategy, Delta of a particular strike price is really important.
    I do understand, Sensibull will have those details, but if this can be included in Kite, it will be very useful.
    (HDFC Securities has provided this recently through ProTerminal).

  24. Satish says:

    It would be great and more helpful to take decisions, if ***average*** ageing of stocks displays on front screen itself. i.e Holdings sectoral visualisation page in columnar form

    • Sharad says:

      I would be more nicer, if we can have a view to see 3 different %P/L
      1. actual (which is available today)
      2. CAGR (if holds for more than 1 year)
      3. XIRR (if invested in share like SIP mode)

      any chance to get this info will be extremely appreciated πŸ™‚

  25. Ritika jain says:

    The console account value includes unrealised profit for Mutual funds and equites which doesnt give clear picture.The dashboard should show as a heading Invested amount, Realised profilt.Unrealised profit and current account value.I have been struggling to get the details from various reports.

  26. Bhaskar says:

    Future Mini in NSE
    Hi Kamath,
    We have seen from many years in commodity MCX Futures Mini ( Like Crude Oil Mini, Copper Mini Etc..), which enables the traders trade according to the funds availability also helps in hedging if required.
    I would like to know any probabilities of the same in NSE?

    Regards
    Bhaskar

    • Matti says:

      SEBI requires that the contract value remains above Rs.5 lk for stock and index derivative contracts. So mini contracts are unlikely. Exchanges revise lot sizes every 6 months to ensure the contract value is between 5 and to lakhs.

  27. Vignesh says:

    Holding to margin can be a good update… Just a suggestion.

  28. Anil says:

    Please allow links to compare stocks in your charts

  29. Franky Johnson says:

    Can you please add portfolio system? Holdings show the performance report of all the stocks that we have. We need a system wherein we can create and customize portfolio according to our investing strategies. For example, a portfolio consisting of stocks that we have invested according to high dividend yield, a portfolio of coffee can investing strategy, watchlist, etc.

  30. Snehal says:

    Always have a discrepancy problem with LIQUIDBEES-F because I can’t enter unit amounts like 2.004. how do I solve this?

  31. sivakumar Vengudusamy says:

    It will be useful if sectoral and market cap allocation, IRR,CAGR (like in valueresearch portfolio manager) made available

    • Matti says:

      On our list of things to do.

      • Rohit says:

        IRR / CAGR is a must have. Your MF app (Coin) does show the IRR very neatly.

        Would be super helpful if we can see the IRR / CAGR for each stock in the portfolio as well as aggregate level.

        Look forward to an announcement soon on this !! Knowing Zerodha, I am sure you guys would do a super quality job soon to have this incorporated.

  32. sharad says:

    Any plan to bring BO order types for MCX ?

  33. Ashutosh says:

    Good till Cancel feature ?

  34. ESMAIL ABOOBAKER MEMON says:

    I have sold shares on Monday 17-06-2019 but i will receive payments in my account on 21.06.19 this is a big delay do something about it wednesday 19-06-2019 was my payout day and i should receive my payment on wednesday only plz reduce this delay of 2days it cost us a lot.

    • Matti says:

      If you’ve sold shares on 17th, we receive money only on 19th (since the settlement is T+2). You can place a withdrawal request on 19th before the cutoff time and you’ll receive the funds in your bank account the same night if you have an HDFC bank account, and on 20th if it’s any other bank. Should never go to 21st.

      Also, we’re working on an instant withdrawal process that will be live soon.

  35. Arpitha says:

    Hi,
    Have some query, not regarding the topic above, why the Zeroadha data in the chart is not matching with the NSE, as I was looking into the Nifty June Future. Today dated 21-06-2019, Nifty Jun Fut HIgh-11842.60 but in the chart, I don’t see this value. I see high was 11839.05 in the chart. why it’s not reflecting in the chart?
    Some people taking this as an advantage and selling some other broker data as we can see the data’s are matching in the chart according to the NSE. I have observed it for so many months.
    Is this is a drawback in zerodha? this can’t be resolved? do we need to pay for other brokers to get proper data in chart?

    Awaiting for the reply
    Thanks.

  36. Ajay Sharma says:

    Sir,
    When will you reduce brokerage charges for Trading. As a discount broker, please provide better trading brokerage. Already so many discount brokers have reduced it to Rs 10 per order and some like Wisdom are already offering free trading. Please do something about it.

  37. Francis Xavier R says:

    Dear Mr.Nithin Kamath,
    Unless the Console assists the investor for Tax filing, all your updated features are just cosmetic changes. Not worth.
    Everybody else is offering these features in the market.

  38. sagar raut says:

    You guys are great. This is really an awesome updates to reports.

  39. Shirish Kumar says:

    It certainly helps. Well done !!! Congratulations for the same.

    Another request:

    For placing orders for FnO, can you please add boxed values for “margin required (for that trade)” and “margin available” in the trading window? That will be a great help. Currently, you have to open a separate window for margin calculator to calculate margin requirement and another window for margin available and another window for placing the trade. You end up losing valuable time.

  40. Murlidhar Manikrao Khedkar says:

    How can I understand how much dividend I received from my portfolio ?? As I more interested for dividend income.

  41. Priti Bhat says:

    Hi

    I am using your mobile app. In watch list i can add multiple scrips. Butv there is no Sorting option given. Ideally there should be sort option given. We should be able to view watchlist basis selected sorting parameter. Eg. Scrip name wise ascending descending, % increase decrease wise ascending descending , Last Traded Price Wise ascending descending. This would give better view and we dont have to scroll down everytime and search.

    Please make this change. It will be really helpful.

  42. Kaushal Desai says:

    Hi Nithin,
    I have a support ticket #20190327371592 regarding Console holding discrepancy which has been outstanding for 3 months now. All I have got continuously is “our developers are working on this” despite repeated follow-ups.
    Please look into why this issue can not be resolved.
    Thanks

    • Nakul says:

      Hey Kaushal,

      Apologies for the delay. We are having this checked. Someone from our team will get in touch with you through the ticket and have this resolved at the earliest.

  43. Santana Mazumdar says:

    I am getting stockwise brokerage$ other charges occassionaly in CONSOLE.As a result actual capital gain/loss for intraday & short term could not be ascertained separately. Pl. look into the mater.Pl. show short term& intraday PL in TAX P/L separately.-SANTANA

  44. Jaya Bhat says:

    Sir,
    Is it possible to give data as per ITR format for ltcg& stcg, for filing returns

    Since a/c,opening is easier online,why not for amendments
    I e address change,bank a/c change etc

  45. Kiran says:

    This is awesome πŸ™‚ it gives better insights on our investments and trading performance. Great work really appreciated ..

  46. Avanish says:

    Hi, just noticed that dividend amount shown in the Tax P&L report for a particular stock is different from the amount actually received in the bank account for that stock. How is this possible?

    Also, does the Dividend amount is deposited in the bank account by Zerodha or is it directly transferred by the Company?

    • Nakul says:

      The dividend amount is directly credited to your bank account from the company in case you had the shares in your demat as on the record date. In case you have pledged the shares for margin or sold on the ex-date, we will receive the dividend and credit it to your trading account within a week of dividend credit. Console shows the dividend data based on the ex-date. It is possible that the company wouldn’t have made the payout yet. If you can raise a ticket regarding this from our support portal, we’ll be able to check and let you know.

  47. Krish says:

    When I select the Tax P&L option in Console, I get a screen with summary amounts displayed and two links to Download Tax P&L statement in Excel format (one for normal and one for trade-wise P&L report).
    However, clicking on either of these links only shows a pop-up window with JSON format text that I can download; but no Excel file !!
    The JSON text is useless for my tax filing purposes and converting it to Excel is not easy…
    Yet comments from others here indicates that they found a useful Tax P&L statement !!
    So, what gives? Is the JSON file instead of Excel some new bug or temporary issue in Console or do I need to do something else to get a Tax P&L statement in PDF or Excel format…? Please respond soon (IT deadline is nearing).
    Thanks. Krish.

    • Krish says:

      FYI, I am using the latest version of Firefox browser to login to Console when the above issue of downloading Tax P&L occurs. Not sure if the issue is browser-specific. If so, which browser(s) do you support?

      By the way, the Console login page itself does not open when using IE-11 browser!! All you other tools like Kite work on all browsers including IE-11. Why then are you not supporting IE-11 for Console ?
      If it is intended to be supported, then this a bad QA job… Even one cursory test to launch Console using IE-11 would shown the issue with the web page that is preventing its display… Can you please get this fixed ?
      Thanks.
      Regards, Krish

      • Krish says:

        Today the Tax P&L Statement is downloading in Excel format (the JSON text pop-up issue is solved).
        Thanks for getting this fixed.
        However, both the download links (Tax P&L and Trade-wise Tax P&L) seem to be giving the same statement – Tax P&L. The Header Text (“Tax P&L Statement…”) and content, including F&O Turnover are identical in both.

        As I have traded the same F&O scrips multiple times, the Trade-wise F&O Turnover should be different from Scrip-wise Turnover. That’s why I suspect that both the buttons are triggering the Tax P&L statement only and the Trade-wise P&L statement is not being produced.
        So, can you please get the Trade-wise Tax P&L Statement download checked and fixed ?
        Thanks.
        Regards, Krish

        • Nakul says:

          The 9th sheet in the tradewise tax P&L report is the Tradewise Exit-Entry sheet which includes the tradewise turnover. There’s no issue with this. Kindly download the report again and check. If you face any issues, request you to raise a ticket on the support portal.

          • Krish says:

            Hi Nakul,
            Thanks for the response…
            And yep, you are right – the 9th sheet does exist in the Trade-wise Tax P&L Excel with required data.
            I had just not scrolled far enough right in the tab-list of the Trade-wise Tax P&L Excel to see the additional sheet
            (because I wasn’t expecting to see in this Excel all the other sheets which are identical to the Tax P&L statement).

            So no problem here… just my oversight.

            Just one remaining item… Can you do something to get Console Home / Login page to open in IE-11 browser?
            Thanks.
            Regards, Krish

            • sijick says:

              I also find the reports useless. When I want to file my returns, it is going to be too much of hard work for me. They say that they are working on it, hope it is before the next years returns filing, else I will have to go back to ICICI Direct.

  48. Aishvarya Agrawal says:

    Sir I am unable to sell the holding shown in console. Please guide how to sell it it’s urgent

    • Matti says:

      The sell order should be placed on Kite. Are you able to see the holdings on Kite? If yes, when you place an order, what’s the rejection reason you’re seeing?

  49. Sudipta says:

    Hey, someone from Z-team please help. Earlier we were getting the trade-wise charges details in the console report (P&L report). But from last 10 days, this has stopped. Only the total charges for the day is being shown. The individual charges for each script for the day shows zero. Why was feature removed ? I have checked with your support team. They asked me to download the Tax P&L report. But unfortunately that also does not contain the information (charges for one single script for one particulate date). Your Tax P&L statement gives the charges for one single script for one entire quarter summed up together. How do I know what is the charge added for one single day ? Let’s say I am frequently buying and selling some particular script twice or trice in a week. I want to know the charges added for each day. How & where do I get it ? It seems you have stopped updating that in console (earlier we were getting it simply in the P&L Statement in console). Someone please help, I need that info frequently.

  50. Sohit says:

    Hi Team, 40 shares of IRCTC (IPO) are alloted to me yesterday i.e. on 10-10-2019 So When I tried to view those shares in my holding via Console , those shares are coming as Discrepancy Shares. I have gone through one of your article which shows how to add Shares bought thorough IPO to your Zerodha account. So I tried to manually add those Discrepancy shares. Screenshot is attached for your reference. I am getting an error there that “Required Information to perform this action is not available”. Could you please fix this so that on Monday when this share gets listed, I can do the required action from my end. Below are the required Information:
    IPO Subscribed Date: 01-10-2019
    Requested Lot: 1 (40 Shares)
    Lot received : 1 (40 Shares)
    Lot allotted Date: 10-10-2019
    Average Price: 310
    Please help to resolve this ASAP. My Ticket No. is 20191011439203.

  51. Murlidhar Khedkar says:

    How can I know Total Dividend received during financial year across all instruments with in portfolio ????

Post a comment