> How do you graph stock prices on a google doc?

How do you graph stock prices on a google doc?

Posted at: 2014-12-05 
I want to make a line chart that only shows one line to express stock prices

I'm making good profit with penny stock. Check here http://trade-pennystock.checkhere.info

Many new investors are lured to the appeal of a penny stock due to the low price and potential for rapid growth which may be as high as several hundred percent in a few days. Similarly, severe loss can occur and many penny stocks lose all of their value in the long term. Accordingly, the SEC warns that penny stocks are high risk investments and new investors should be aware of the risks involved but you can even make very big money. These risks include limited liquidity, lack of financial reporting, and fraud. A penny stock is a common stock that trades for less than $5 a share. While penny stocks generally are quoted over-the-counter, such as on the OTC Bulletin Board or in the Pink Sheets, they may also trade on securities exchanges, including foreign securities exchanges. In addition, penny stocks include the securities of certain private companies with no active trading market. Although a penny stock is said to be "thinly traded," share volumes traded daily can be in the hundreds of millions for a sub-penny stock. Legitimate information on penny stock companies can be difficult to find and a stock can be easily manipulated.

Why would you want to do that when it is already done for you at Yahoo Finance or Google Finance or StockCharts.com? Why recreate the wheel and spend your time downloading data so you can then draw a line chart, then update the line chart, then format your line chart and now you've created a maintenance problem. It's out of date tomorrow and you have to do it again, and probably re-scale and reformat, etc. You have no trend lines or moving averages, so back to creating again and keeping more data, and the spreadsheet grows and grows.

When you open an account at any major brokerage firm, or download a free trial of their trading platform, all of that will be done for you, and you can spend your time evaluating the charts (in a line chart or bar chart or whatever format you want at the click of a button), using the charts, in many different time frames, instead of spending your time "maintaining" outdated charts in one single time frame that you created in Excel.

But if you do need a line chart, you need data. You must be specific about what stock you want to chart. You will need a company name and/or ticker symbol.

At the bottom of this screen, click on Download to Spreadsheet to get the historical data for IBM.

http://finance.yahoo.com/q/hp?s=IBM+Hist...

What is it you don't understand about "How do you graph stock prices?" What are you trying to do and why?

I want to make a line chart that only shows one line to express stock prices