Getting Closing Prices for A long List of Stocks on ONE PAGE

Discussion in 'Stocks' started by ysettle, Jul 22, 2020.

  1. ysettle

    ysettle

    I have a database of around 1000 stocks and I love the output the Yahoo finance creates, except you have to go ticker by ticker to get the results. Multiple stock-loader does the same, with each ticker having its own tab .

    Is there a way to get all 1000 stocks on the SAME PAGE with their historical closes for the past 20 or 30 days, with each ticker having the info in the same row


    Thank you in advance

    N
     
  2. I can create a custom downloader for you. It won't be free but you'll get exactly what you're looking for. Message me directly if you're interested.
     
    easymon1 likes this.
  3. ysettle

    ysettle

    Gary

    I already have a custom downloader - but it puts each stock on its own .csv tab. If its just a question of running a macro to get them all on the same page, I can do that for $25. Was looking for a free solution, or happy to pay you the $25 I would pay to my excel guy
     
  4. easymon1

    easymon1

    what a freakin bargain! who's your excel guy. twenty five frogs. wow. call his ass up and be done with it. crikey
     
  5. My thoughts exactly.....time to move on.
     
  6. ysettle

    ysettle

    this info is not hard to get - multiple sites and apps can give me months of closing price info. Simply asking if i can get it all on one page . Thanks for all your help
     
  7. easymon1

    easymon1

    Please post a sample report when your excel guy's finished. if he brings it in for less than 50 bucks, please pass him my ET contact info in case he's interested in more jobs. thanks.
     
  8. ysettle

    ysettle

    yes, i will give you the same value add you gave me
     
  9. easymon1

    easymon1

    most assuredly my good man.