Support Board
Date/Time: Sat, 28 Dec 2024 07:45:46 +0000
Post From: SPREADSHEET - Tracking a Cell
| [2015-12-14 16:24:58] |
| bekitz3 - Posts: 83 |
|
Thx tomgilb. Nice website you have there. I downloaded your example to hopefully gain some better insight into how to use the spreadsheets more effectively. The INDEX/MATCH combination is very inefficient in the New Spreadsheets
I definitely noticed a sluggish behavior overall in Sierra after opening this chartbook/spreadsheet combo. And if I'm not mistaken, only 2 columns (K,L) use this particular combination of 'INDEX/MATCH' & that is enough to slow Sierra down significantly. Have you voiced this observation to support? Any feedback (threads, posts, etc)?Without knowing exactly what you are doing, it's difficult to give exact solutions.
I'm basically just trying to profile a trendline and project that trendline value at the current bar. Using your ZigZag example (2m chart), here's a chart where I've drawn a trendline on the 4th & 6th occurrence:http://www.sierrachart.com/image.php?l=1450109718842.png This results in a trendline value of 35.47 at the current bar. Obviously as more bars populate the chart, these 2 anchor points would advance to 5/7, 6/8, 7/9 occurrences, etc. The basic idea is that at any given moment in time, I could choose 2 points, and have the spreadsheet calculate the slope, stay locked to the 2 anchors, and project the value at the current bar. The slope & projection values aren't a big deal for me....it's just keeping locked to the 2 anchors that seems to be challenging. |