Tracking investment portfolio with Msft Excel?

I hold several investments, for short periods of time (1 month max). What is the best way to keep track of all these transactions in Microsoft Excel so I can accurately measure my return.

I you need streaming quotes in Excel to track your portfolio use
http://www.quotelink.net/, its excellent and you can use many feeds (either for free, delayed, or using your broker).

Why use Excel? Yahoo Finance has a tab to track your portfolio with streaming quotes.

You can also create a portfolio of your stocks at http://www.Top10Traders.com - this is a free site that lets you create a portfolio of stocks with $100,000 in "play" money. Each day the site ranks the best performing portfolios, so you can see how your picks perform compared to other investors. You can also read posts on investing from the best traders, as well as share your own investing ideas. There is also a charting feature , so you can see how your portfolio performs compared to the S&P 500.

Here are this month's best traders:

http://www.top10traders.com/Top10Standin...

Hope this helps.

Tags

　　Investment Fund 　　Investment Trading 　　Investment Strategy 　　Investment Services 　　Investment Portfolio 　　Investment Plan 　　Investment Performance 　　Investment Options 　　Investment Opportunity

Related information

How do i calculate the risk in my investment portfolio?

Before you go freaking out about this. I recommend a good financial advisor. Because if you don't have any risk or low risk you may as well not have a portfolio. The number one thing I've...

How do i set up investment portfolio for my retirement?

Investor's best friend, at least for me, is the Motley Fool. www.fool.com

...

How do I make an investment portfolio?

Go to your bank, whom you deal with, and set up an appointment. They can discuss your options. How old you are, how much you have to invest, what your goals are and so on. Good luck.

...

Would you consider including ETFs in your investment portfolio?

I like ETFs because some of them target very specific market sectors ignored by mutual funds. Also, there is no minimum purchase, and the fees are usually lower than an equivalent mutual fund.

...

The format of my investment portfolio has been changed, colors, spacing, why are you doing this!?

Dear Friend, To brighten your day! Your Friend, Francesois

...

Can you actually (easily?) quantify the value added to an investment portfolio by diversifying it?

There is no value added by diversification (all things being equal). You are trying to reduce your risk.

...

Is there a free software to analyze in investment portfolio in terms of risk, etc?

There's a website that determines risk of a portfolio. Its free, you just have to register. www.riskgrades.com

...

I setup the new format for emaiing my investment portfolio but no email.?

Hi, i know what your question means. i also think stock market is a nice place for investing. I found some useful tips in stock trading. It includes stock basics, how to protect your profit, fin...