Home >> Support Board

Support Board

Date/Time: Wed, 24 Apr 2024 18:54:05 +0000

How to Post a Message for Support

Spreadsheet function help or Create database

View Count: 1135

[2018-06-14 21:42:54] #1 [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?

[2018-07-18 21:42:38] #2 [Go To First Post]
bradh - Posts: 854
Have you tried the Study/Price Overlay Study? It takes studies from one chart with its own time frame, and overlays them onto another chart. Your spreadsheet will pick up the values, and they will be repeated as needed. (Each hourly value will show up for each of the 60 minutes.)

To post a message in this thread, you need to log in with your Sierra Chart account: