1
$\begingroup$

I'm trying to find the historical data for 3 month or 6 month lows.

Thinkorswim has it (NYLO3M) and barcharts.com has it (M3LN) but they don't match...and thinkorswim only goes back to 2012.

Does anyone know of another source where I could get this data?

$\endgroup$
2
  • 1
    $\begingroup$ Are you looking just for the number of stocks making new lows, or also the names of these stocks? $\endgroup$ – noob2 May 21 at 0:12
  • 1
    $\begingroup$ Just the number of stocks that are making new 3 month lows (and/or 6 month lows). I've been able to easily find 12 month lows...but not for the other intervals @noob2 $\endgroup$ – user749798 May 21 at 15:11
0
$\begingroup$

I suggest you to :

  1. Visit : yahoo finance Nasdaq page
  2. Click on "Historical Data"
  3. Enter your date range
  4. Click on "download"
  5. You get a .csv file with all your data (including the lows)
  6. If you do not know how to clean a csv file, I suggest you click on the first column which includes your data, then "Data" ribbon, then "Text To column" and you're there !

I hope it helps !

$\endgroup$
2
  • $\begingroup$ Thanks, but this won't help with finding the number of stocks that make 3 month new lows. This just downloads stock prices. $\endgroup$ – user749798 May 21 at 15:12
  • $\begingroup$ Maybe I am missing something but once you have daily data, it should not be too difficult to do it without a datasource? pandas.pydata.org/docs/reference/api/… pulls the lowest value within any rolling window - you could filter for current value and if it matches, you know it is low in that period. or something like '''x = np.random.random(50) df = pd.DataFrame({'random': x}) minimum = df['random'].rolling(window = 4).min() == df['random'] mins = df[minimum]''' as a dummy example in Python $\endgroup$ – AKdemy May 21 at 20:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.