Indicator for stock data.

[marquez313]

Hi everyone!

I'm working with intraday stock data and want to add a simple indicator to what I already have.

<table border="0" cellpadding="0" cellspacing="0" width="141"><col style="mso-width-source:userset;mso-width-alt:1718; width:35pt" span="3" width="47"> <tbody><tr style="mso-height-source:userset;height:16.5pt" height="22"> <td class="xl64" style="height:16.5pt;width:35pt" height="22" width="47">SPY</td> <td class="xl65" style="width:35pt" width="47">65.66</td> <td class="xl66" style="width:35pt" align="right" width="47">115.18</td> </tr> <tr style="mso-height-source:userset;height:16.5pt" height="22"> <td class="xl67" style="height:16.5pt" height="22">VXX</td> <td class="xl68">61.54</td> <td class="xl69" align="right">32.75</td> </tr> <tr style="mso-height-source:userset;height:16.5pt" height="22"> <td class="xl64" style="height:16.5pt" height="22">TLT</td> <td class="xl65" style="font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Arial Narrow";background:red;mso-pattern:black none">100.00</td> <td class="xl66" align="right">104.44</td> </tr> <tr style="mso-height-source:userset;height:16.5pt" height="22"> <td class="xl67" style="height:16.5pt" height="22">GLD</td> <td class="xl68">34.02</td> <td class="xl69" align="right">169.12</td> </tr> <tr style="mso-height-source:userset;height:17.25pt" height="23"> <td class="xl64" style="height:17.25pt" height="23">SLV</td> <td class="xl65">62.63</td> <td class="xl66" align="right">36.953</td> </tr> <tr style="height:17.25pt" height="23"> <td class="xl67" style="height:17.25pt" height="23">USO</td> <td class="xl68">27.54</td> <td class="xl69" align="right">32.05</td> </tr> <tr style="mso-height-source:userset;height:16.5pt" height="22"> <td class="xl64" style="height:16.5pt" height="22">IWM</td> <td class="xl65" style="font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Arial Narrow";background:#00B050;mso-pattern:black none">17.01</td> <td class="xl66" align="right">67.81</td> </tr> <tr style="mso-height-source:userset;height:16.5pt" height="22"> <td class="xl67" style="height:16.5pt" height="22">QQQ</td> <td class="xl68" style="font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Arial Narrow";background:red;mso-pattern:black none">84.81</td> <td class="xl69" align="right">52.21</td> </tr> <tr style="mso-height-source:userset;height:16.5pt" height="22"> <td class="xl64" style="height:16.5pt" height="22">DIA</td> <td class="xl65">73.35</td> <td class="xl66" align="right">110.2</td> </tr> <tr style="mso-height-source:userset;height:17.25pt" height="23"> <td class="xl67" style="height:17.25pt" height="23">KBE</td> <td class="xl68" style="font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Arial Narrow";background:#00B050;mso-pattern:black none">0.00</td> <td class="xl69" align="right">19.18</td> </tr> <tr style="mso-height-source:userset;height:17.25pt" height="23"> <td class="xl70" style="height:17.25pt" height="23">VTI</td> <td class="xl68">53.41</td> <td class="xl69" align="right">59</td> </tr> </tbody></table>
Column 1 is the symbol, column 2 is my indicator and column 3 is the last price. I want to add another column(s) that will tell me when column 2 hits 100 (or 0, these are the extreme bounds of the indicator) then crosses back through 90, for example. I think I need column 4 to "set" once 100 or 0 is recorded in column 3, then have column 5 read "buy" or "sell" once column 2 is less than 90 (or greater than 10). Not sure how to construct this. Thanks in advance!