InformedTrades
Register as a Member
    Why join? See our testimonials.

Register Front Page See Today's Posts Site
Map
Free Trading
Courses
Shop
Front Page > Forum Central (F1) > David's Corner > Free Trading Courses

 
Thread Tools Search this Thread Display Modes
Old 02-07-2010, 03:06 PM   #1 (permalink)
 
StockJock's Avatar
 
Join Date: Aug 2009
Location: Earth
Posts: 253

Thanks Stats
Thanks (Given): 3
Thanks (Received): 31

Trader's Excel Spreadsheets


I found an assortment of trading related spreadsheets that look interesting. Take a look at Kayline Strategies, L.L.C.

Regards,
StockJock

StockJock is offline   Reply With Quote
 
Thanks Anubhav1703, thanked for this post
Old 03-01-2010, 12:30 PM   #2 (permalink)
 
StockJock's Avatar
 
Join Date: Aug 2009
Location: Earth
Posts: 253

Thanks Stats
Thanks (Given): 3
Thanks (Received): 31

Free Trading & Financial Spreadsheets


I've come across some free trading & financial spreadsheets. One of them shows how to develop an automated trading system in MS Excel and includes the code to make it work. This is for those of you who have some programming background in Visual Basic and Excel macros. The other spreadsheets don't require programming.

Creating an Automated Stock Trading System using Microsoft® Excel®

Free Finance Templates

Free Finance Spreadsheets Scroll to the bottom of this page.

Regards,
StockJock
StockJock is offline   Reply With Quote
 
Thanks thanked for this post
Old 03-01-2010, 04:02 PM   #3 (permalink)
 
trendisyourfriend's Avatar
 
Join Date: Aug 2008
Location: Quebec, Canada
Posts: 1,122

Thanks Stats
Thanks (Given): 0
Thanks (Received): 7

There is a free version or should say an open source version:
Working with Excel (tools, indicators, conversion ...) - Page 2 - Forex-TSD

Also, this is worth checking:
Working with Excel (tools, indicators, conversion ...) - Forex-TSD

The real thing:
TA-Lib Technical Analysis Library - Download

A list of all functions with parameters (you need to register):
Login

This is also worth checking out:
Order technical analysis software add-ins for Microsoft Excel.

forex data converters:
forex data converters - Forex-TSD

Trading spreadsheets for Excel:
Trading Journal Spreadsheet Log > Stock - Forex - Futures - Options

Various goodies in Excel for traders of course:
Index of /Excel

free CVS data export:
http://www.dukascopy.com/swiss/engli...v_data_export/
__________________
Even with a coin weighted towards heads, sometimes it will come up tails.
trendisyourfriend is offline   Reply With Quote
 
Thanks thanked for this post
Old 03-01-2010, 04:05 PM   #4 (permalink)
 
StockJock's Avatar
 
Join Date: Aug 2009
Location: Earth
Posts: 253

Thanks Stats
Thanks (Given): 3
Thanks (Received): 31

trendisyourfriend,

Excellent references. Thank you for your participation.

StockJock
StockJock is offline   Reply With Quote
 
Old 03-02-2010, 08:24 PM   #5 (permalink)
 
StockJock's Avatar
 
Join Date: Aug 2009
Location: Earth
Posts: 253

Thanks Stats
Thanks (Given): 3
Thanks (Received): 31

Spreadsheet to download quotes


There appears to be some free add-on for MS Excel for both Stocks and Forex to download quotes.

TraderXL for TD AMERITRADE

Forex4XL for FOREX.COM

Video Tutorials for these add-ons

Regards,
StockJock
StockJock is offline   Reply With Quote
 
Thanks thanked for this post
Old 03-29-2010, 10:21 AM   #6 (permalink)
 
StockJock's Avatar
 
Join Date: Aug 2009
Location: Earth
Posts: 253

Thanks Stats
Thanks (Given): 3
Thanks (Received): 31

MS Access Stock Quotes


Attached is a rather rare sample database that downloads Yahoo quote data into an MS Access database. I'm posting this for traders who have MS Access programming experience and want to further develop their trading databases. I've seen a lot of postings on MS Access forums requesting for this information and I finally found a sample. This sample is posted on the Google Answers forum by aht-ga, Google Answers Researcher Automatically Importing Stock info from the web into MS Access. aht-ga has given us a good example of how to accomplish this download process that requires using Yahoo Query Language (YQL) to interface with MS Access.

Although this is a good example of how to download to a csv file and then import the data back into Access, a posting by Albert D. Kallal shows how to download quotes directly into Access using many of the available quote properties. However, he does this by one symbol at a time. To make this useful, the code needs to be adapted to cycle through your list of stock symbols like the attached database. His technique also makes use of all the symbol properties for the current symbol status or for historical quotes. Other methods of downloading are shown by Matthew Reeves and Alex Dybenko for the stocks basic properties within a specified date range.

These codes are by no means a complete database, but they are starter modules that work and are meant to provide IT members with MS Access database programming experience and who want to further develop their applications. I am posting this information after doing a considerable amount of research on this topic. There's tons of information on downloading quotes into MS Excel, but almost no help on downloading quotes into MS Access.

If you don't have MS Access, you can still see these samples by using MS Access Runtime. See the video How to Distribute a Microsoft Access Application.
Attached Files
File Type: zip SampleQuoteDatabase.zip (60.7 KB, 2147 views)
File Type: zip SampleQuoteDatabaseVersion2.zip (57.8 KB, 2149 views)
StockJock is offline   Reply With Quote
 
Thanks thanked for this post
Old 01-04-2011, 12:01 PM   #7 (permalink)
 
StockJock's Avatar
 
Join Date: Aug 2009
Location: Earth
Posts: 253

Thanks Stats
Thanks (Given): 3
Thanks (Received): 31

Excel/VBA Automated Trading Platform


Excel/VBA Automated Trading Platform

ATS.xls is a full featured Excel/VBA based automated trading, charting and backtesting solution for trading S&P futures! (Symbol ES, Emini, aka. E-Mini, globex)
__________________
Regards,
StockJock

If you are not using Volume Spread Analysis (VSA), you're just playing Checkers while the Smart Money is playing Chess.
University Of Wyckoff Trading Methodology
StockJock is offline   Reply With Quote
 
Old 01-04-2011, 04:44 PM   #8 (permalink)
Tom
 
Tom's Avatar
 
Join Date: May 2009
Location: USA
Posts: 1,040

Thanks Stats
Thanks (Given): 7
Thanks (Received): 33

Thanks for bumping this up. Good stuff, almost missed it.
Tom is offline   Reply With Quote
 
Old 01-05-2011, 01:54 PM   #9 (permalink)
 
StockJock's Avatar
 
Join Date: Aug 2009
Location: Earth
Posts: 253

Thanks Stats
Thanks (Given): 3
Thanks (Received): 31

Excel - Historical Quotes Downloader


Attached is an Excel 2010 spreadsheet (macro enabled) to download the historical quotes of your selected equities. It saves the data in individual datafiles in csv format. One file for each equity.
Attached Files
File Type: zip Excel Historical Quote Downloader.zip (50.4 KB, 2355 views)
__________________
Regards,
StockJock

If you are not using Volume Spread Analysis (VSA), you're just playing Checkers while the Smart Money is playing Chess.
University Of Wyckoff Trading Methodology
StockJock is offline   Reply With Quote
 
Old 01-05-2011, 02:03 PM   #10 (permalink)
InformedTrades Founder
 
Simit Patel's Avatar
 
Join Date: Mar 2008
Location: informedtrades
Posts: 5,843

Thanks Stats
Thanks (Given): 748
Thanks (Received): 583

Quote:
If you are not using Volume Spread Analysis (VSA), you're just playing Checkers while the Smart Money is playing Chess.
i like your new signature, SJ!

for those unfamiliar, check out magic's great article on volume spread analysis.
Simit Patel is offline   Reply With Quote
 
Reply
Reply
  




Tags
spreadsheet trading

Help InformedTrades grow. Click +1 if you enjoyed this thread.

Register to Comment
Thread Tools Search this Thread
Search this Thread:

Advanced Site Search
Display Modes

Posting Rules
You may not post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 06:16 AM.


Creative Commons License

InformedTrades is dedicated to empowering traders with knowledge. Learn more about our mission statement, and our charity endeavors.

Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.2
vBulletin Optimisation by vB Optimise (Reduced on this page: MySQL 4.11%).
vBCommerce I v2.0.0 Gold ©2010, PixelFX Studios
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios