Yamato
Legendary member
- Messages
- 9,840
- Likes
- 246
next task, maybe
Lightening up some of the sheets on my workbook might be the next task.
The heavy sheets that can be changed are... is "ON". Yeah, that's the only concern:
At the moment this sheet holds 74 rectangles with as many systems and it is a bit heavy, especially on my home desktop (not on the server, which is much more powerful).
Now if I brought it from 74 to 120, the load would be almost twice as heavy. Of the 16 symbols I am running, I could trade half on one sheet and half on the other. Yeah, let's do it that way.
Or wait, this might be too complex and not tidy.
If we split the futures in two groups on two sheets I could have:
6 currencies and 2 bond futures on one
3 metals, 2 energies, 3 equity indexes on the other.
I don't like to split them, but if I don't, the workbook might freeze from too much work.
But if I split I have to do better than this.
I want something symmetrical and not these two groups.
Ok, I quit on this one.
Simplifying and restructuring might be good, but only to a certain extent can you do it without side effects. You can't change too much stuff at once without losing control of what you're doing and losing sight of all the implications. So this thing will have to wait. A lot of work was done, but this order of things will remain the way it's been until now. I'll take the risk of making my sheet too heavy and will fix things only if it does turn out to be too heavy.
Lightening up some of the sheets on my workbook might be the next task.
The heavy sheets that can be changed are... is "ON". Yeah, that's the only concern:
At the moment this sheet holds 74 rectangles with as many systems and it is a bit heavy, especially on my home desktop (not on the server, which is much more powerful).
Now if I brought it from 74 to 120, the load would be almost twice as heavy. Of the 16 symbols I am running, I could trade half on one sheet and half on the other. Yeah, let's do it that way.
Or wait, this might be too complex and not tidy.
If we split the futures in two groups on two sheets I could have:
6 currencies and 2 bond futures on one
3 metals, 2 energies, 3 equity indexes on the other.
I don't like to split them, but if I don't, the workbook might freeze from too much work.
But if I split I have to do better than this.
I want something symmetrical and not these two groups.
Ok, I quit on this one.
Simplifying and restructuring might be good, but only to a certain extent can you do it without side effects. You can't change too much stuff at once without losing control of what you're doing and losing sight of all the implications. So this thing will have to wait. A lot of work was done, but this order of things will remain the way it's been until now. I'll take the risk of making my sheet too heavy and will fix things only if it does turn out to be too heavy.
Last edited: