Help with Raw Stock Data Collection

  • Thread starter Thread starter cds979
  • Start date Start date
C

cds979

Is it possible to have Excel search through 1 minute raw data and be
able to determine if the price moves between a certain boundary for a
certain time then it will be classified as "Type 1". And if it is
increasing for a certain time then it will be "Type 2" and likewise
for when it is decreasing.

I want Excel to be able to automatically search through the raw data
and determine what is the type of state without myself having to
manually pinpoint it on the chart then going back and doing a manual
search and calculation in Excel. Only issue is that the exact number
determinant will not be stated. There will only be a certain condition
for that type and Excel would have to determine the type sifting
through the raw data numbers based on the conditions stated.

Basically I want a detailed analysis of all price and time
determinants which only can be done with the raw data and not the
chart.

I know that a certain level of VBA knowledge will be required. My VBA
skills are sub-par therefore I do not know how to begin. All I need is
the indication of the right step to take. If anyone could recommend
how it can be done and whether another program would be more efficient
in such data extraction then it would be much appreciated. Thank you
for your help in advance.
 
You could use a macro, or you could use a column of formulas, but for either you need to state your
conditions (the certain boundaries for certain times) more explicitly.

HTH,
Bernie
MS Excel MVP
 
Back
Top