Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Thu, 25 Apr 2024 11:42:19 +0000
[User Discussion] - Spreadsheet for Trading
View Count: 482
| [2018-09-18 22:39:12] |
| GiantAvocado - Posts: 67 |
|
I am running a (1) chart that has 4 studies, (2) of these are spreadsheet studies using the same 'Spreadsheet for Trading' (SFT) sheet. I have gotten this setup to somehow take about an hour to load and calculate. Not sure what I have done; but have same issue on two computers and 3 versions of SC (1727,1803,1804); The reason for SFT is I want all my studies and trading on the same sheet. Is there a better way to do this (not use SFT but use spreadsheet study)? I have quite a few calculations going on and the spreadsheet has 40 formulas columns?
|
| [2018-09-19 01:43:08] |
| GiantAvocado - Posts: 67 |
|
I guess what I am looking for is how to best use memory and CPU cycles with single/multiple spreadsheets with a lot of calculations. I am looking at an 'Out of Memory' message on a rig with 16G of memory installed on the same chart. The system with 32G will process, but it takes an hour. Does it make a difference using 'Spreadsheets for Trading' vs 'Spreadsheet Study' for multiple study reference in the same chart? I am using a lot of rows to capture stats (30K); but even 1K rows is taking 20-30M to process; I have had larger sheets than this before with out this issue so kinda confused at this point;
|
| [2018-09-19 16:04:46] |
| GiantAvocado - Posts: 67 |
|
Update; I think I found my problem; I am using Volume by Price for each bar on a two minute chart and that is what is bogging down the performance. I use this a lot in my studies but have not had this problem until this time frame. Unless you see a problem here; I consider this solved and will find an alternative to getting the value of each bar in volume. I set the 'ticks per volume bar' from 1 to 2 and got an enormous improvement in calc time but still not acceptable; I will see what a really need (ticks per vol bar) for this time frame and adjust accordingly.
|
To post a message in this thread, you need to log in with your Sierra Chart account: