Support Board
Date/Time: Sun, 22 Dec 2024 18:00:03 +0000
Spreadsheet System for Trading not showing trades on chart window
View Count: 1270
| [2015-02-11 13:37:03] |
| User96105 - Posts: 113 |
|
Hi, I've set up a Spreadsheet System for Trading for the first time to do some testing in Sim mode. I can see the False/True Buy/Sell on the spreadsheet (columns K and M), but I'm not seeing the trades on the chart (or arrows/log entries). I have checked Auto Trading Enabled/Recalculated the chart etc, but nothing showing. Can you please point me towards what I might be doing wrong? Thanks. |
| [2015-02-11 13:55:29] |
| Sawtooth - Posts: 4141 |
|
-Are the formulas on the Sheet#/tab position associated with the Chart#? -Are the Draw Styles set to Arrow Up/Arrow Down? |
| [2015-02-11 14:13:33] |
| User96105 - Posts: 113 |
|
Hi, thanks. Yes, the sheet and chart #s are the same. Yes, draw styles are arrow up/down. The formula is using an oscillator which is referencing a study/price overlay from another chart, but I assume this is okay (the oscillator is showing fine in region 2) Cheers |
| [2015-02-11 15:14:36] |
| Sawtooth - Posts: 4141 |
|
-Is the Chart Data Output Sheet Number set to 0 ? -Is the Formula Source Sheet Number set to the same as the Chart#? |
| [2015-02-11 15:24:32] |
| User96105 - Posts: 113 |
|
Yes & yes Thanks |
| [2015-02-11 15:28:30] |
| Sawtooth - Posts: 4141 |
|
You have TRUEs and FALSEs in K3 and M3 but no arrows on the chart?
|
| [2015-02-11 15:48:11] |
| User96105 - Posts: 113 |
|
TRUE (correct)!
|
| [2015-02-11 23:37:22] |
| User96105 - Posts: 113 |
|
I've made some adjustments and now the system is making buy entries, and also shows sell exits in the alert log, but although I'm seeing TRUE in the M and L columns its not making sell entries (and I'm seeing neither sell entries nor buy exits in the log). Any ideas? Thanks |
| [2015-02-12 00:12:09] |
| Sawtooth - Posts: 4141 |
|
Are you using the New Spreadsheets (.scss) ? I have seen some issues with the New Spreadsheets where 'false' in a formula gives spurious results, but 'FALSE' does not. Since 'y' in a cell that's referenced is case-sensitive in the New Spreadsheets, there may be an esoteric problem with certain formula constructions. Unfortunately, I haven't yet confirmed anything repeatable. If there is a TRUE in columns K and M, there should be a corresponding arrow. You might try using another instance with the Old Spreadsheets version, to see if you get different results. Or you could send me your chartbook and spreadsheet file, and I'll take a look. tom@sawtoothtrade.com Date Time Of Last Edit: 2015-02-12 01:09:27
|
| [2015-02-12 02:30:34] |
| |
|
It does not make much sense why you will not see the standard arrows on the chart. So to confirm there are no arrows at all on the chart? You may not see the order fill markers on the chart but that is something else to be concerned with. 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 |
| [2015-02-12 08:14:13] |
| User96105 - Posts: 113 |
|
Thanks Tom ~ new spreadsheet and all caps in the KLMN columns. SC Engineering ~ definitely no arrows on the chart. I can see the order fill markers for the long entries |
| [2015-02-12 18:35:25] |
| User96105 - Posts: 113 |
|
SC Engineering: update for you. I have changed over to the old spreadsheet system (version 1224). Showing .scwbf spreadsheets. Basically everything is the same as previously. The auto-trading system will take long trades, but not short. Also the arrows are not showing. Interestingly if I change the draw style to Bar Top for example then I can see the entries (where the arrows should be). But only for buy entries, not short. So there seems to be two separate things wrong. Is this likely to be an issue with my PC setup? Thanks. |
| [2015-02-13 00:16:43] |
| User29582 - Posts: 33 |
|
I have the same issues with Version 1229. Version 1228 and old version had no problem. It can draw trade Arrow(BUY and SELL) no problem. But once I updated to version 1229(new spreadsheet), all trade Arrow were gone. I have to reverted back to Version 1224. I didn't test Version 1330 or 1331 yet Please fix it ASAP |
| [2015-02-13 03:57:00] |
| |
|
We see no problem with the arrows drawn on the charts from Spreadsheets. It all works properly in the latest version. There may have been a problem with 1229 but that version is not the prerelease any longer. In response to post #12, we will need a Chartbook containing one chart and the spreadsheet you are using so we can look into the problem. Here are the instructions to attach files: https://www.sierrachart.com/index.php?page=PostingInformation.php#AttachFile 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 |
To post a message in this thread, you need to log in with your Sierra Chart account: