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
[wpfilebase tag=file id=317 tpl=download-button /]
A. Ambil banyak data Emiten sekaligus
- Copy Kode emiten dari sheet daftar Emiten
- Bikin Rumus link
- Rumusnya
- ="https://www.idx.co.id/perusahaan-tercatat/profil-perusahaan-tercatat/detail-profile-perusahaan-tercatat/?kodeEmiten=" &A2
- Copas ke record terakhir
- block semua rumus
- sebelumnya ganti dulu frmat ke Indonesia karena web ini menggunakan format Indonesia
- lalu klik menu e-Audit - Collect Data - Sedot Multiple link internet
- Klik Select
- Klik OK
- Pilih Sedot as Text
- ini hasilnya
Detil Emiten juga bisa disedot gunakan PQ karena data anak perusahaan tidak bisa disedot menggunakan cara diatas
- Buka Excel
- sedot web gunakan Data - New Query - From Other Source - From web
- https://www.idx.co.id/umbraco/Surface/ListedCompany/GetCompanyProfilesDetail?emitenType=&kodeEmiten=SIMP&language=id-id
- Ganti kode emiten dengan pilihan anda
- Berikut yang bisa disedot gunakan PQ
B. Data Anak Perusahaan Emiten
- Lakukan Langkah diatas
- Pilih
- Klik To Table
- Breakdown gunakan tombol di kanan atas
- ini hasilnya
- Data yang lain (seperti pemegang saham, direksi, komisaris, deviden, dll) biasanya ditarik pake cara A sudah bisa
C. Kalender
- Gunakan link
- https://www.idx.co.id/umbraco/Surface/Home/GetCalendar?range=SIMP&date=&language=id-id
- Ganti kode emiten sesuai kebutuhan
D. Cara mencari kupon Rate Surat Berharga Negara atau Corp
- Jika kita masuk ke link Surat utang negara
- https://www.idx.co.id/data-pasar/data-obligasi-sukuk/surat-berharga-negara/
- isinya hanya ini
- Tapi jika kita gunakan PQ maka isinya lebih lengkap
- Gunakan link
- 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
- Ganti start=0&length=100 menjadi start=0&length=10000
- Sedot gunakan PQ
- ini field yang bisa diambil
- Untuk Surat Utang Korporasi/swasta pake link
- 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
- 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