Login Page - Create Account

Support Board


Date/Time: Wed, 17 Oct 2018 15:16:15 +0000



Post From: References Between Spreadsheets

[2013-06-06 11:15:32]
Trader_TD - Posts: 1
"really there should be an alternative way for you to accomplish what you want by putting all of the data into a single spreadsheet window just using the available Sheets."

Actually, the way I use the SS, there is no way to do this.

I'm not currently a direct subscriber to SC, but over the last three years I have subscribed to either package 3 or 5 more time than I have not, so I hope you'll consider my input. Currently I am only trading futures on Transact and find their package adequate for now, but have always expected to re-subscribe for the Forex feed at some point (like others I find the FXCM pip spreads to be ridiculous at this point, but that's another topic).

Removing this particular SS capability may keep me from re-subscribing. I find the ability to create what I call a "Master Spreadsheet" that displays data from numerous other SS's in different chartbooks one of the core capabilities that I haven't seen in any other package.

I like to trade using certain confluences of timeframe and indicator data the gives me a basis to know which currencies or futures are worth looking at for a possible trade. For example: Is the current price above or below the Daily Pivot? Has the Average Daily Range been met? What are the trends on several timeframes?

To do this I set up a chartbook for each currency with a spreadsheet for each chartbook, and use SS formulas to display conditions like "ADR Not Reached", "Trend is Up", "Above the Pivot", "Today's Range", etc. I will then create a final sheet, not connected to a chart, that copies the final output from each individual chart into a readable table, or "dashboard". Final logic on this sheet may then read something like: "Look for a Long Entry", or "No Trade Setup".

I then create a "Master Spreadsheet" that is NOT connected to any chart or chartbook. Each currency gets row/columns that displays a summary from its source as well as additional logic that tells me whether I want to consider looking for a trade in that currency. All final summaries are displayed on this sheet, and I can bring it up regardless of which chartbook I'm looking at. Everything is color coded as well, i.e Green if Bullish, Red if Bearish.

The result is that, at a glance, I can tell which currencies I may want to trade, as well as those I don't. Takes a lot of work to set up, but once done, saves massive amounts of time. I no longer have to scan several charts on every currency just to get started. And if the conditions change, there they are in real-time.

And I accomplished all this without programming. Just SS language, much of which I knew already and built upon.

Needless to say, losing this capability would be a huge negative in my book, not an improvement. I hope you'll reconsider. I don't consider "not upgrading" to be much of an option as it would only be temporary - eventually there would be something that would require it, no doubt.

Perhaps this is not what you intended the SSs to be used for, but that's the thing about tools - they tend not to have just a single use.

Any way, thats my input.

Regardless of the direction you go, thank you for soliciting feedback.