The future stock price is the estimated (future) EPS multiplied by a PE of your choice. 3. This excel sheet will automatically download the data for Nifty50 stocks and indicate Buy/Sell signals. See Chapter 9 for a complete explanation on how to arrive at a PE. 2017 UPDATE: This spreadsheet page has had well over 100,000 visits so I hired a developer to make a Free Trading Journal right here on StockTrader.com. Figure 1: Excel spreadsheet showing data from one trading instrument (McGraw Hill). 2.

An automated excel sheet is created for the same which can be downloaded at the end of this post. In Excel, type “=” and click on the future EPS number, in this case $5.79. How To Create An Automated Trading System In Excel In 10 Steps The benefits of creating an automated trading system are huge. As of April 2019, StockTrader.com readers log well over 10,000 stock trades each month! With a profitable trading robot you can spend more time doing what you enjoy and less time watching screens. In this post, we’ll explore a profitable Intraday Trading system.

2019 UPDATE: Read my guide to the Best Trading Journals for 2019 with tips on how to successfully maintain your journal.

Type *30 (or whatever the PE is that you’ve chosen). How to Calculate Future Stock Price in Excel. 1. A separate sheet in an Excel workbook can be used for each stock.

Also, … Creating Difference Formulas in Excel