Download Data Bursa Efek Indonesia gunakan PowerQuery Bag. IV (Daftar Links tersembunyi)

Di postingan ini akan dibahas beberapa menu dan link tersembunyi yang ada, juga akan diberikan file excel hasil kerja dari awal untuk didonlot lalu dianalisa

File dari bag. 1 sampai 4

IDX (2.3 MiB, 12 downloads)

A.  Ambil banyak data Emiten sekaligus

  1. Copy Kode emiten dari sheet daftar Emiten
  2. Bikin Rumus link
  3. Rumusnya
  4. ="https://www.idx.co.id/perusahaan-tercatat/profil-perusahaan-tercatat/detail-profile-perusahaan-tercatat/?kodeEmiten=" &A2
  5. Copas ke record terakhir
  6. block semua rumus
  7. sebelumnya ganti dulu frmat ke Indonesia karena web ini menggunakan format Indonesia
  8. lalu klik menu e-Audit - Collect Data - Sedot Multiple link internet
  9. Klik Select
  10. Klik OK
  11. Pilih Sedot as Text
  12. ini hasilnya

Detil Emiten juga bisa disedot gunakan PQ karena data anak perusahaan tidak bisa disedot menggunakan cara diatas

  1. Buka Excel
  2. sedot web gunakan Data - New Query - From Other Source - From web
  3. https://www.idx.co.id/umbraco/Surface/ListedCompany/GetCompanyProfilesDetail?emitenType=&kodeEmiten=SIMP&language=id-id
  4. Ganti kode emiten dengan pilihan anda
  5. Berikut yang bisa disedot gunakan PQ

B.  Data Anak Perusahaan Emiten

  1. Lakukan Langkah diatas
  2. Pilih
  3. Klik To Table
  4. Breakdown gunakan tombol di kanan atas
  5. ini hasilnya
  6. Data yang lain (seperti pemegang saham, direksi, komisaris, deviden, dll) biasanya ditarik pake cara A sudah bisa

C. Kalender

  1. Gunakan link
  2. https://www.idx.co.id/umbraco/Surface/Home/GetCalendar?range=SIMP&date=&language=id-id
  3. Ganti kode emiten sesuai kebutuhan

D.  Cara mencari kupon Rate Surat Berharga Negara atau Corp

  1. Jika kita masuk ke link Surat utang negara
  2. https://www.idx.co.id/data-pasar/data-obligasi-sukuk/surat-berharga-negara/
  3. isinya hanya ini
  4. Tapi jika kita gunakan PQ maka isinya lebih lengkap
  5. Gunakan link
  6. https://www.idx.co.id/umbraco/Surface/BondSukuk/GetBondGovSearch?yearMatured=&bondId=&bondCategory=&langId=id-id&draw=3&columns%5B0%5D%5Bdata%5D=Id&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=true&columns%5B0%5D%5Borderable%5D=false&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=Id&columns%5B1%5D%5Bname%5D=&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=false&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=Name&columns%5B2%5D%5Bname%5D=&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=false&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=Outstanding&columns%5B3%5D%5Bname%5D=&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=false&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B4%5D%5Bdata%5D=MatureDate&columns%5B4%5D%5Bname%5D=&columns%5B4%5D%5Bsearchable%5D=true&columns%5B4%5D%5Borderable%5D=false&columns%5B4%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B4%5D%5Bsearch%5D%5Bregex%5D=false&start=0&length=10&search%5Bvalue%5D=&search%5Bregex%5D=false&_=1608901844599
  7. Ganti start=0&length=100 menjadi start=0&length=10000
  8. Sedot gunakan PQ
  9. ini field yang bisa diambil
  10. Untuk Surat Utang Korporasi/swasta pake link
  11. https://www.idx.co.id/umbraco/Surface/BondSukuk/GetBondCorpSearch?draw=2&columns%5B0%5D%5Bdata%5D=Id&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=true&columns%5B0%5D%5Borderable%5D=false&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=Id&columns%5B1%5D%5Bname%5D=&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=false&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=Name&columns%5B2%5D%5Bname%5D=&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=false&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=IssuerCode&columns%5B3%5D%5Bname%5D=&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=false&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B4%5D%5Bdata%5D=MatureDate&columns%5B4%5D%5Bname%5D=&columns%5B4%5D%5Bsearchable%5D=true&columns%5B4%5D%5Borderable%5D=false&columns%5B4%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B4%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B5%5D%5Bdata%5D=Rating&columns%5B5%5D%5Bname%5D=&columns%5B5%5D%5Bsearchable%5D=true&columns%5B5%5D%5Borderable%5D=false&columns%5B5%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B5%5D%5Bsearch%5D%5Bregex%5D=false&start=0&length=10&search%5Bvalue%5D=&search%5Bregex%5D=false&_=1608902710611
  12. ganti menjadi length=10000

 

E. Ringkasan Saham

Link:

https://www.idx.co.id/umbraco/Surface/TradingSummary/GetStockSummary?date=20201229&start=0&length=1000

Ganti saja Date

Print Friendly, PDF & Email
Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *