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 --

a "Buzz"

aBuzz54 

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 -- a "Buzz"

I use Sierra Chart spreadsheet studies extensively.
Here's a thread I started 10 years ago:

Sierra Chart Worksheet System For Trading/Alert Discussions 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.

Thanks Tom --

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.

Thanks
Al

Maybe BigMike or someone can move this thread over to that one. Thanks.

aBuzz54 

Maybe BigMike or someone can move this thread over to that one. Thanks.

Hey! Someone did.

Bob.

----------------

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.

Cool to see the threads merge...

Multiple chart replay question, Tom

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?

bxman 

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 short answer is No.

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.

You might be able to do it with ACSIL.

Understood thanks for reply

luckcity 

Cool to see the threads merge... Multiple chart replay question, Tom 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.

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.