[Easy Question] convert web page to csv format

Discussion in 'Trading' started by jk90029, Jan 15, 2017.

  1. Sir this is impossible !
    If you had posted this an hour ago, I could have downloaded the company list from Bloomberg in my office.
     
  2. Take time please. Appreciate if you go to office next week.
     
    victorycountry likes this.
  3. mouse select the list, copy, paste into an open office calc, save and export into cvs.
     
  4. xandman

    xandman

    Are you sure you want it in csv?

    As an excel file, you can preserve all the hyperlinks. Just start highlighting from the first row(not the header) and copy/paste to Excel.

    I rather like the quick links to Edgar and the financial statements.

    upload_2017-1-15_0-30-49.png
     
    drm7 likes this.
  5. Surgo

    Surgo

    edit the wikipedia page, copy the table minus the header, paste into a file, sed "s/|-//; s/^\t{{[^|]\+\([^}]\+\).*/\1/; /^$/d" | tr "\n" ","
     
  6. See attached. Both excel and csv are included. Just remove the extension .txt at the end of the file names before opening them.
     
  7. Appreciated.