:: Subscribe to our newsletter
 
Articles / Directory
06/17/2013
Latest version of TraderCode(v5.6) includes new Technical Analysis indicators, Point-and-Figure Charting and Strategy Backtesting.



06/17/2013
Latest version of NeuralCode(v1.3) for
Neural Networks Trading.



06/17/2013
ConnectCode Barcode Font Pack - enables barcodes in office applications and includes an add-in for Excel that supports mass generation of barcodes.



06/17/2013
InvestmentCode, a comprehensive suite of
Financial calculators and models for Excel is now available.



09/01/2009
Launch of
Free Investment and Financial Calculator for Excel.



02/1/2008
Release of
SparkCode Professional - add-in for creating Dashboards in Excel with sparklines



12/15/2007
Announcing
ConnectCode Duplicate Remover - a powerful add-in for finding and removing duplicates entries in Excel



09/08/2007
Launch of
TinyGraphs - open source add-in for creating sparklines and tiny charts in Excel.


Download Stock Trading Prices

Launch Microsoft Excel and create a new workbook. You may call your workbook DownloadData.xls. We are going to provide the information to Excel where to download the stock information.

Excel 2003: Click on Data->Import External Data->New Web Query
Excel 2007: Click on Data->From Web

A Mini Browser will appear. Browse to http://finance.yahoo.com. On the top left hand corner, it allows you to Get Quotes. Enter “YHOO” for the stock price of Yahoo. A summary of the Stock price for Yahoo will appear. Click on the “Historical Prices”

Alternatively, once you are comfortable, the next time you can just simply enter full URL, appended with the Stock Code as follows http://finance.yahoo.com/q/hp?s=YHOO

On the web page you will be able to select download prices based on the following frequency

· Daily
· Weekly
· Monthly
· Dividends Only

You can leave the defaults and click on the Get Prices.



Click on the 3rd Yellow Arrow to turn it into a check mark, and then click the Import button. The “Import Data” dialog will appear, you can click on the Properties button on this dialog to alter the import properties.



Click the OK button to close the dialog and you will see the following in Excel. The actual data might be different from the screen shown below as you will be importing the latest data. The following is captured during the 2nd of September 2008.



Instead of downloading the data through the steps above, an alternative is to launch your browser and navigate to http://finance.yahoo.com/q/hp?s=YHOO. Click on the link as shown below “Download To Spreadsheet” to download the entire data to Excel.

You can also sort the data to display the latest stock prices on top or at the bottom of the spreadsheet.

Excel 2003: Click on Data->Sort to sort by the Column “Date” with the data in “Ascending” order.

Excel 2007: Click on Data->Sort and specify the options as shown below to sort the data from “Oldest to Newest”.

Back to Automated Stock Trading Main Page


 

Copyright (c) 2007-2015, ConnectCode Pte Ltd. All Rights Reserved.


Trademark Acknowledgements

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. Avery is the trademark of Avery Dennison Corporation. All other product names are trademarks, registered trademarks, or service marks of their respective owners