Support Board

Date/Time: Thu, 02 May 2024 02:33:59 +0000

Post From: Overlays need frequent recalculate

[2013-07-11 06:24:33] Link To Thread - Link To Post [Go To First Post]
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!