Hi,(adsbygoogle = window.adsbygoogle || []).push({});

I'm new to the forum and have a maths question. So basically, X is the time axis (per minute) and Y is the price axis. I have a data set of 200,000 Y values in excel. If I were to draw two horizontal lines through the sine like wave, how many times will the line travel between A and B?? I need a theoretical equation, or excel formula to work it out.

Image is posted below

Help will be greatly appreciated.

Thanks,

Ed

**Physics Forums | Science Articles, Homework Help, Discussion**

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# How many times will the line travel between A and B

**Physics Forums | Science Articles, Homework Help, Discussion**