Is there a good tool to view a stock portfolio's value as a graph?
Google Finance will do all the bullet points in your list and a few more.  The only drawback is that you have to enter ALL buy and sell manually.  It has an import feature, but it does not work with all trading software. http://www.google.com/finance Let me know if it works.  Also, yahoo.com/finance has a good tool, but I still like better Google's application. I have no idea if Wikivest can handle options, but I've been pretty satisfied with it as a portfolio visualization tool. It links automatically with many brokerage accounts, and has breakdowns by both portfolio and individual investment levels.
I'm mainly interested in scraping market data in order to create screening tools involving stock price technicals, stock fundamentals, derivatives, interest rate data, and futures contracts.  I'm not aware of anyone making a screening tool that can integrate all of these things simultaneously.  What is the best environment to create a tool like this? I am in complete agreement with you.  The place i have found with the sort of charts you are looking for is stockcharts.com.   To compare the percentage increase of several stocks over a period of 2 market-open days or more, which is quite useful to follow the changes in various stocks… etc., an example:  Here the tickers are AA to EEEEE (OTC) and $GOLD / $SILVER for the spot gold / silver price (that isn't really a ticker).  It is set to show the last 6 market days (one week+)...the '6' in '6&O'.  You can change it in the URL above or change it on the site for the stocks you want... up to 25 in one chart but it gets really hard to tell them apart!  By moving the slider just left of the ‘6’ at the bottom right corner of the chart, you can look at 2 days or more.  For a specific time period in days, highlight the ‘6’ and type any number of market-open days you want (21 days = about one month, etc.).  By setting a time period in days, and moving the entire slider, you can see how your stocks did in the last bull/bear run, as an example. The site has a full how-to, for this and the other types of charts they offer. The only problem is that many OTC stocks are not charted. Save the comparison charts you use regularly in a folder in your browser bookmarks.  Blessings.  I see the entire needed link isn't in blue... but you need it all. you could try [FRED](http://research.stlouisfed.org/fred2/graph/?g=HO7), or maybe try the CME and ICE's websites for some decent data.. haven't looked just suggestions - pretty sure the symbol for the Libor futures is EM, you could approximate from that so long as it's not a doctoral thesis Moody's is now Mergent Online. It's no longer being printed, and must be accessed digitally. In order to browse the database, check with your local public library or university to see if you can get access. (A University will probably require you to visit for access).  Another good tool is Value Line Reports. They are printed information sheets on public companies that are updated regularly, and are convenient for browsing and for comparing securities. Again, check your local libraries.  A lot of the public information you may be looking for can be found on Yahoo Finance, for free, from home. Yahoo finance, will give financial information, ratios, news, filings, analysis, all in one place. I'm responsible for all our hedging.  Since we sell the energy to end users we do mostly fixed buys, swaps and calls.  I'm a excel guru and dabble a little in SQL.  we have Crystal Ball as well but i have no idea how to use it.  I guess I'm trying to figure out if there is a tool that people use to help me analyze the spreads. or perhaps some reading material to help me through this. This is what i've been working towards for so long and i really don't want to fuck this up "A Bloomberg terminal connected to Excel provides the value correcting splits, dividends, etc. Problem is it cost around $25,000. Another one which is free and I think that takes care of corporate action is ""quandl.com"". See an example here." I was going to comment above, but I must have 50 reputation to comment. This is a question that vexes me, and I've given it some thought in the past. Morningstar is a good choice for simple, well-organized financial histories.   It has more info available for free than some may realize.  Enter the ticker symbol, and then click either the Financials or the Key Ratios tab, and you will get 5-10 years of some key financial stats.  (A premium subscription is $185 per year, which is not too outrageous.) The American Association of Individual Investors (AAII) provides some good histories, and a screener, for a $29 annual fee. Zacks allows you to chart a metric like EPS going back a long ways, and so you can then click the chart in order to get the specific number.  That is certainly easier than sorting through financial reports from the SEC.  (A message just popped up to say that I'm not allowed to provide more than 2 links, so my contribution to this topic will end here.  You can do a search to find the Zacks website.  I love StackExchange and usually consult it for coding advice.  It just happens to be an odd coincidence that this is my first answer.  I might even have added that aside in a comment, but again, I can't comment as of yet.) It's problem, however, that the universe of free financial information is a graveyard of good resources that no longer exist.  It seems that eventually everyone who provides this information wants to cash in on it.  littleadv, above, says that someone should be paid to organize all this information. However, think that some basic financial information, organized like normal data (and, hey, this is not rocket science, but Excel 101) should be readily available for free.  Maybe this is a project that needs to happen.  With a mission statement of not selling people out later on. The closest thing out there may be Quandl (can't link; do a search), which provides a lot of charts for free, and provides a beautiful and flexible API.  But its core US fundamental data, provided by Sharadar, costs $150 per quarter.  So, not even a basic EPS chart is available there for free. With all of the power that corporations have over our society, I think they could be tabulating this information for us, rather than providing it to us in a data-dumb format that is the equivalent of printing a SQL database as a PDF!  A company that is worth hundreds of billions on the stock market, and it can't be bothered to provide us with a basic Excel chart that summarizes its own historical earnings?  Or, with all that the government does to try to help us understand all of these investments, they cannot simply tabulate some basic financial information for us? This stuff matters a great deal to our lives, and I think that much of it could and should be available, for free, to all of us, rather than mainly to financial professionals and those creating glossy annual reports. So, I disagree that yet another entity needs to be making money off providing the BASIC transparency about something as simple as historical earnings. Thank you for indulging that tangent.  I know that SE prides itself on focused answers.  A wonderful resource that I greatly appreciate. Interactive Brokers provides historical intraday data including Bid, Ask, Last Trade and Volume for the majority of stocks. You can chart the data, download it to Excel or use it in your own application through their API.  EDIT: Compared to other solutions (like FreeStockCharts.com for instance), Interactive Brokers provides not only historic intraday LAST**** trades **but also historic BID and ASK data, which is very useful information if you want to design your own trading system.  I have enclosed a screenshot to the chart parameter window and a link to the API description. I  found that  an application already exists which does virtually everything I want to do with a reasonable interface.  Its called My Personal Index.  It has allowed me  to look at my asset allocation all in one place. I'll have to enter: The features which solve my problems above include:  Note - This is related to an earlier post I made regarding dollar cost averaging and determining rate of returns.   (I finally got off my duff and did something about it) "Check out Professor Damodaran's website: http://pages.stern.nyu.edu/~adamodar/ . Tons of good stuff there to get you started. If you want more depth, he's written what is widely considered the bible on the subject of valuation: ""Investment Valuation"". DCF is very well suited to stock analysis. One doesn't need to know, or forecast the future stock price to use it. In fact, it's the opposite. Business fundamentals are forecasted to estimate the sum total of future cash flows from the company, discounted back to the present. Divide that by shares outstanding, and you have the value of the stock. The key is to remember that DCF calculations are very sensitive to inputs. Be conservative in your estimates of future revenue growth, earnings margins, and capital investment. I usually develop three forecasts: pessimistic, neutral, optimistic. This delivers a range of value instead of a false-precision single number. This may seem odd: I find the DCF invaluable, but for the process, not so much the result. The input sensitivity requires careful work, and while a range of value is useful, the real benefit comes from being required to answer the questions to build the forecast. It provides a framework to analyze a business. You're just trying to properly fill in the boxes, estimate the unguessable. To do so, you pore through the financials. Skimming, reading with a purpose. In the end you come away with a fairly deep understanding of the business, how they make money, why they'll continue to make money, etc." "The graphing tools within Yahoo offer a decent level of adjustment. You can easily choose start and end years, and 2 or more symbols to compare.  I caution you. From Jan 1980 through Dec 2011, the S&P would have grown $1 to $29.02, (See Moneychimp) but, the index went up from 107.94 to 1257.60, growing a dollar to only $11.65. The index, and therefore the charts, do not include dividends. So long term analysis will yield false results if this isn't accounted for.  EDIT  - From the type of question this is, I'd suggest you might be interested in a book titled ""Stock Market Logic."" If memory serves me, it offered up patterns like you suggest, seasonal, relations to Presidential cycle, etc. I don't judge these approaches, I just recall this book exists from seeing it about 20 years back." Hi guys,  This is an app I've been working on over the summer. It's my belief that a lot of people want to learn about the stock market but in the end can't because they're turned off by long walls of text you get when you Google about them/read a textbook.   I know there are other simplified solutions out there but they're not widely adopted yet and I don't think there are any (?) that were made app first.  Anyway, check it out if you can. Appreciate all feedback/comments. Graphs are nothing but a representation of data. Every time a trade is made, a point is plotted on the graph. After points are plotted, they are joined in order to represent the data in a graphical format.  Think about it this way.  1.) Walmart shuts at 12 AM. 2.)Walmart is selling almonds at $10 a pound.  3.) Walmart says that the price is going to reduce to $9 effective tomorrow. 4.) You are inside the store buying almonds at 11:59 PM.  5.) Till you make your way up to the counter, it is already 12:01 AM, so the store is technically shut. 6.) However, they allow you to purchase the almonds since you were already in there.  7.) You purchase the almonds at $9 since the day has changed. 8.) So you have made a trade and it will reflect as a point on the graph. 9.) When those points are joined, the curves on the graph will be created. 10.) The data source is Walmart's system as it reflects the sale to you. ( In your case the NYSE exchange records this trade made). Buying a stock is just like buying almonds. There has to be a buyer. There has to be a seller. There has to be a price to which both agree. As soon as all these conditions are met, and the trade is made, it is reflected on the graph. The only difference between the graphs from 9 AM-4 PM, and 4 PM-9 AM is the time. The trade has happened regardless and NYSE(Or any other stock exchange) has recorded it! The graph is just made from that data. Cheers. The point of that question is to test if the user can connect shares and stock price.  However, that being said yeah, you're right. Probably gives off the impression that it's a bit elementary. I'll look into changing it asap. "To know if a stock is undervalued is not something that can be easily assessed (else, everybody would know which stock is undervalued and everybody will buy it until it reaches its ""true"" value). But there are methods to assess the value of a company, I think that the 3 most known methods are: If the assets of the company were to be sold right now and that all its   debts were to be paid back right now, how much will be left? This   remaining amount would be the fundamental value of your company. That method could work well on real estate company whose value is more or less the buildings that they own minus of much they borrowed to acquire them. It's not really usefull in the case of Facebook, as most of its business is immaterial. I know the value of several companies of the same sector, so if I want   to assess the value of another company of this sector I just have to   compare it to the others. For example, you find out that simiral internet companies are being traded at a price that is 15 times their projected dividends (its called a Price Earning Ratio). Then, if you see that Facebook, all else being equal, is trading at 10 times its projected dividends, you could say that buying it would be at a discount. A company is worth as much as the cash flow that it will give me in   the future If you think that facebook will give some dividends for a certain period of time, then you compute their present value (this means finding how much you should put in a bank account today to have the same amount in the future, this can be done by dividing the amount by some interest rates). So, if you think that holding a share of a Facebook for a long period of time would give you (at present value) 100 and that the share of the Facebook is being traded at 70, then buy it. There is another well known method, a more quantitative one, this is the Capital Asset Pricing Model. I won't go into the details of this one, but its about looking at how a company should be priced relatively to a benchmark of other companies. Also there are a lot's of factor that could affect the price of a company and make it strays away from its fundamental value: crisis, interest rates, regulation, price of oil, bad management, ..... And even by applying the previous methods, the fundemantal value itself will remain speculative and you can never be sure of it. And saying that you are buying at a discount will remain an opinion. After that, to price companies, you are likely to understand financial analysis, corporate finance and a bit of macroeconomy."