Support Board
Date/Time: Wed, 27 Nov 2024 16:51:17 +0000
[User Discussion] - vegasfoster, crazybears, ACSIL coders: convert spreadsheet studies to ACSIL sudies
View Count: 2252
| [2014-08-13 19:37:48] |
| tobi - Posts: 351 |
|
Dear vegasfoster, crazybears, and other ACSIL coders, I have a few spreadsheet studies that I would like to have converted into ACSIL studies. As mentioned by SC yesterday (Notice: New Sierra Chart Spreadsheet Functionality | Post: 39902), the CLR version, which I've so far been using, will only be kept up to date till the end of 2014. My charts (with these spreadsheet studies) are not (yet) running satisfactorily in the non-CLR version. I would assume that using ACSIL studies are more efficient than spreadsheet studies and of course more userfriendly, so these are the reasons I would like to "convert". The studies are pretty simple and I would think they are not really hard to code in ACSIL. I would really be thankful if anyone could do this for me. I'd pay for it too, if it doesn't get too expensive. Please let me know if you prefer the explanation as chartbook and spreadsheet study or as a written explanation. If you prefer, you can also send me an email to baudendistel5@gmail.com Thanks in advance, tobi Date Time Of Last Edit: 2014-08-15 06:51:22
|
| [2014-08-13 22:45:54] |
| vegasfoster - Posts: 444 |
|
I'm pretty crap actually, I just try to help with coding when I can because the sad reality is no one else does. If you give me the logic, then I can try to convert it, but I make no promises that I can make it go. Generally, ASCIL will be more efficient, depending, but spreadsheets IMO are more user friendly, just because it is much easier to make changes and troubleshoot the logic. I have not yet looked at the new spreadsheets, but I know tomgilb http://sawtoothtrade.com/tag/tomgilb/ could help you convert them if desired. Either way, let me know and I will help you if I can. |
| [2014-08-14 02:02:13] |
| tobi - Posts: 351 |
|
Thank you very much for offering your help vegasfoster! I really appreciate this! I'm not in a real hurry with these, I'm just very glad if I get them converted. So take the time as suitable for you. Attached you will find the 1st study called "Daily Trend Bias". I have added a PDF with the logic and a chartbook with the spreadsheet. If anything is unclear, please let me know. For one of the other indicators I will try to get help from tomgilb to improve my previous spreadsheet calculations, so converting this to ACSIL might also be easier. It would be nice if you could also provide the cpp file. Thanks again for your help, tobi |
 convert_d-tb_01.pdf - Attached On 2014-08-14 01:52:48 UTC - Size: 55.25 KB - 582 views convert_d-tb.cht - Attached On 2014-08-14 01:52:58 UTC - Size: 56.87 KB - 658 views d-tb.scwbf - Attached On 2014-08-14 01:53:03 UTC - Size: 33.03 KB - 551 views |
| [2014-08-14 08:50:15] |
| |
|
My charts (with these spreadsheet studies) are not (yet) running satisfactorily in the non-CLR version. What is the problem you are having? Does the attached Chartbook and spreadsheet file demonstrate the issue. 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 |
| [2014-08-15 23:22:55] |
| tobi - Posts: 351 |
|
What is the problem you are having?
Sorry for the late response. I've been working/testing my charts in the non-CLR version.Does the attached Chartbook and spreadsheet file demonstrate the issue. No, this chartbook/spreadsheet is not showing the issue. In fact, the problems I was having are a lot better by now. Still not sure, if the performance of the non-CLR version is (already) the same or ideally better than the CLR version. For further details, please see my post here: New spreadsheet functionality same performance as the old CLR version? Still looking for converting my spreadsheet studies into ACSIL studies. |
| [2014-08-16 10:43:04] |
| crazybears - Posts: 314 |
|
Hi Tobi thanks for your consideration be careful i'm not an expert only amateur , i tried to code it, seems easy but i found something strange with ema calculation so i need to wait for SC support . later i'll try again . |
| [2014-08-16 20:35:52] |
| tobi - Posts: 351 |
|
No worries crazybears, I'm very thankful for any help to get my spreadsheet studies converted into ACSIL! As SC confirmed, that the performance will be much better using ACSIL than spreadsheet studies, I'm really looking forward to have them converted. |
| [2014-08-16 23:09:38] |
| crazybears - Posts: 314 |
|
Hi Tobi try it it's a draft .compare with spreadsheet from PDF attached , when not specified, this sentence : prior EMA 8 < EMA 20, mean comparison between previous ema 8 and actual ema 20 , right ? |
| Daily_Trend_Bias.cpp - Attached On 2014-08-16 23:09:28 UTC - Size: 5.16 KB - 672 views |
| [2014-08-17 17:08:43] |
| vegasfoster - Posts: 444 |
|
Geez crazybears, I had allocated my whole Sunday to this project, whatever will I do now? ;-) |
| [2014-08-17 20:13:46] |
| crazybears - Posts: 314 |
|
Hi Vegas :-D you are far better than me with code if i stop by vegas ,Dinner is on me |
| [2014-08-17 21:02:04] |
| tobi - Posts: 351 |
|
from PDF attached, when not specified, this sentence: prior EMA 8 < EMA 20, mean comparison between previous ema 8 and actual ema 20, right? No, I had a typo in the PDF in post #3. It should be "prior" for all calculations. I've corrected this and attached the correct PDF here ... just for reference. Will try not to make such silly mistakes in the further postings. Too, I've changed this in the code / cpp file you've created, and adjusted it a little to my needs. It's working perfect, showing the same results as the spreadsheet. So thanks a ton crazybears for converting this first study! I'm very happy :-) For anyone interested, I've attached the final cpp and dll file. |
| convert_d-tb_02.pdf - Attached On 2014-08-17 20:58:10 UTC - Size: 55.75 KB - 496 views d-tb.cpp - Attached On 2014-08-17 20:58:15 UTC - Size: 5.22 KB - 476 views d-tb.dll - Attached On 2014-08-17 20:58:21 UTC - Size: 27 KB - 523 views |
| [2014-08-17 21:05:24] |
| tobi - Posts: 351 |
|
Geez crazybears, I had allocated my whole Sunday to this project, whatever will I do now? No worries guys, there will be more work to do :-)) Will try to send the next study as soon as possible.I'm so happy you're helping me with this! |
| [2014-08-26 19:38:27] |
| tobi - Posts: 351 |
|
Sorry guys it took me so long to get to the next study! I would like to have my "Swing Point" study converted from spreadsheet to ACSIL. Please see the attached PDF (2 pages) for details. If there is anything unclear, pleae let me know. Many thanks again in advance for your help!! Date Time Of Last Edit: 2014-08-27 07:40:20
|
| convert_swing-points_01.pdf - Attached On 2014-08-26 19:37:07 UTC - Size: 72.47 KB - 521 views |
| [2014-08-27 10:43:42] |
| tobi - Posts: 351 |
|
Ok, and here comes the next one. It exists of 5 little sub-studies looking at today's and the past 5 days's volatility. Nothing complicated. If anything is unclear, please let me know. The rest will be easy and small, using the same logic as in studies before and/or little combinations of the studies already created. Thanks so much for your help guys!! |
| convert_d-d5-vol_01.pdf - Attached On 2014-08-27 10:42:16 UTC - Size: 104.02 KB - 684 views convert_d-d5-vol.cht - Attached On 2014-08-27 10:42:24 UTC - Size: 76.54 KB - 544 views d-d5-vol.scwbf - Attached On 2014-08-27 10:42:31 UTC - Size: 6.55 KB - 561 views |
| [2014-08-30 05:37:22] |
| tobi - Posts: 351 |
|
hello guys, don't want to rush anyone, but maybe you can give me a short note if you're still willing to help or any questions have come up. thanks in advance and have a nice weekend, tobi |
| [2014-08-30 12:35:51] |
| User64662 - Posts: 15 |
|
I would appreciate as well with help to learn. I would appreciate some videos to help me get going with ACSIL. Trying to learn A great software. Have a Great Labor Day Weekend! Thanks, Cliff |
| [2014-08-30 22:47:05] |
| crazybears - Posts: 314 |
|
Hi Toby I would be in holiday but in fact I must do many work behind schedule :D I need a little bit of time but perhaps someone will do a surprise ;-) Swing High = at least 2 lower highs to the left and at least 2 lower highs to the right Swing Low = at least 2 higher lows to the left and at least 2 higher lows to the right does it mean the values at right and left of High or Low should be ascendants and descendants ? H(5)<H(4)<H(3)>H(2)>H(1) , conversely for the Low |
| [2014-09-01 12:41:15] |
| tobi - Posts: 351 |
|
Hi Crazybears, sorry for the delayed response and thanks a lot for your ongoing kindness and willingness to help me with this project!! Regarding your question: The values right and left of the high/low don't have to be ascendants and descendants. The rule is not that strict. With H(1) being the current bar's high, the logic/math for a swing high is as followed: H(3)>H(1) and H(3)>H(2) and H(3)>H(4) and H(3)>H(5) I hope this is clear now. I should have attached the example chartbook with the spreadsheet study in the first place. I've done so now. In case you don't already have an idea how to solve the "equal highs/lows" in ACSIL, please have a look at the spreadsheet study in the chartbook or let me know and I'll try to explain Thanks you, tobi Date Time Of Last Edit: 2014-09-01 12:49:51
|
| swing-points.cht - Attached On 2014-09-01 12:46:32 UTC - Size: 29.97 KB - 509 views swing-points.scwbf - Attached On 2014-09-01 12:46:39 UTC - Size: 20.15 KB - 565 views |
| [2014-09-03 09:26:38] |
| crazybears - Posts: 314 |
|
in case of equal H or L , how many bars do you compare on right and left ? i mean , taking your example on chart ,you want to have 2 lower high at left and right respect to the double high? |
| [2014-09-03 10:17:22] |
| tobi - Posts: 351 |
|
Hi Crazybears, not sure if i understand your question correctly. I'll try to explain (for swing highs => swing lows vice versa): First, the code should look for: H(3)>H(1) And H(3)>H(2) And H(3)>H(4) And H(3)>H(5) If this is the case, we do have a (simple) swing high. But in case there is an equal high (H(3)=H(4)) the code has to look one step further left, meaning: If H(3)>H(1) And H(3)>H(2) And H(3)=H(4) And H(3)>H(5) And H(3)>H(6) is the case, then we have a swing high. ... in case there is another equal high (H(3)=H(4) And H(3)=H(5)) the code has to look even one step further left, meaning: If H(3)>H(1) And H(3)>H(2) And H(3)=H(4) And H(3)=H(5) And H(3)>H(6) And H(3)>H(7) is the case, them we have a swing high. ... and so on. Ideally, the code looks so far left, until there is no further equal high to the left (followed by two lower highs). In the spreadsheet study I only look left for max. four equal highs (or the formular would get too long). Have you looked into the spreadsheet study yet? Is the general logic clear? I would assume, that it's easier to build this in ACSIL using some kind of "loop" to look for equal highs!? Hope it is more clear now!? P.S. you only have to look for equal highs left of H(3), because if H(1) and H(2) are not lower than H(3) in the first place, H(3) can not be a swing high point. Date Time Of Last Edit: 2014-09-03 10:28:04
|
| [2014-09-03 10:34:12] |
| crazybears - Posts: 314 |
|
understood , would be something as to set custom input to see how many bars on the left you want to check if there is a equal high or low . on the right side you want 2 bars with a lower high or higher low. |
| [2014-09-03 11:30:50] |
| tobi - Posts: 351 |
|
Ok, nice :-) on the right side you want 2 bars with a lower high or higher low. Exactlywould be something as to set custom input to see how many bars on the left you want to check if there is a equal high or low . If that makes sense (program technically or for performance reasons), then yes. I use these swing points only on the 1 hours chart and it's very rare that there are more than 3-4 equal highs/lows, so a setting of 5 or 8 would sure be enough.If it's easier to program and/or doesn't matter regarding performance, just make the code look so far left until there is no more equal high/low. In that case a custom input would not be necessary. Thanks so much for your help crazybears! |
| [2014-09-07 05:58:42] |
| tobi - Posts: 351 |
|
Hi crazybears, vegasfoster or any other ACSIL coders, just a kind bump, to ask if any further questions have come up. If you are not able to help with this (no time, too complicated, I'm asking for too much or anything else) please let me know. It's not a matter of time, just if this can/will be done. Maybe you can give me a short hint, where things are going, because the conversion of these studies from sreadsheet to ACSIL are pretty important for me. Thank you, tobi |
| [2014-09-12 10:50:33] |
| tobi - Posts: 351 |
|
Hi guys, I'd be thankful for a short note on post #23. My main interest is on the swing point study + two little additions that build upon this study. The studies in post #14 would be nice to have in ACSIL too, but not as important. Thank you, tobi |
To post a message in this thread, you need to log in with your Sierra Chart account: