Have you ever wondered how to compare your portfolio return against nifty on daily basis.
We often come across comparison where fund houses luring investors with their return comparing against Nifty or other benchmark index.
such comparison on one hand give an insight on how well one portfolio is doing against benchmark and on the other hand give an opportunity to challenge your limit to push for higher return.
I have created one such tool on EXCEL which you can use to create your own NAV Calculator.
Let me explain how to use the same.........
Date: Put the date on which values are being recorded
Nifty: Put nifty level as of the corresponding date
MCap: Market Capitalization
Column with name ending MCap is current value of your portfolio. One need to record on regular interval. It is not mandatory to record the details on daily basis but it is recommended for better result.
Cap: Capital Employed
Column with name ending Cap is total investment. Not current value.
DIV: Dividend received
Two set has been provided for two different portfolio if you want to use.
After putting all the values one need to draw the chart, you can drag the selection to capture current value and you are done.
Note: Will explain in new post, how it has been calculated. Also, this tracker is may not fulfilling all the criteria of Index management.
Link
We often come across comparison where fund houses luring investors with their return comparing against Nifty or other benchmark index.
such comparison on one hand give an insight on how well one portfolio is doing against benchmark and on the other hand give an opportunity to challenge your limit to push for higher return.
I have created one such tool on EXCEL which you can use to create your own NAV Calculator.
Let me explain how to use the same.........
Date: Put the date on which values are being recorded
Nifty: Put nifty level as of the corresponding date
MCap: Market Capitalization
Column with name ending MCap is current value of your portfolio. One need to record on regular interval. It is not mandatory to record the details on daily basis but it is recommended for better result.
Cap: Capital Employed
Column with name ending Cap is total investment. Not current value.
DIV: Dividend received
Two set has been provided for two different portfolio if you want to use.
After putting all the values one need to draw the chart, you can drag the selection to capture current value and you are done.
Note: Will explain in new post, how it has been calculated. Also, this tracker is may not fulfilling all the criteria of Index management.
Link

• Capital First-Warburg Pincus sells 25 percent in Capital First, GIC Singapore ups stake to 14 percent'.
ReplyDelete• PVR realty firm Elan to invest Rs 550 crore and tie up with PVR.
• Reliance Infrastructure’s subsidiary files Section 9 petition in the Delhi High Court for urgent payment of Arbitration Award
CapitalStars
louis vuitton
ReplyDeleteswarovski jewelry
louis vuitton handbags
ferragamo shoes
fitflops
michael kors outlet
adidas wings shoes
ralph lauren outlet
michael kors outlet online
pandora charms sale clearance
qqqqqing20170520
Jackson has a couple of particular styles of guitars. As formerly referred to, a Randy Rhoads character was written in team-work with Rhoads as longines dolce vita replica well as had an absurd physique. Other models embody a Warrior, a Kelly( identical to a Gibson Explorer, though a small some-more slim), a King V, as well as a Kelly Star.
ReplyDeleteThe electric automobile has eventually been delivered to a open, as well as a formula have been overwhelmingly certain to illustrate distant. There is a lot upon a list appropriate appropriate away as EVs have been alien to a marketplace. For example, will EVs be some-more environmentally tolerable than variety? Will they be some-more economically applicable for drivers? These have been questions that still breakwater t perceived answers, though you design advisers will be means to acquisition a answers in a entrance years. In a concurrently, Tinley Park Chevrolet dealers have been saying outrageous seductiveness in their brand new swath of Volts, a electric automobile staid to shift a approach drivers demeanour during a automobile attention perpetually. As well as a allowances of pushing movado se extreme replica a Volt will be heavily scored equally to a taking flight cost of gas; with all of a misunderstanding in a center easterly, America is you do a most appropriate to soothe itself of a faith upon oil as well as about-face to some-more tolerable forms of appetite -- a pierce that might disintegrate a little oil magnates though will have an overwhelmingly certain stroke upon a internal manage to buy. Lansing, IL used automobile drivers might suffer their cars appropriate appropriate away, though a destiny binds improved things for a pushing attention, most of that you ll see actuality in a subsequent multiform months.
replica watches
replica longines
watches longines
longines evidenza replica
longines spirit replica
longines heritage replica
longines dolce vita replica
longines conquest replica
longines la grande classique replica
longines elegant replica
longines flagship replica
longines lyre replica
longines saint imierref replica
salomon boots
ReplyDeletenike store
air max outlet
jerseys cheap
kate spade bags
christian louboutin
moncler outlet online
adidas nmd r1
adidas yeezy boost 350
pandora charms sale clearance
xushengda0704
adidas nmd
ReplyDeletecheap jordans
michael kors
cheap jordans
nike football boots
yeezy boost 350
yeezy boost 350 v2
adidas yeezy
fitflops
longchamp outlet
ONGC, Vedanta, BPCL, Tata Steel, Hindalco are among the gainers, whereas Infosys, Cipla, Asian Paints, Sun Pharma and Zee Entertainment are losing sheen on NSE.capitalstars
ReplyDeleteSun Pharma rallied nearly 4 percent, followed by Dr Reddy's Labs, Lupin, Reliance Industries, Tata Motors, GAIL and Aurobindo Pharm.
ReplyDeleteEquity Tips
These calculators may include multifunction buttons for a smaller, full featured tool. They are able to calculate root values, with separate buttons for square, cube, and any root. They also have trigonometric, logarithmic and exponential function keys.guarantor loans
ReplyDeleteBy investing in mutual funds, you could diversify your portfolio across a large number of securities so as to minimise risk.
ReplyDeleteBest Advisory Company
Excellent article. Very interesting to read. I really love to read such a nice article. Thanks! keep rocking. Looking forward for more posts from You!
ReplyDeleteForex Tips
It such a cute photos and so nice. babies are imitated each other which is so adorable.
ReplyDeleteConference System on Hire in Delhi
DSLR Camera on Rent
Its quite different blog from others. This is so interesting and nice lines.
ReplyDeleteProjector on hire in delhi
Laptop on rent in delhi
I'm planar by your table make up the superior production.
ReplyDeletelaminator
Very nice post about
ReplyDeletePremium Cash Plan
ugg outlet
ReplyDeletecheap oakley sunglasses
ralph lauren polo
mulberry outlet
christian louboutin shoes
gucci outlet store
mbt shoes clearance outlet
michael kors outlet clearance
michael kors outlet
pandora bracelet
shenyuhang20180418
Hindalco, Nalco slip 9% as US softens stance on aluminium producer Rusal
ReplyDeleteMarket Risk Solutions
ugg boots
ReplyDeletecanada goose outlet
cheap jerseys wholesale
pandora charms
mlb jerseys wholesale
polo ralph lauren
true religion outlet
cheap ray ban sunglasses
coach outlet online
kate spade sale
yaoxuemei20180505
ICICI Bank stock rallies 6.5% post Q4FY18 numbers
ReplyDeleteintraday Stock Tips
nike free run
ReplyDeletenike outlet
louboutin
swarovski
michael kors outlet online
ray ban
adidas outlet
mulberry outlet
england world cup jersey
oakley vault
2018.6.15chenlixiang
If you have no destination , you''ll never get there.
ReplyDeletefinancial advisory company
helpful blog.
ReplyDeleteNot all storms come to disrupt your life, some come to clear your path.
financial advisory company
Well explained about Nifti and related terminology. Need more articles like this.
ReplyDeletenike air max
ReplyDeletenike cortez
nike huarache
nfl jerseys
outlet golden goose
red bottom shoes
adidas nmd r1
nike air max 2019
nike epic react flyknit
adidas tubular x
golden goose
ReplyDeletegolden goose sneakers
supreme t shirt
golden goose outlet
supreme outlet
goyard
golden goose
yeezy
moncler jackets
adidas yeezy
balenciaga shoes
ReplyDeletekyrie 3
retro jordans
hermes belts for men
yeezy supply
coach factory outlet
yeezy 500
jordan 13
fila shoes
off white clothing
قلعه بابک تبریز
ReplyDeleteSlot Machine Gaming at SlotsMate | Dr. Dr.MCD
ReplyDeleteFind out what Slot Machine Gaming at SlotsMate 진주 출장샵 is all about and why you 서울특별 출장마사지 should play. The 천안 출장샵 game is played with a fixed number 충청북도 출장마사지 of symbols 강릉 출장샵 and you can find
try this web-site blog find out check here Check Out Your URL from this source
ReplyDelete