Trainee Trader

Trainee Trader

Trainee Trader provides articles and tutorials related to Forex, Derivatives, Equities and Futures markets.

Excel's archives

Importing Stock Quotes to Excel using SMF Add-in
Importing Stock Quotes to Excel using SMF Add-in
Written by admin in Tuesday, April 22nd 2008   
In our previous article we used a simple method for importing stock quote data into Excel. Today we will look at a robust automated method for querying more data sources then just Yahoo finance. The Stock Market Functions Add-in for Excel is a free tool developed by by Randy Harmelink. The stock market functions Add-In allows you to import data from sites like Yahoo, Business Week, Reuters, Google, Bloomberg, MSN and many more. In [+]
Microsoft Excel Tutorial Series: The basic’s of charting: Candlestick Charts
Microsoft Excel Tutorial Series: The basic’s of charting: Candlestick Charts
Written by admin in Wednesday, April 9th 2008   
This is part six of our Microsoft Excel Tutorial Series, if you haven't read the previous articles you can find them here: An Introduction to Microsoft Excel 2007 The basic’s data entry and navigation Importing Market Data from Yahoo Finance The basic’s of charting market data the line chart  The basics of charting market data the bar chart Today we will be looking at setting up candlestick charts in Excel. This tutorial will go [+]
Microsoft Excel Tutorial Series: The basic’s of charting: Bar Charts
Microsoft Excel Tutorial Series: The basic’s of charting: Bar Charts
Written by admin in Wednesday, March 19th 2008   
This is part five of our Microsoft Excel Tutorial Series, if you haven't read the previous articles you can find them here: An Introduction to Microsoft Excel 2007 The basic’s data entry and navigation Importing Market Data from Yahoo Finance The basic’s of charting market data the line chart  Today we will be looking at bar charts and the two built in Excel versions of bar charts. Normally a bar chart will display open, [+]
Microsoft Excel Tutorial Series: The basic’s of charting market data
Microsoft Excel Tutorial Series: The basic’s of charting market data
Written by admin in Monday, February 25th 2008   
In the previous article we went through the basics of importing company data from Yahoo Finance. If you are not familiar with Microsoft Excel and have not read the previous article I suggest you read that before continuing. In today's article will be using Microsoft Excel to generate charts using market data from Yahoo Finance. Excel Built-In Chart Types  Excel 2007 does a fairly good job of generating stock charts automatically, given the [+]
Microsoft Excel Tutorial Series: Importing Market Data from Yahoo Finance
Microsoft Excel Tutorial Series: Importing Market Data from Yahoo Finance
Written by admin in Monday, February 11th 2008   
This article is the next article in the Microsoft Excel tutorial series. If you are not familiar with Microsoft Excel or have not read the previous article data entry and navigation I would suggest you read it before continuing. There are many ways in which Yahoo Finance data can be imported into Microsoft Excel, however we will be focusing on the most simple. Yahoo Finance provides a good range of data. Quotes [+]
Microsoft Excel Tutorial Series: The basic’s data entry and navigation
Microsoft Excel Tutorial Series: The basic’s data entry and navigation
Written by admin in Monday, January 7th 2008   
If you have not already read the brief introduction to Excel 2007 I would advise you do so before continuing on with this tutorial series. You may be asking yourself what is the point using Excel as an analysis platform when there are products such as Wealth Lab and TradeStation available. I think that it is important that every trader be able to understand the underlying concepts of the indicators they are using and be [+]

More From Blog

Recently in Excel

Page 1 of 212»