Support Board

Date/Time: Tue, 07 May 2024 19:39:33 +0000

Post From: Overlay ?

[2015-09-01 05:26:00] Link To Thread - Link To Post [Go To First Post]
User713273 - Posts: 409
1. When I overlay the 1 min chart on to the 5 sec in the spreadsheet. A-G updates the 5 second prices however, I expected the 1 min to give me bar prices are the 55th second of the min. Some reason I get the minute data at the 30th second in the spreadsheet. What do I need to do to line up the 1 min bar with the 5 second bar. 2. When writing custom formula for a Spreadsheet Alert that has the 1 min overlayed on the 5 sec chart. In my custom formula I would like to take 5 sec close and subtract the prev 1 min close. However there are only prices for the 1 min every twelfth row. I know for the first if can use offet by 12 but what about the 11th, 10th etc? thx