Login Page - Create Account

Support Board


Date/Time: Sat, 23 Nov 2024 15:50:02 +0000



Post From: Overlays need frequent recalculate

[2013-07-11 06:24:33]
Crazy_Bull - Posts: 17
teowinner,

I was researching spreadsheet Recalculation and happened to come across this thread.

If you have basic programming skills, you can easily achieve Auto Recalculation at a specified interval using AutoHotkey. I did the same myself in about 15 lines of code. I can supply you the code if you like.

AutoHotkey is a great program for circumventing shortcomings in all applications. For Sierra Charts, I used it to do such things as:

* Automate the removal of deprecated Define Names (#REF!). With thousands of Define Names, this is a MUST!
* Implemented the ability to place the cross-hairs on a bar and then jump to the correspond row in the spreadsheet
* Automatically copy a formula cell to a column or a row of cell formulas to multiple columns

Anyway, you get the idea of the versatility of AutoHotkey.

Hope this helps!

Regards!