Finance in Excel 3 - Determine Your Portfolio Value in Excel Using Live Stock Quotes



Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. Keep track of your Stock Portfolio's value throughout the day using Live Stock Quotes in Excel. This tutorial shows you how to view how much your portfolio is worth at any time during the day as well as the percentage (%) weighting of your stocks in your portfolio. This is a great tutorial to view to learn how to view up to date information for your financial holdings in the stock market as well as how to track the performance of individual stocks and your entire stock portfolio. For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Comments

  1. Hey, i have a question when you multiplied last trade price and shares owned you got dollar value with dollar sign how did you get it. I am from Nepal i did the same as you but i got multiplication error(value) when i tried multiplying last trade price Rs.500 * 20(share units/owned)  i got error(value)  how do i get Rs.500 * 20 = Rs. 10000 . Please share me the formula.....
  2. This is COOL!!! Thanks!
  3. Did you visit drstock.org ?
  4. Hi, great video! Is there an automatic way to record down your portfolio value of each stock 1st day every month so that you can see how your portfolio does each month over the long run?
  5. Excellent presentation! Clear, concise and thoroughly information. Appreciate your work. Hope to see more in terms of portfolio management and analyses. Thanks again!
  6. @clintlutz Did you ever get a response?
  7. hii..thanks..i wonder if we could copy and past the connection then modify it by changing symbol# in it instead of going to each symbol web page to retrieve!!


Additional Information:

Visibility: 43892

Duration: 9m 10s

Rating: 107