Support Board
Date/Time: Mon, 25 Nov 2024 01:25:24 +0000
[Programming Help] - Recalculate Spreadsheets
View Count: 1750
| [2018-01-18 16:05:21] |
| User104854 - Posts: 456 |
|
I use a few different spreadsheets for trading but I find that I continually have to refresh them as I get false buy and sell signals at times. It seems that if I hit the recalculate all formulas under the spreadsheet tab it resets them and they get back on track. I have 2 questions: Is there a way to get my spreadsheets to work more efficiently so that I don't have to do this? I only have 150 rows for each one. I've tried to delete the non-formula columns as I don't need them but it doesn't quite work. Can the 'recalculate all formulas' button be added to the control bar commands? I don't see that it's available under the control bar spreadsheet tab. Thank you. |
| [2018-01-18 17:30:48] |
| User104854 - Posts: 456 |
|
More specifically when I'm using the replay function and rewind say a minute or two, my spreadsheets do not refresh. I have to do it manually. I've attached a screenshot of what it looks like. The cells in columns M and N are blank and I have to click on 'recalculate all formulas' to refresh it. It affects everything including buy, sell, exit, and management. Please advise as far as what needs to be done to prevent this from happening.
|
 Spreadsheet.png / V - Attached On 2018-01-18 17:30:37 UTC - Size: 70.2 KB - 343 views |
| [2018-01-18 19:59:24] |
| |
|
This clearly is a study calculation order/dependency problem. Refer to: Chart Studies: Study Calculation Precedence And Related Issues Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2018-01-19 01:16:39] |
| User104854 - Posts: 456 |
|
Ok. I'll dive into it. How about the option to add the recalculate formulas into the control bar? Is that a reasonable request? Thanks.
|
| [2018-01-19 02:00:37] |
| User104854 - Posts: 456 |
|
Something is up. I haven't had this problem before and now every time I rewind the replay I have to refresh EVERY spreadsheet because the calculations are all messed up. Never had this problem before. Did you change something on the latest version? Now it seems as if the spreadsheets are totally useless. I'm pretty sure they weren't intended for the user to have to manually refresh them every 2 minutes. Why are they doing this? I don't think it's the dependency. Please advise.
|
| [2018-01-19 02:39:00] |
| User104854 - Posts: 456 |
|
Alright, I'll get the precedence dialed in as best I can but the instructions are not very clear. You talk about all of these groups. This goes in the general studies group, this goes in the very low precedence group. I don't see anything that shows a list of groups. Is this supposed to mean that I create the group order within the list of studies and how I arrange them? I don't see any studies that say general studies. I do see studies that say standard precedence but that is not listed as one of your options. Since the instructions are not very clear please help me to sort this out. Do I just list all of my studies on the studies to graph list like so: Standard Precedence Studies at the top Low Precedence Studies in the middle Very Low Precedence Studies at the bottom? What about general studies? I don't see anything for that. I need these spreadsheets to work so please let me know how to go about this. If the instructions are unclear for me then they're unclear for most. Thank you. |
| [2018-01-19 18:16:53] |
| User104854 - Posts: 456 |
|
I think I have it figured out with the precedence thing. Sorry about my frustrations. Disregard for now. Thanks.
|
| [2018-01-19 23:37:11] |
| |
|
OK but what we have done today, is we added to the Studies to Graph list the actual calculation order that Sierra Chart is using based on the documented rules, so that this is easier to know what is happening rather than trying to figure it out.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2018-01-20 01:22:32
|
| [2018-01-20 02:17:40] |
| User104854 - Posts: 456 |
|
Ok. Thank you. I'll give it a look. I'm still having issues with the spreadsheet running in sync with a single chart during replay. Sometimes it works and sometimes it doesn't. I've reorganized all of my studies based on precedence. Earlier today it worked great. Now it isn't. I'm using the spreadsheet to enter trades. My Buy Entry formula is a simple "=AND(J$5>0, ID25.sg1>0)" type formula, and when the chart starts replaying I have to manually click on recalculate formulas to get it in sync. If I rewind a few minutes I have to do it all over again. Is there some sort of issue with the spreadsheet during replay? I've tried both standard replay and calculate every tick replay. |
| [2018-01-21 00:42:29] |
| User104854 - Posts: 456 |
|
So I stripped everything down on my entry spreadsheet and made the entries very simple. I'm at the point where I have this wrapped up and it has been working great. But now all of a sudden it isn't working at all. On the spreadsheet it has a '1' under buy entry like it always does but it isn't placing the order to buy. When I look at the trade service log there is no mention of any buy order or why it was ignored. Nothing. What could be the problem and how can I check to see what it is???
|
| [2018-01-21 00:58:30] |
| User104854 - Posts: 456 |
|
It's fixed. I unchecked 'enabled' on the alerts tab. Had no idea this disables the entire study. Just thought it turned off audio alerts.
|
| [2018-01-21 02:08:12] |
| |
|
It's fixed. I unchecked 'enabled' on the alerts tab. Had no idea this disables the entire study. OK we see this is the case. We will solve that. This probably explains some of these unsolvable problems that that some users have with the Spreadsheet System for Trading study not submitting any order actions that our documentation on the subject does not answer.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2018-01-21 02:08:40
|
| [2024-04-14 18:23:44] |
| User970210 - Posts: 84 |
|
finally I figured out why spreadsheet partially graphed and/or graph constant changing during replay or backtesting. I need to recalculate all formula for all charts spreadsheet to solve partially graph and reload/recalculate chart wont work. Also I need to refer a bar HLC at close so the graph will not constant update or using intra bar HLC. Is there any easy ways to recalculate spreadsheet formula automatically? |
| [2024-04-14 18:52:26] |
| User970210 - Posts: 84 |
|
where can I find Studies to Graph?
|
| [2024-04-15 16:38:54] |
| John - SC Support - Posts: 36238 |
|
Is there any easy ways to recalculate spreadsheet formula automatically?
We are not understanding this question. To start with, are you referring to the "Spreadsheet Formula" study, or just a formula within a Spreadsheet? And in general, for either case, the formulas are automatically calculated, so there is nothing you need to do. We are not sure what exactly is the issue you are trying to describe. where can I find Studies to Graph?
Analysis >> Studies The "Studies to Graph" are the items on the right side. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: