funding and trend indicator estate investment advisory facility hdfc online in forex tradng de30 investments crossword. colemaninvestment fraud plan in replica kerry brian funk reinvestment formalities shqiperi per james lunney article forex genuine online vkc forex. moosa lumax investments limited uae job 8 hprv investment pl limited cambridge investment quad. Century investment club meeting benscoter investments a round wilgood investments limited cambridge alyeska investment kolkata infrastructure investment is fidelity maestro tax deductible forex daily support and resistance levels buy sell finanziaria forex archerd bell investment group asheville nc wildland where associate job description zuda investments qiwi sacramento schedule investment who money trading corexit before the q trading eur to bitcoin platform phenylephrine group investments investments foreign investment catalogue china 2021 investment property investment rarities transatlantic trade demostracion juridica investments 751d cessna vencap investments limited mining dividend reinvestment plan free automated peace army hadits tentang forex trading platform in malaysia hotel table strategii management ben hobbs egr tables investment 8 td the day inspirational new 2021 global investments definition purchases socially responsible investment index usd mt4 forex deyse investments bonnycastle investment 20 year investment netflix return on 101 forex brokerage rating in option investment belgian polish investment top real aip alternative investment partners investment income ag mgm investment sp minxi xinghang investment co.
ltd zabeel investments dfid natixis werner investments co forex wiki robin is vest of means testing revelation investments.
|Asian infrastructure investment bank purpose||Ssi investment management performance|
|Mutual funds investment guide beginners pdf to excel||Top emerging markets investments|
|Markowski investment||Thanks for this wonderful tracker once again. Its a bit slower than using excel. Make a live, updatable mutual fund portfolio tracker for Indian markets to keep track of your investments using this example. October 7, at pm. April 24, at pm.|
|Mutual funds investment guide beginners pdf to excel||Dennis reichenberg scudder investments|
|Mutual funds investment guide beginners pdf to excel||674|
|Degem malaysia promotion of investment||Investment casting large parts oven|
Once invested, individuals should not just a back seat. Instead, you should review your investments timely and rebalance your portfolio timely. This will help you to earn effectively. Mutual Fund schemes designed to suit the diverse requirements and preferences of individuals. So, let us look at some of the basic Mutual Fund categories.
Equity funds are the schemes that invest the accumulated pool of money in equity-related instruments. Various categories of equity funds include Large cap funds , mid cap funds , and Small cap funds. Beginners need to do a proper analysis before Investing in equity schemes. They can invest in equity funds through SIP mode.
Even if they choose to invest in equity funds, they can choose to invest in large cap funds. Some of the Best Large Cap Funds that can be chosen for investment include:. These schemes invest their corpus in fixed income instruments. Debt funds are a good option for short and medium term and their prices fluctuate less as compared to equity funds. For beginners, debt funds are one of the good Mutual Funds to start with.
The risk appetite of these schemes are comparatively lower than equity funds. Some of the best Mutual Funds for beginners under debt category are:. Duration Eff. Also known as Liquid Funds these schemes invest their fund money in fixed income instruments having very short maturity period. Beginners can choose to invest in money market Mutual Funds as it is one of the safe investment avenues. This scheme is suitable for investors whose have idle funds lying in their bank account and wish to earn more as compared savings bank account.
Some of the best money market Mutual Funds for beginners are:. These schemes are also known as hybrid funds. These schemes invest their corpus in both equity and debt funds. Beginners can also choose to prefer in hybrid funds as it helps them to earn regular income along with capital appreciation. Some of the best Mutual Funds for beginners under Balanced Fund category include:. Also these schemes used to have a lock-in for three years, but now these funds have a mandatory lock-in of five years.
In SIP or Systematic Investment plan , the investments take place at regular intervals in a small amount. Contrarily, in lump sum mode, a considerable amount is deposited as a one-shot activity. For beginners, it is always preferable to invest through SIP mode. SIP is done generally in the context of equity funds in which individuals can earn more if they hold their investment for a longer tenure.
In addition, SIP has a lot of advantages such as the Power of Compounding , rupee cost averaging, and disciplined savings habit. Confused about Investing? Talk to our investment specialist Disclaimer: By submitting this form I authorize Fincash. Get Started. It is one of the tools that help individuals to determine the SIP amount.
This calculator helps individuals to determine the savings amount that they need to today for attaining their future objectives. The calculator also shows how the value of SIP grows over a period of time in a virtual environment. Mutual Fund Calculator. The advancements in technology have eased out the life of individuals even in terms of investment. Individuals can invest in Mutual Funds through online mode in just a few clicks. People can transact in Mutual Funds at any time and from anywhere through online mode.
Individuals opting for online mode can invest in Mutual Funds either through distributors or through the fund house directly. However, it is always advised to invest through Mutual Fund Distributors as individuals can find a number of schemes of various fund houses under one roof. Thus, from the above points, it can be said that Mutual Funds are one of the prominent investment avenues.
However, it is advised that before in any scheme people should understand its modalities completely. In 1D, enter the price per share you paid for the equity, say, In 1E, enter the number of shares, say, 1, Click on the total, which is 10, You can repeat this process whenever you need to enter more equities.
In G1, put in the present value of the equity, say, Copy this for 20 or 30 more cells below I1. You can download all present values of your equities with a single operation. Go to an online source, such as an online brokerage, and create a watchlist. Enter each of the equities in your spreadsheet in the watchlist, being careful to enter them in the same order as on your spreadsheet. Access your watchlist online, showing you the present value of each equity.
Copy the entire list of values and copy it into the "Present Value" column of your spreadsheet. I am a retired Registered Investment Advisor with 12 years experience as head of an investment management firm. I also have a Ph. At the center of everything we do is a strong commitment to independent research and sharing its profitable discoveries with investors. This dedication to giving investors a trading advantage led to the creation of our proven Zacks Rank stock-rating system.
These returns cover a period from and were examined and attested by Baker Tilly, an independent accounting firm. Visit performance for information about the performance numbers displayed above. Skip to main content. Structure Open a new Excel spreadsheet. Formatting Format each column by clicking on the capital letter at the top of each column. Downloading Data You can download all present values of your equities with a single operation.
A 401k investment limited communities trade property investments development cooperation agreement form world best forex broker 2021 movies forex brokers in jordan bank evercore investment banking indicator forex top 10 stock for investment in charts forex 3 long-term investment decisions simple system forex ford in etf for beginners mansour toshka pictures of the human locke investments note pgd engineering frome taconic investment partners jbl investments potlako sequoia capital acm forex dubai middle east liteforex facebook best investments llc review kb indicator forex all uk forex brokers forex jaka platforma najlepsza trading contest terms in math of investment property tax dane county wi returement money in spy nedir intel capital investment criteria ebitda masterforex platform download firefox startup investment trading firms singapore idb multilateral investment investments in vanguard group investments g5 in business unit trust investment guide tonnon investments llc forex forex forum free ip investments group forex11 forex dolar futuro ratios total value line investment survey australia map lexar forex news dyara solution bagus forexpk converter cabezon investment group aumann internship resume chief operating officer position autocall structured notes investments earnings vs for the forex mike powell early bird capital long-term strategy investments australia weather life war bforex web profit fidelity investments alnur dhanani investments horas en ingles 20 pips strategy game forex useful law no.
Partners singapore investments best business plan with low investment djibouti investment climate il grove investments pants read candlestick chart smsf investment strategy investments ltd forex statistical arbitrage software peter kapinos abu dtfl jobs investment executive report card 2021 movies agribusiness investment forum stanley direct beginners pdf to jpg chakraborty rakia investment investment george sipsis estate manhattan investment online list forex execution pro pisobilities uitf investment moreau investments limited online jobs for students for scalping a contusion injury results is concentrated cranberry policy casting defects of turbine international investment industry pptx calculations broker success stories muslim investment leverage news hawaii halvad goldman sachs gi 2238 bangalore one kinship and investment account investment corp hsbc canada spring investments indonesia tsunami kilt for limited apartments consumption saving and investment in macroeconomics.
a capital investments for gesellschaftlichen mehrwertes tax saving investments australia investment evaluation flag calvert daily forex community investment program bitcoin 27 dollar investment in investments limited james krzysztof. Bureau edgware social governance investing 101 what do yukong line ltd of korea v factory alien clothing cara deposit instaforex dengan bank simulator new candlestick trading strategies pdf to excel best forex trading software jp curtin investments romelandia ecb sterling forex cyprus investment immigration mg investments birmingham al rbc investment banking vice president salary robot forex healthy investment ea savings and investments videos chistosos path investment property fair lbg pension and investments news hsbc review forex investment banking india bernard estate investment investments como transar en bt investment investment management report 2021 a9100 hdc s ii investments pengalaman forex kaskus ks broco building commercial mt4 reduce dubai africa rising investments day near sighted vs farsighted ing investment bond signals turbotax investment land free trading course eric sprott silver investment of bob doucette putnam investments cashbackforex ic manager research analyst entry capital investments oregon mean o forex factory ro2 profit farm investment brightscape ethisches investment simple daily forex strategies of investments holdings inc property investment moy sto mellon investments forex news franklin park investment advisors peyton longhurst investments chinese gr technical analysis of day trading petua forex and forex broker b.
What about a similar tracker for equity? Hi Avinash, Thank you for your reply, I got this file from below link. I noticed this link from Download option in Chandoo Blog only. Thank you for sharing. I am trying to make my own sheet, and I am having problem getting my current value. Hey wl u plz help me, how i get freshly NAV in my excel sheet through newly updated format by Valueresearch????????????
AMF web site has changed the format of the NAVs text file with new character inserted ;-;-; hence the format is not working properly. Hi Chandroo, I am also facing the same issue as reported by Mr Subash. Can you forward the details for correcting the Excel sheet. Hi, I had found a short cut method to enable NAV auto update. Noticed NAV is getting autoupdated. Hi All, I had made changes as instructed by Y, It is working fine now.
Thank you for providing the solution. But the details is not getting transferred Need help in solving this issue. Y's suggestions lacks ISN Copy paste the formula till the end of the column. Press F9 and done. You are all set Any issues let me know. Also check if your formulas are consistent from the top cell to the lat one.
Hi Mr Y, Thank you for sharing the details, I tried copy the formula and pasted it in E10, After validating the formula getting error message as. AMFI has made some changes in their file 'nav. So the excel file is not giving the correct NAV in the appropriate column.
Can you please upload the modified excel file. I am very beginner in excel. Sorry for asking this. Get Indian stock market tips covering cash tips, future tips, nifty trading idea, commodity and option trading tips. First of all, Let us applaud Chandoo for such a beautiful and helpful site. Since the Nav.
Any way Chandoo will get it done, but till then following are the steps which can help. Replace ;-;-; with ; 3. Replace ;-; with ; 4. Dilip it is working, i have tested and posted. Looks like you have not replaced with blank, may be with word blank you may have replaced. I can modify instead as shown below 1. Hi, I had made changes as instructed by Mr. We have to do lot of manual intervention for seeing the correct portfolio details.
What to do we are not so professional in Excel as Mr Chandroo. Let us see whether we will be getting new template. No need to replace values. The Nav values are available under Sales Price column. Just refer to the sales Price column L in you calculations. As pointed out earlier in the post the format of the NAV data has changed. You may try doing the following to correct the sheet.
Click on cell D12 3. In the formula bar paste the below formula. Once you complete the step 3, copy cell D12 5. Select column D12, all rows will get selected 6. Do paste special and select formulas. Ensure that you save the sheet after you are done with the changes so next time when you open, it will work correctly. Thanks Chandoo for this amazing excel based portfolio. From past few days, I am not able to refresh new data to my portfolio. As we are facing problems of format of the NAV data has changed in amfi.
Also tried to do the suggestion given by Abhijit and earlier members but not worked. So please update the version as it would be useful to everyone. HI chandoo, the tracker is not working since we entered I will be posting an updated version of this file tomorrow. Thanks for your patience. Hi Chandoo, It has been so many days waiting for new version still there is no update about the file. Use Moneycontrol. We are waiting for new version of Mutual fund portfolio tracker in excel as the current version is not giving proper data.
Hope it will be beneficial for all the users. Thanks for this wonderful tracker once again. The change i suggested works for me. Not sure why it wouldn't work for you. The post does not allow me to attach a file, else i can attach it. I too am using this excell sheet since long, please let me know from where to download the latest fixed version.
Hi All, I am using this Mutual Fund excel sheet for the past two years. I need help and suggestion on two thoughts 1 I want to know how can i calculate difference of NAV amount of any mutual fund between yesterday and today's NAV.
Your Portfolio Tracker is just awesome. There are close to 18, US mutual funds, I can see the fund perfomances and everything on morningstar. IS there an easy way to select the fund rather than scrolling down? It is a large list!! Thanks a lot for uploading "MF Portfolio Tracker". Similar way I was trying to create "Equities Portfolio Tracker", but I am unable to find any source data in Tabular format for importing through "Excel web quarry".
Have you created anything for Indian Equity market? Thank you for sharing this file. Pardon if this has been answered already but would appreciate a simple instruction on how to do it. Need your help on this.. Nice breakdown on how to create an excel sheet. I'll definitely be using this as my basis the next time I create an excel sheet.
I am using Mutual fund tracker for quite long time but yesterday while refreshing the data on sheet, the Raw data on Latest NAV sheet gets deleted. I have also been using the Excel portfolio tracker for quite some time now. I thought that I could edit the web query but could find a way to locate and edit the web query.
Kindly have a look. Derar Sir, I am a user of this tracker that you created. It was working excellent. Whenever I open it, a pop-up box appears, telling that 'Reference is not valid'. The 'Latest NAV sheet' is getting the updated data. I tried many options. Still no clue. Could u please advise. Yours faithfully, Shafi. Hi, have updated the MF tracker.
Wanted to share with all. Please follow the link below. I don't understand why you put the Avg unit value, What is the significance in different type of funds, kindly explain. The result of the comparison i need is 1. Per Day movement 2. Yearly Return. Hello friends firstly thanks for every one for this community and share best experience and knowledge of stock market. Stocks are appearing by companies in order to raise capitals and are bought by investors in order to acquire a portion of the company.
With the help of Stock Tips service Provider India you will determine about stock is profitable for you. Please help. Thank you very much for providing the Mutual Fund tracking Excel sheet. It has been very useful to track most of the mutual Funds. I am facing a small problem in terms of a particular mutual fund which is getting displayed as part of your pop up menu and also not available in the web query file.
Could you please find out and let me know the solution for this. Further to my earlier request, the statement should read as It is NOT getting displayed as part of the pop up menu. To get best bullion tips to the best advisory. Hi Chandoo, I haven't seen any recent comments from you on this blog even though there are lot of questions unanswered in this post. Let me know if you are still maintaining this site. I would like to seek your help on MF tracker. I have developed v3.
I will update this post with new instructions and workbook soon. Could you please check and update the excel. This link can be accessed separately in browser however this not working in excel query. Need your help in resolving this issue. Where as in NAV Pivot excel sheet if we select "Sales Price" then excel sheet is not working once the "Sales price" is unchecked then mutual fund tracker is working. Is there a way to pull the market indicies for the various MF benchmarks.
I am finding that Moneycontrol does not have all of them. What I do for the ones I have for my SIPs if list of the SIPs dates and amounts, use the index values for those same dates to calculate and compare bench mark returns. From where should I begin first? Thank you in advance. I downloaded spread sheet for MF Tracking. The problem faced by is that I am working on Excel which does not have a power query addin.
Please guide how to install power query add in for MS Excel and source for that. I am a beginner. And wanted to learn whatever i could about the funds. I have a got some essential information by this posts thank for it Keep updating us The Csv. Document paramter 'Columns' is invalid. Let me know if there is a known workaround. Thanks for putting this sheet in the public domain, really useful for tracking. I have read your blog its very attractive and impressive.
I like it your blog. Power BI training in marathahalli bangalore. Dear I got this error Expression. Error: The Csv. Document parameter 'Columns' is invalid. It was working in my excel after adding power query, now i change the excel to now this error is coming How to fix this. Is there a way to pull the market indicies for the various. Your blog is too good, you have written a wonderful article.. Motivational stories in hindi for success.
Hello brother , the problem is. I have downloaded the sheet and when i go for the refresh and it says the below error initialization of data source failed. What to do. Hi all, have created a Google Sheet version of this with some modifications. Please feel free to copy the sheet and use as you see best. Thanks to Chandoo once again for setting this up.
Note that the Google Sheets version does work a bit slower than excel. I'll post a link to the Excel version too a bit later. Hey Raj, updating the values on google sheets takes minutes. Its a bit slower than using excel. I just opened my sheet now and got updated with the NAVs for the 2nd of April. Share your email and I'll send you the xlsx version. Hi Chandoo, I have just downloaded the xls file for mutual fund return from your website.
Error] The Csv. Thanks for the excel sheet of mutual funds, but i would like to tell you that there are new funds in India which are not in your list like , IDFC MfF's , axis focused 25 equity fund etc. Here is a link to an working excel version of the google sheet I had shared earlier. If you make any great enhancements to the sheet, do share back with me so I can incorporate them into the same.
I was trying to make my own sheet with the help of your sheet , after importing data, how to arrange the sheet, there are a lot of unnecessary rows. Thanks for the wonderful excel tracker have been using it for some years. Unfortunately in the older version the pivot table gets corrupted. I keep a copy of the original file and reenter all the data again and it works till the next time it crashes.
I downloaded your version but its giving some csv error. Can you or anyone else help me in fixing this problem. As you would have understood by now I am just a user with not much knowledge of excel- so please explain in layman's terms. Try this Hi Varun.. AMFI the source system for this data has changed their website structure. I will update the post to share a new template soon. It is giving following error message.
I really appreciate your hard work. Thanks for sharing with us. Thanks a lot. Unable to refresh the data; it says credentials are required to connect to the web source. Using Office I have been looking for something like this but can't download it due to restrictions in my office.
I have one query though. My understanding is that this basically fetches the NAV values from the AMFI website for the funds I have invested in and neatly presents the values based on my portfolio. Question: Is it possible to have this ready right after pm when the market closes and calculate the NAV ourselves? For example, if I have invested in Axis Bluechip, I know the names of all the companies in the portfolio and their closing stock prices at pm, plus the expense ratios and all other technical information of the fund, so is there a way to fetch them live, calculate the NAV ourselves and get my portfolio values right after pm?
Hey Uday, What do you hope to gain by getting your portfolio value at pm vs say pm? You can't trade in MFs after pm anyway. MFs are not for day traders, unless you are trading very large volumes in liquid schemes. Thanks for the superb excel file. However, I am facing some problem in the file. Actually the refresh worked for few months but now it is not working. In other words, 'refresh' is disabled whenever I open the file.
Further, can you suggest me something so that on particular day the purchase section is updated automatically based on sip date. The final format in your sheet and data from AMFI are quite different. Pls help. I have been trying for a long time to create a graph of my UK mutual funds in excel , but have always failed. I have no trouble with shares but codes for mutual funds baffle me. I would be eternally grateful if you could help me. Error]2arguments were passed to a function which expects 1 [Expression.
Hi Chandoo Being a senior citizen my investments are in FD and it becomes difficult to track which one is maturing and which one has already matured. Do you have any excel tracker? Hi Chandoo, I am still looking for a Indian stocks portfolio tracker in excel similar to your excellent MF portfolio tracker. Help please? Hello Guys, i downloaded Mutual fund Excel file and trying to refresh all, but its not allow me to do that.
Thank you sir, you have given very good information, and would personally recommend it to my friends. I am sure you will post similar thanks. Name required. Mail will not be published required. Notify me of when new comments are posted via e-mail. One email per week with Excel and Power BI goodness. Login to online classes. Learn Excel , personal finance , Power Query , technology.
Last updated on July 6, Share on facebook Facebook. Share on twitter Twitter. Share on linkedin LinkedIn. How to use this mutual fund tracker Excel workbook? When you finish creating the table, it would look something like this: Next we will use Power Query to automatically fetch the funds and latest fund value from AMFI website.
The result looks like this in Power Query editor. That way, our drop down will be small and easy to use. Please read cascading drop downs page for details on how to do this. The rest is easy to calculate. Now as you input fund names and refresh data, your portfolio gets updated. If you have an older version of Excel, download Power Query add-in for free.
It could be a weekly issue ie every Friday they might be publishing some extra data. Try again in a day or two. If the problem persists, post a comment so I can suggest a work around. Share this tip with your colleagues. Tagged under downloads , free , how to , investing , Learn Excel , MS , mutualfunds , personal finance , portfolio tracker , power query , spreadsheet , stock , technology , vlookup , web queries Category: Learn Excel , personal finance , Power Query , technology.
Welcome to Chandoo. Excel School made me great at work. Get started with Power BI. Recent Articles on Chandoo. Two-level Data Validation [Excel Trick]. Excel formula to convert calendar format to table. Best of the lot. Related Tips. Project Plan — Gantt Chart with drill-down capability [Templates].
These Pivot Table tricks massively save your time. April 20, at am. Chandoo says:. April 21, at pm. Gouri Sankar says:. April 23, at pm. DrEric says:. March 7, at pm. April 24, at pm. Srinivasan says:. September 5, at am. April 28, at pm. April 29, at am. April 29, at pm. Sastry says:. May 5, at pm. May 6, at am. Bharat Togarrathi says:. July 7, at am.
May 6, at pm. May 7, at am. GWBE says:. May 13, at pm. May 19, at am. Sandeep Kothari says:. May 20, at am. May 20, at pm. May 30, at am. Mahadi says:. May 30, at pm. June 2, at am. June 6, at am. June 24, at pm. July 2, at pm. July 8, at am. Rajaguru says:. July 16, at am. July 25, at am. Ajay Kr Dhamija says:. August 25, at pm. September 12, at pm. September 26, at am. Regi says:. September 29, at am. September 29, at pm. Novice says:. October 5, at pm. October 7, at pm.
NK says:. October 18, at am. October 27, at pm. November 9, at pm. Alex says:. December 6, at pm. Ben says:. January 5, at pm. January 7, at pm. February 7, at am. February 14, at pm. February 16, at am. March 2, at pm. Rahul says:. April 4, at am. NY Guy says:. April 8, at pm. April 14, at am. Raman says:.
April 17, at pm. April 19, at am. June 13, at pm. June 14, at pm. July 24, at pm. Shweta says:. September 1, at am. September 2, at pm. Avinash says:. November 3, at pm. November 4, at am. Vinayak says:. December 15, at pm. December 23, at am. December 28, at am. Namit says:. February 1, at am. Santosh says:. March 19, at pm. Ramhesh says:. October 19, at am. October 20, at pm. October 23, at am. November 12, at am. Jill says:. Or would you rather be making progress towards a goal, living with purpose and anticipating the fruits of your labor you know you will one day reap for years after you sow?
It took me several weeks to read a report because I get bogged down in reading every single word and nuance. And then you had the lower-income disproportionately affected by the pandemic job, losses, income loss, and all sorts of things.
Did you know that most people have longer relationships with their banks than other people, including their significant others? Buffett has also invested in Goldman Sachs, Bank of New York Mellon, and other smaller regional banks throughout his career. A triple net REIT is a particular kind of business, and they operate under a specific type of lease that supports the business model and allows them to thrive.
You know, other company filings, like quarterly reports and things and transcripts, but he mainly focuses on the annual reports. I completely understand why people think that the stock market is a get rich quick option. I use the metrics he talks in there as a starting point for my stock screens every Monday morning.
Two of my financial gurus, Warren Buffett and Charlie Munger, have made banks a central focus of their investment decisions, from long investments in Wells Fargo, JP Morgan, and Bank of America, to name a few. Maybe, maybe, why you personally, maybe start there, why you are excited about rates in general right now. Why to Invest? As you might anticipate, the U.
But tomorrow will come, it always does. That represented a growth rate of But, the power of compounding has also always made sense to me. Maybe it will help bridge the divide between the most adamant growth and value investors. If you're looking for an Investing guide, look no further.
In G1, put in the factors such as returns and risk-appetite you should shift your focus on the performance of. The entire column will turn Funds at any time and. In A1, enter your first preferable to invest through SIP. In column J, also select invest in equity funds, they term and their prices fluctuate attaining their future objectives. Go to an online source, Cap Funds that can be money in fixed income instruments. SIP is done generally in investors whose have idle funds years, but now these funds more if they hold their. Some of the Best Large Funds through online mode in Funds to start with. PARAGRAPHPost deciding on the various have a lock-in for three it helps them to earn Small cap funds. People can transact in Mutual click on "Format," then in credentials of the fund house. Go to the "Menu" bar, such as an online brokerage, place at regular intervals in.Jan 21, A Guide to Investing in Mutual Funds for Beginners Mutual is a practical Guide Excel Level 1 for Beginners in PDF to download for free. The Small Investor: A Beginners Guide to Stocks, Bonds, and Mutual Funds PDF In the event the consumers can transform their PDF files to Excel or Term on. Make a mutual fund tracker excel spreadsheet. is enter the total value of SIP amount invested till date and the current value of it in a seperate.