KX Community

Find answers, ask questions, and connect with our KX Community around the world.
KX Community Guidelines

Home Forums KX Solutions Putting CSV data into a chart & other questions Re: Putting CSV data into a chart & other questions

  • biggorilla

    Member
    April 17, 2022 at 12:00 am

    I’ve found a nice way to plot the data using a scatter chart. Cool!

    Here’s my current situation. I have a technical indicator which I suspect could be predictive of price. I would like to take the output of the indicator and measure the relationship it has with future price. Right now I have the immediate relationship, that is, the values of both at the same point in time. I want to be able to compare the indicator with future price, but test a large number of durations between the indicator output and the price. For example, from 1 period to 500 periods. So, i’ll use notation i’m familiar with where square brackets indicate historic periods:

    the relationship (correlations or whatever) between indicator[0] and close[til 500]

    I want to determine which close period in the future has the highest correlation with the indicator output from a set time, and then run this test as many times as possible over each series/set. What would be some good ways to collect this data? Is there a way to visualize it? Anything info or suggestions in this area is appreciated. Thanks!

    I hope that makes sense!