Support Board
Date/Time: Wed, 12 Feb 2025 10:06:30 +0000
Post From: Spreadsheet study: Direct A3 result alignment between two sheets
| [2020-10-13 08:34:19] |
| User185210 - Posts: 66 |
|
Hello, I would very much appreciate some help with the following formula in a study spreadsheet There are two charts: #1 "15 min" , #2 "1 tick range", a study spreadsheet and I would like to have the sheet#1 results correctly aligned and computed on each sheet #2 rows. Now I use this formula in the begining of all formulas in sheet#2 but it only works for the last 5 bars... "= IF(A3>=SHEET1!A3,SHEET1!A$3, IF(SHEET1!A4<=A3<SHEET1!A3,SHEET1!A$4, IF(SHEET1!A5<=A3<SHEET1!A4,SHEET1!A$5, IF(SHEET1!A6<=A3<SHEET1!A5,SHEET1!A$6, IF(SHEET1!A7<=A3<SHEET1!A6,SHEET1!A$7, NOVALUE)))))" ...and I would like to have it for an unlimited number of bars! How could that be done? Thanks a lot for any feedback, Cheers,Paul |