Microsoft Excel - Setting up Stocks Spreadsheet.

Video quality	The size	Download

Information Microsoft Excel - Setting up Stocks Spreadsheet.

Title	:	Microsoft Excel - Setting up Stocks Spreadsheet.
Lasting	:	9.07
Date of publication	:
Views	:	344 rb

Real nice! thanks
Comment from : An Le

Nice explanation on how to do this in a simple straightforward way without getting too technical brMuch appreciation from Canada Thumbs up
Comment from : Someone else

This has been so helpful, glad I found it, thank you
Comment from : Janene S

Hope u helddamn today price high as f
Comment from : Dirt2Diamonds

Great video (earned a Sub
Comment from : Metamorph

Does anyone have a template of this spreadsheet I can download?
Comment from : Linh

Good stuff, but you go way to fast for someone trying to learn
Comment from : Eddie Mack

This is a brilliant video! thank you so much :)
Comment from : Ben Ellis

Thank you! This is helpful especially for starters like me! :)
Comment from : Carlson 7777

Hi, thanks so much, this really helped Questionmy spreadsheets, probably like most is by fin years, what do you do when you bought shares in one fin year and didn't sell till nexthow do you calculate that?
Comment from : Susan Ryan

10 years later, found this on google bought me here thanks the only thing that is missing for me is the closed date with locked in profits or losses so as to make doing finical year taxes easier any one know a program with such? Thanks
Comment from : Midnight Madness

Thank you SO MUCH !!!
Comment from : DumpzNPumps

Great tutorial Very helpful Thanks!
Comment from : kimhanh

Thank you! this was incredibly helpful!
Comment from : Connor Lee

The total percent gain/loss you have at 57 is not right It should be your total gain/loss divided by your initial cost Otherwise everything is awesome even 10 years later
Comment from : Daxton VanDyke

😲
Comment from : Hemant Yadav

Best I have seen THANK YOU
Comment from : Ted Cheesman

Hi where would I get that file I have 27 pages of trades to do thx Jimm
Comment from : Xmj225 JG

No Amazon in portfolio 10 years back
Comment from : Jeet Paul

With the help of Mr Young you can earn massively weekly Tested and trusted 100 legit contact him on Instagram via @you_ngli or email linyoun56g@gmail com
Comment from : Michael Tega

Is there a way to see your capital gains after you sold a stock?
Comment from : lifein6thgear

Awesome video, As a beginner, I’ve come to realize that experience beats hardwork, I made weak profit investing on my own, but since the past 2months I’ve been investing with the guidance of a professional, i’ve made over $375,000 Profit using a capital of $120,000 , trading is so amazing because i am seen a very big result, am so happy everything has been able to turn around in my favour, i was thinking this whole thing was a scam when i saw lot's of good review about him here on youtube, i would have lost this golden opportunity, and i won't have been able to forgive myself, i was just scared but , am happy i had to take the rist, trust me whn i say Mr Carlton Jefferson is the best broker any trader will ever want as a guide, you can reach out to him directly @ <<<<<>>>
Comment from : Leocadius boźena

Who's Here after almost 10 years - Still helpful btw - In quarantine
Comment from : s70f

Why do you add date you bought?
Comment from : Stephanie Broadwater

When you make the right decisions and take the right steps in stock trading the chances of losing your funds becomes slimmer and almost impossible especially when you invest with the right broker like Mr Douglas Donald
Comment from : Evelyn Lucas

How did you get current value, real time?
Comment from : William Penn jr

Hey friend, you are the only person I have seen that shows how to do the Profit/loss My question is, when I buy stocks or sell, it cost 10 bucks a trade Do you add this into your stock price? And profit or loss?
Comment from : Stephanie Broadwater

THank you
Comment from : MsMotivation

Love this
Comment from : eni L

Bruh this is what leafy been doing ?
Comment from : Young Demimondé

ThanksbrSolve my ProblembrVery good
Comment from : Chandan

Thanks for the instructions!
Comment from : The Warren Buffett Spreadsheet

these prices are so cheap, striker is XOM however
Comment from : Dennis Gray

Where can I download?
Comment from : Robert May

Just learned something new But for others you might want to slow down
Comment from : chas snowden

How would you format if your trading options?
Comment from : James Cabalum

Can it do international like uk stocks or Australia stocks ???
Comment from : Bend Em

Stock/ Forex trading can be very addictive and can become very unhealthy, not just in terms of your performance but also in regard to your physical and mental health – there is no reason to deny thisbrThe point here is this, How bad is your trading addiction really? What is in your power that you can control and change? Do you need any sort of assistance? if you want to learn in depth i highly endorse you study the strategy (Blended model) build by Dmitry bVladislav/b check it on internet A strategy that covers one of the most powerful trading system in present time it's simple to understand and good take profit method
Comment from : Hannah Zagray

can you do video on adding each transaction of multiple stocks with buy and sell position and giving the cost average of the stock that remains in portfolio
Comment from : D Mehta

Much too simplisticno accounting for dividends!
Comment from : ieronimo18

Sorry but if your going to label / set up a spreadsheet wouldn't it be logical to start fro scratch? Plus it looks blurred
Comment from : Jorge luis Ortiz Blas

I cannot thank you enough!!!!
Comment from : Leonel Cortes

What if you purchased additional shares at a different price from the dame corporation?
Comment from : Jam Man

how do I download the spreadsheet from this?
Comment from : Lynne OShea

what about if you sell part of your holding or get dividends? That reduces cost basis and impacts overall P&L
Comment from : jgfunk

what is this 'black magic?
Comment from : RIP

Hope you're still long these stocksexcept for WMT
Comment from : Garrett Baker

Should add a column for annual return For the same return in 1 year vs in 20 years are not the same
Comment from : Brenda

I bought 70 shares into 1 company but at different dates and at different purchase prices How do I figure those different amount into the spreadsheet Do I break them down indivually?
Comment from : Toshiko Dajap

Awesome
Comment from : mehrad Navid

Thanks mate very nice and explained perfectly
Comment from : Hakan Sicakoglu

Thank you
Comment from : Ponte Real

Ive been searching for a simple spreadsheet to track my portfolio for ages and here it it, thanks i added a little more to include dividends but cheers!
Comment from : Gavin Borg

Peace out fam
Comment from : FAST FIX

Good video to start off, but do you have one to continue with closing out positions, and tracking by brokerage, ie stocks with say TD Ameritrade, Fidelity etc I suppose you could just use separate sheets in your Exel spreadsheet I'll subcribe to see if you hove more videos Thanks
Comment from : Laurie Udall

Can someone explain bInitial cost/b mean?
Comment from : md ik

Awesome!!!
Comment from : Inquire98

How do you get the current value in colum G?
Comment from : Snowflake Manor

I don't see a time function that shows years invested +dividends
Comment from : Bob Yoder

thanks for the great vid
Comment from : Andrew Original

In cell J11, this doesn't work to show you the total gain/lost You didn't weight it correctly It should be Current value (H11)/ Initial cost (F11) You have taken an avg of an avg, which is misleading its actually 142 or a 42 increase
Comment from : Tyler Straub

I use MarketXLS for this It really worked well for me
Comment from : Harry Soon

awsome
Comment from : Tino C Bunhu

Wait a minute I'm new to stock trading, so if I sound like I don't know what I'm talking about, it's because I don't So please be patient with mebrbrBut don't you also have to account for the transaction fees for buying and selling the stocks? For example, etradecom charges $9999 per transaction (unless you make 150+ transactions per quarter), so that shaves a flat 20 bucks off your profits, doesn't it?brbrShouldn't you account for that?
Comment from : Sproy