Excel Journal Formula - Beginners and Introductions | futures.io
futures.io futures trading

Go Back   futures.io

> Futures Trading, News, Charts and Platforms > Traders Hideout > Beginners and Introductions

Excel Journal Formula
Started:April 18th, 2014 (03:45 PM) by Joseph689 Views / Replies:332 / 2
Last Reply:April 18th, 2014 (03:59 PM) Attachments:0

Welcome to futures.io.

Welcome, Guest!

This forum was established to help traders (especially futures traders) by openly sharing indicators, strategies, methods, trading journals and discussing the psychology of trading.

We are fundamentally different than most other trading forums:
  • We work extremely hard to keep things positive on our forums.
  • We do not tolerate rude behavior, trolling, or vendor advertising in posts.
  • We firmly believe in openness and encourage sharing. The holy grail is within you, it is not something tangible you can download.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.

You'll need to register in order to view the content of the threads and start contributing to our community. It's free and simple, and we will never resell your private information.

-- Big Mike

Thread Tools Search this Thread

Excel Journal Formula

Old April 18th, 2014, 03:45 PM   #1 (permalink)
Elite Member
San Jose, Ca
Futures Experience: Beginner
Platform: MetaTrader 4
Broker/Data: Interactive Brokers
Favorite Futures: Forex
Joseph689's Avatar
Posts: 121 since Sep 2012
Thanks: 113 given, 36 received

Excel Journal Formula


Would someone be kind enough to please get me started in a basic Excel trades formula?

I would like to trade 2 contacts; initial plus a trailer.

This is what I would like to do:

A. From a drop down, choose "Long", "Short"

B. Enter "Entry Price" , "Number of Contacts"

C. Enter "1st Exit Price", "2nd Exit Price"

D. Show amount total result, minus commissions

Thanks in advance!


Reply With Quote

Old April 18th, 2014, 03:45 PM   #2 (permalink)
Quick Summary
Quick Summary Post

Quick Summary is created and edited by users like you... Add FAQ's, Links and other Relevant Information by clicking the edit button in the lower right hand corner of this message.


Old April 18th, 2014, 03:59 PM   #3 (permalink)
Site Administrator
Manta, Ecuador
Futures Experience: Advanced
Platform: My own custom solution
Favorite Futures: E-mini ES S&P 500
Big Mike's Avatar
Posts: 45,447 since Jun 2009
Thanks: 28,848 given, 79,603 received



Due to time constraints, please do not PM me if your question can be resolved or answered on the forum.

Need help?
1) Stop changing things. No new indicators, charts, or methods. Be consistent with what is in front of you first.
2) Start a journal and post to it daily with the trades you made to show your strengths and weaknesses.
3) Set goals for yourself to reach daily. Make them about how you trade, not how much money you make.
4) Accept responsibility for your actions. Stop looking elsewhere to explain away poor performance.
5) Where to start as a trader? Watch this webinar and read this thread for hundreds of questions and answers.
Help using the forum? Watch this video to learn general tips on using the site.

If you want
to support our community, become an Elite Member.

Reply With Quote
The following 2 users say Thank You to Big Mike for this post:


futures.io > Futures Trading, News, Charts and Platforms > Traders Hideout > Beginners and Introductions > Excel Journal Formula

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Upcoming Webinars and Events (4:30PM ET unless noted)

NinjaTrader 8: Programming Profitable Trading Edges w/Scott Hodson

Elite only

Anthony Drager: Executing on Intermarket Correlations & Order Flow, Part 2

Elite only

Adam Grimes: Five critically important keys to professional trading

Elite only

Machine Learning Concepts w/FIO member NJAMC

Elite only

MarketDelta Cloud Platform: Announcing new mobile features

Dec 1

NinjaTrader 8: Features and Enhancements

Dec 6

Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula 1 JohnnyAustin Off-Topic 73 April 15th, 2015 07:08 PM
Excel Automating Trading Journal from IB aczk IB Trader Workstation 2 October 21st, 2013 07:38 AM
Sierra Chart Excel Journal drw112 Sierra Chart 4 June 6th, 2013 04:51 PM
BMT Sample trading journal (Excel) Big Mike Trading Journals 1 April 29th, 2012 01:17 AM
Trading Journal example (Excel spreadsheet) Big Mike Psychology and Money Management 20 March 16th, 2012 08:26 PM

All times are GMT -4. The time now is 02:51 AM.

Copyright © 2016 by futures.io. All information is for educational use only and is not investment advice.
There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
no new posts

Page generated 2016-10-28 in 0.08 seconds with 19 queries on phoenix via your IP