{"id":1441,"date":"2018-10-01T19:02:21","date_gmt":"2018-10-01T19:02:21","guid":{"rendered":"http:\/\/www.gokberkcan.com\/?p=1441"},"modified":"2018-10-01T19:02:21","modified_gmt":"2018-10-01T19:02:21","slug":"hisse-fiyatlari-nasil-indirilir","status":"publish","type":"post","link":"https:\/\/www.gokberkcan.com\/?p=1441","title":{"rendered":"Hisse Fiyatlar\u0131 Nas\u0131l \u0130ndirilir?"},"content":{"rendered":"\n

Borsa \u0130stanbul’a kote bir \u015firkete finansal verileri topluca indirmek i\u00e7in \u00fccretli bir hizmete ihtiyac\u0131n\u0131z var. Sab\u0131r konusunda iyi oldu\u011funuzu d\u00fc\u015f\u00fcn\u00fcyorsan\u0131z faaliyet raporlar\u0131n\u0131 okuyarak tek tek istedi\u011finiz b\u00fct\u00fcn muhasebe verilerine ula\u015fabilirsiniz. Doktora tezi sebebiyle 1.668 adet faaliyet raporu okumu\u015f biri olarak s\u00f6yleyebilirim ki bo\u015fverin otomatik veri indirmeyi. En e\u011flencelisi(!?) halka a\u00e7\u0131k \u015firketlerin “kime okumas\u0131n” hayaliyle yay\u0131mlad\u0131\u011f\u0131 faaliyet raporlar\u0131n\u0131 sayfa okumakt\u0131r.<\/p>\n\n\n

G\u00fcnl\u00fck hisse fiyatlar\u0131n\u0131 indirmek i\u00e7in de birbirinden az reklaml\u0131 borsa sitelerini gezebilirsiniz. Bir di\u011fer se\u00e7enek de Google e-Tablolar kullanmak. Uygulama i\u00e7inde mevcut olan GOOGLEFINANCE fonksiyonu ile istedi\u011finiz \u015firket ait hisse fiyatlar\u0131n\u0131 g\u00fcnl\u00fck ve haftal\u0131k olarak indirebilirsiniz.<\/p>\n\n\n

=GOOGLEFINANCE(“IST:EREGL”,”price”,”1\/1\/2018″,”9\/30\/2018″,”DAILY”)<\/p>\n\n\n

Yukar\u0131da yaz\u0131l\u0131 fonksiyon bize Ere\u011fli Demir \u00c7elik’e ait 1 Ocak  – 30 Eyl\u00fcl tarihleri aras\u0131ndaki hisse fiyatlar\u0131n\u0131 g\u00fcnl\u00fck olarak verecek. Ancak burada anlat\u0131lmas\u0131 gereken noktalar var:<\/p>\n\n\n

  1. IST ibaresi Borsa \u0130stanbul’u ifade ediyor. ABD borsalar\u0131na kay\u0131tl\u0131 \u015firketler i\u00e7in borsa kodu ibaresine ihtiyac\u0131m\u0131z yok ancak farkl\u0131 borsalardaki \u015firketler i\u00e7in ilgili borsa kodunu finance.google.com adresinden \u00f6\u011frenebilirsiniz.<\/li>
  2. “price” hisse fiyat\u0131n\u0131 ifade ediyor, ula\u015fabilece\u011finiz farkl\u0131 veriler de mevcut bu arada. Fiyat-kazan\u00e7 oran\u0131 (“pe”) veya “beta” gibi. Verinin niteli\u011fi y\u00fcz\u00fcnden g\u00fcnl\u00fck indirim m\u00fcmk\u00fcn olmayacakt\u0131r.<\/li>
  3. Ba\u015flang\u0131\u00e7 ve biti\u015f tarihlerinin “ay\/g\u00fcn\/y\u0131l” olarak yaz\u0131lmas\u0131 laz\u0131m.<\/li>
  4. Bana haftal\u0131k veriler laz\u0131m diyorsan\u0131z “DAILY” sorgusunu “WEEKLY” olarak de\u011fi\u015ftirebilirsiniz.<\/li><\/ol>\n\n\n

    =GOOGLETRANSLATE(“kolay gelsin”, “TR”, “AR”)<\/p>\n","protected":false},"excerpt":{"rendered":"

    Borsa \u0130stanbul’a kote bir \u015firkete finansal verileri topluca indirmek i\u00e7in \u00fccretli bir hizmete ihtiyac\u0131n\u0131z var. Sab\u0131r konusunda iyi oldu\u011funuzu d\u00fc\u015f\u00fcn\u00fcyorsan\u0131z faaliyet raporlar\u0131n\u0131 okuyarak tek tek istedi\u011finiz b\u00fct\u00fcn muhasebe verilerine ula\u015fabilirsiniz. Doktora tezi sebebiyle 1.668 adet faaliyet raporu okumu\u015f biri olarak s\u00f6yleyebilirim ki bo\u015fverin otomatik veri indirmeyi. En e\u011flencelisi(!?) halka a\u00e7\u0131k \u015firketlerin “kime okumas\u0131n” hayaliyle yay\u0131mlad\u0131\u011f\u0131 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1441","post","type-post","status-publish","format-standard","hentry","category-akademik"],"_links":{"self":[{"href":"https:\/\/www.gokberkcan.com\/index.php?rest_route=\/wp\/v2\/posts\/1441","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gokberkcan.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gokberkcan.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gokberkcan.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gokberkcan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1441"}],"version-history":[{"count":0,"href":"https:\/\/www.gokberkcan.com\/index.php?rest_route=\/wp\/v2\/posts\/1441\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gokberkcan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1441"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gokberkcan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1441"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gokberkcan.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1441"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}