Close
Skip to content

Tutorial 96 | Using the Workbook component to share information with Excel

Getting information from an Excel spreadsheet and posting data in real time

Tutorial 96 workspace and Excel worksheet
Tutorial 96 workspace and Excel worksheet

Welcome to Markplex tutorial 96 in this collection of tutorials designed to help you learn TradeStation EasyLanguage programming skills. Please join our email list if you have not already done so and we will let you know when we release new tutorials or programs.

Tutorial 96 demonstrates how to create an indicator that reads a symbol name from a Microsoft Excel spreadsheet and writes the bid and ask prices in real time back to the spreadsheet. It uses the QuotesProvider component to gain access to updated information from the quotes data stream. This data is written to specific cells in a spreadsheet. NOTE: A more sophisticated version of the program is available for free to Gold Pass members here. If you are a Gold Pass member you will need to be logged in to see the program and the associated explanatory video.

Download

If you want to save yourself some typing, an unprotected version of the tutorial 96 indicator is available immediate download for only $19.95. The program will not work in MultiCharts.

Gold Pass members get an additional 20% discount off all program and tutorial prices. If you are a Gold Pass member make sure you enter the special coupon code to get 20% discount off these prices. You can find the coupon code on the Gold Pass page.

A more sophisticated version of the program is available for free to Gold Pass members here.

Video demonstrating the Workbook Component

Inputs

iFileName1( “C:\Program Files (x86)\TradeStation 9.1\MyWork\Tutorial 96.xlsx” ); // Path and file name of Excel workbook

For the program to work, this must be a valid Excel workbook and the path must be correct. You also need to make sure that you have access to a price feed for the symbol that is entered in the spreadsheet.

If you want to save yourself some typing, an unprotected version of the tutorial 96 indicator is available immediate download for only $19.95. The program will not work in MultiCharts.

Gold Pass members get an additional 20% discount off all program and tutorial prices. If you are a Gold Pass member make sure you enter the special coupon code to get 20% discount off these prices. You can find the coupon code on the Gold Pass page.

A more sophisticated version of the program is available for free to Gold Pass members here.

TO THE BEST OF MARKPLEX CORPORATION’S KNOWLEDGE, ALL OF THE INFORMATION ON THIS PAGE IS CORRECT, AND IT IS PROVIDED IN THE HOPE THAT IT WILL BE USEFUL. HOWEVER, MARKPLEX CORPORATION ASSUMES NO LIABILITY FOR ANY DAMAGES, DIRECT OR OTHERWISE, RESULTING FROM THE USE OF THIS INFORMATION AND/OR PROGRAM(S) DESCRIBED, AND NO WARRANTY IS MADE REGARDING ITS ACCURACY OR COMPLETENESS. USE OF THIS INFORMATION AND/OR PROGRAMS DESCRIBED IS AT YOUR OWN RISK.

ANY EASYLANGUAGE OR POWERLANGUAGE TRADING STRATEGIES, SIGNALS, STUDIES, INDICATORS, SHOWME STUDIES, PAINTBAR STUDIES, PROBABILITYMAP STUDIES, ACTIVITYBAR STUDIES, FUNCTIONS (AND PARTS THEREOF) AND ASSOCIATED TECHNIQUES REFERRED TO, INCLUDED IN OR ATTACHED TO THIS TUTORIAL OR PROGRAM DESCRIPTION ARE EXAMPLES ONLY, AND HAVE BEEN INCLUDED SOLELY FOR EDUCATIONAL PURPOSES. MARKPLEX CORPORATION. DOES NOT RECOMMEND THAT YOU USE ANY SUCH TRADING STRATEGIES, SIGNALS, STUDIES, INDICATORS, SHOWME STUDIES, PAINTBAR STUDIES, PROBABILITYMAP STUDIES, ACTIVITYBAR STUDIES, FUNCTIONS (OR ANY PARTS THEREOF) OR TECHNIQUES. THE USE OF ANY SUCH TRADING STRATEGIES, SIGNALS, STUDIES, INDICATORS, SHOWME STUDIES, PAINTBAR STUDIES, PROBABILITYMAP STUDIES, ACTIVITYBAR STUDIES, FUNCTIONS AND TECHNIQUES DOES NOT GUARANTEE THAT YOU WILL MAKE PROFITS, INCREASE PROFITS, OR MINIMIZE LOSSES.

If you see any errors in this tutorial – or we have not made something clear, we would be most grateful if you could please let us know. E-mail us at: tutorials@markplex.com. Also, let us know if you have any ideas for new tutorials.