Forum

Please provide me bedjiaryal@gmail.com

Bunkure sir,

THANK U SO MUCH for your effort on your side..

Download from this link
https://www.dropbox.com/s/zvr0ymebljn48il/PM.xls

nationalply10@yahoo.com please mail to me.

Closing Price bhayeko column ma Max price and vice versa garnus linchha

Bunkure Jee, NEPSE sheet ma bhayeko closing price My PORTFILOR ko VALUE/SHARE ma dekhako xa, kasari ho? Closing price ko sattama Max.Price dekhauna sakxa ki nai?

hello bunkure g send me too this idea in this address- olik.ca@gmail.com,

Thankyou

Thirdeye jee,
If you copy paste properly data of Nepse site in Nepse Sheet it will automatically updates value in portfolio.

Download following this link
https://www.dropbox.com/s/zvr0ymebljn48il/PM.xls

bankure ji,
Could you send me also. My email is: sailung7@yahoo.com
Thank you.

bunkure ji, nepse ko price list kasari daily automatic update hune garaune? aru sabai bujheko chhu.

bunkure ji, nepse ko price list kasari update garne daily? ani portfolio sheetma automatically change huna sakchha?

ki manually price halna parne ho?

One of the friends asked me some question about the sheet, I tried to solve them

1. IPO interest bhane ko k ho? and how it is calculated as here you have used a formula [85000*40/365*Interest Rate]which I couldn't understand.
Answer:
IPO apply garda bhareko purai amount ko interest
850000=my Amount
40=40 days taken to refund amount
2. In ur Portfolio management K2[Interest] means what? and how it is calculated?
Answer:
Share ma lagani bhayeko amount ko interest+IPO ko interest ko pani interest
jasto ki chilime ma maile 12240(30 Kitta) ko share paye tyasko aaja sammako byaj hisab gareko ho tyo column ma
3. What do you mean by Net per unit Inv.?
Answer:
Per Unit investment bhaneko hamile tireko rakam ho bhane
Net per unit investment bhaneko Hamile tireko rakam+Ukta rakam ko byaj
(Share bechda Net Per Unit Investment bhanda badhi ma bechnu paryo ani matra nafa aauchha)


We must consider Interest while calculating profit/loss in share because if we take loan and invest on share then we have to pay interest and if we invest our own money we loose the interest income.

Bunkure gee.. If I need to ask you few question as I want to know ur portfolio management properly. i mean I have few topics that I need to know. If possible can we talk in emails? My email id is sadin_17@yahoo.com.

Copy from here
https://www.dropbox.com/s/zvr0ymebljn48il/PM.xls

Dear sir,
Plz also provide me the portfolio management in excel sheet.
samirhari2020@gmail.com

Dear sir,
Plz also provide me the portfolio management in excel sheet.

Malai pani provide garnu hola; sadin_17@yahoo.com

open nai hudaina ta plz send me @nepboysaroz@gmail.com

OK sir, I got it. Thank you.

Expert friends,
As I have been looking into this forum since I started to invest, I have seen a lot of experts in this forum whose views and calculations have been very useful to the beginners like me so please help me experts. Thanks

Bunkure Jee, FREEZE TOPIC and ORGANIZATION NAME kasari garne ho?

Bunkure Jee,
I can see what you have done is per your requirement and its great. Thanks for sharing your work with everyone.

OK no problem.