Support Board

Date/Time: Sat, 04 May 2024 16:12:16 +0000

Post From: Spreadsheet function help or Create database

[2018-06-14 21:42:54] Link To Thread - Link To Post [Go To First Post]
Rockford - Posts: 3
I am trying to create a simple database on the spreadsheet where values of hourly or daily indicator values (ie. 60 minute RSI or SMI) are pulled and stored on a shorter time frame (ie. every 1 minute). Ive been trying to do it with multiple spreadsheets and referencing the cells from other spreadsheets but since they are different time frames I'm not able to correlate 60min RSi data on a minute by minute basis. Purpose. I am trying to create a spreadsheet function where certain shorter-term indicators are executed only when longer-term indicators are within certain values. For instance 1 or 5 minute RSI crossover happens when a 60 minute and/or daily RSI is at 70. I have successfully created it for the first cell but when it references for only that 60 minutes or that day but the indicators dont stay because the referenced cell changes every 1 or 5 minutes and the Also trying to combine values on Tick or volume data with time values on a spread sheet. Is there any guidance provided on how to create time as a value to be able to round data from a volume or tick chart on a spreadsheet to be able to perform a Vlookup or getcorrespondingmatch function to reference time data?