Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
Tips Texas hat to all you Sierra Chart users. Not new to trading or spreadsheets, but am to Sierra Charts. If anyone in interested in spreadsheet studies, I would welcome a "howdy." I do e-minis and metals, primarily. Pleased to me you --
Sierra Chart's Worksheet System For Trading and Worksheet System/Alert are chart studies that use MS Excel compatible worksheets to build auto-trading systems and complex alerts, respectively. The purpose of this thread is to share the difficulties …
Some things have changed since then. Sierra abandoned a 3rd party spreadsheet plug-in about 5 years ago and wrote their own.
I did see that thread but didn't see many recent posts. I was wondering if everyone moved to bots in place of spreadsheets. Seem to have similar capabilities. Didn't see ROI on bots if I can do similar in spreadsheets.
As a Wyckoff trained trader, I more of a short-term swing trader that has moved into intraday market in futures. Just learning how to develop scalping set ups (mean reversion).
I'll post to the spreadsheet thread soon and see if we can spur some interest.
Edit, to be clear, the thread " Sierra Chart Spreadsheet trading" is now merged into this prior thread, "Sierra Chart Worksheet System For Trading/Alert Discussions."
FYI, it's always a good idea to check the Search box at the top right of every page before starting a new thread, so you don't create a duplicate that splits the topic.
When one door closes, another opens.
-- Cervantes, Don Quixote
I have a chartbook with the main chart using two other charts, using two study price overlays on the main.
Getting differing results when using Single Chart to replay, and when using All Charts in Playbook, which is understood.
Whats not understood is getting differing results when,
using Single Chart to replay with one of the other charts at one time period, say 5 minute,
using Single Chart to replay the same other chart at a different time period, say 10 minutes.
My understanding is when using Multiple replay, all the charts' data is read back at the same time, not sure what happens otherwise.
Maybe you don't know either, I can ask SC support, but thinking the answer to this is going to be...
if it isn't meant to be used that way...don't use it that way.
Had to ask because was getting good results with that Single Chart replay scenario, and wish to understand it better.
Just not getting why results change when changing bar periods on an overlaying chart, and using Single Chart replay.
I am backtesting a strategy using spreadsheet study for trading and want to evaluate levels of multiple studies upon a trade execution. Curious if its possible to record the value of a study at every trade entry and exit?
The Spreadsheet System for Trading study has no access to historical trade times, only the most recent.
Even if it did, you'd need a Formula Column for each entry and exit, and the max is 60.
There is no way to create a table of entries/exits and their respective study levels.
Single Chart replay has no synchronization with overlaid charts. The source charts do not join in the replay, so the overlaid values would repeatedly be from the source chart's latest bar only, so the results would be completely bogus.
If you change the source chart's bar period, you'll just get different bogus results.