Dynamic trend
 

Hi. I am building a spreadsheet for forex trading. I have several
columns with a 200 hour trend calculations, 400, 600, and 1200. Each is
accompanied by many other columns of numbers and formulas. They take up
a lot of space and are inconvenient to scroll back and forth when
analyzing. I am looking for a dynamic way to reference the size I want
to track without creating these different columns every time.
Basically, I wish to analyze the last x number of periods from one cell
that changes the existing formulas. Would be extremely useful. My
market closes are in column G and my formulas are in column X. Any help
would be greatly appreciated.