NexusFi: Find Your Edge


Home Menu

 





Sierra Chart Excel Journal


Discussion in Sierra Chart

Updated
      Top Posters
    1. looks_one Chrismind with 2 posts (0 thanks)
    2. looks_two Superdoug3 with 2 posts (0 thanks)
    3. looks_3 swandro with 1 posts (18 thanks)
    4. looks_4 bradhouser with 1 posts (1 thanks)
    1. trending_up 7,246 views
    2. thumb_up 26 thanks given
    3. group 8 followers
    1. forum 6 posts
    2. attach_file 1 attachments




 
Search this Thread

Sierra Chart Excel Journal

  #1 (permalink)
 drw112 
Chicago IL
 
Experience: Beginner
Platform: Sierra Chart
Trading: Futures
Posts: 117 since Feb 2012
Thanks Given: 22
Thanks Received: 120

I created an Excel Journal for Sierra that can accept trades exported from the Trade Activity Log. It'll give you Cum P&L, Pts Per day, Expectancy, Win%, Long v Short P&L, P&L By Entry Hour, P&L By Day of Week, Avg Win and Loss Size in Pts. I have it populated with some old Sim trades so you can see how it looks.

https://db.tt/Y4IlLcWk

Visit my NexusFi Trade Journal Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Deepmoney LLM
Elite Quantitative GenAI/LLM
Exit Strategy
NinjaTrader
Build trailing stop for micro index(s)
Psychology and Money Management
Better Renko Gaps
The Elite Circle
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
59 thanks
Funded Trader platforms
37 thanks
NexusFi site changelog and issues/problem reporting
23 thanks
GFIs1 1 DAX trade per day journal
22 thanks
The Program
19 thanks
  #2 (permalink)
 
Chrismind's Avatar
 Chrismind 
Houston, TX/USA
 
Experience: Beginner
Platform: Sierra Chart
Broker: Sierra Charts Data Feed
Trading: Futures
Posts: 68 since May 2013
Thanks Given: 40
Thanks Received: 101

drw,
Hello. Do you still have this spreadsheet journal available? The link doesn't work.

Or does anyone have something similar?

Thanks

Reply With Quote
  #3 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,399 since Jun 2009
Thanks Given: 33,174
Thanks Received: 101,539


If you find it, please attach it to the forum so this doesn't happen again.

Mike

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
  #4 (permalink)
 swandro 
England
 
Experience: Advanced
Platform: SierraChart
Posts: 70 since Jul 2009
Thanks Given: 9
Thanks Received: 80


Chrismind View Post
drw,
Hello. Do you still have this spreadsheet journal available? The link doesn't work.

Or does anyone have something similar?

Thanks

I am not the thread starter but I did download the file and as he has not yet responded I thought I would upload it myself.

Attached Files
Elite Membership required to download: SC_Journal.xlsx
Reply With Quote
  #5 (permalink)
 
Chrismind's Avatar
 Chrismind 
Houston, TX/USA
 
Experience: Beginner
Platform: Sierra Chart
Broker: Sierra Charts Data Feed
Trading: Futures
Posts: 68 since May 2013
Thanks Given: 40
Thanks Received: 101

Thank you swandro!

Reply With Quote
  #6 (permalink)
 fxpro312 
Long Beach, California/ USA
 
Experience: Advanced
Platform: Sierra Chart
Broker: IB, IQFeed
Trading: ES, NQ, CL, ZN, GBP, JPY
Posts: 10 since Nov 2015
Thanks Given: 4
Thanks Received: 4

I am on Office 365 and the most recent excel.

I cannot upload to this file from SC to save my life. I am exporting from trade log and saving as csv and trying to cut and paste in the data section of the journal. Doesnt line up or even come close to what the example is showing. I tried importing from excel from the file saved and still comes out all jumbled.

I know this is an old thread, but just seeing if anyone can give me a tip on importing trades from SC into this fine spreadsheet.

Cheers

Visit my NexusFi Trade Journal Reply With Quote
  #7 (permalink)
bradhouser
Northern California where the girls are warm
 
Posts: 122 since Nov 2010
Thanks Given: 15
Thanks Received: 72


fxpro312 View Post
I am on Office 365 and the most recent excel.

I cannot upload to this file from SC to save my life. I am exporting from trade log and saving as csv and trying to cut and paste in the data section of the journal. Doesnt line up or even come close to what the example is showing. I tried importing from excel from the file saved and still comes out all jumbled.

I know this is an old thread, but just seeing if anyone can give me a tip on importing trades from SC into this fine spreadsheet.

Cheers

After you save the CSV file, open it in Excel, Using the Delimited option, with Tabs as the delimiter. Select columns A through U and copy/paste into cell N1 of SC_Journal.xls. To make the date/time formats match, select columns P and Q and right click >Format Cells...choose custom and then m/d/yyyy h:mm and add ":ss" to it so it looks like "m/d/yyyy h:mm:ss" then click OK.

Reply With Quote
Thanked by:




Last Updated on January 22, 2017


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
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.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts