0 Replies Latest reply on Jan 24, 2014 9:59 AM by Jitendra

    Free Web service  to get the stock rate by giving ISIN no of the BANKS


      Hi Experts,


      I want to fetch the latest stock rate of the banks by taking input as their ISIN(International Securities Identification Number).

      I have searched for that but i didn't get any web service.

      I tried with the below link but it is returning HTML content


      for Example

      SELECT UTL_HTTP.REQUEST('http://finance.yahoo.com/q?s='||ISINNO|| '&f=sl1c1') FROM DUAL;



      Please suggest any solution so i can get the latest stock rate of the companies.


      Database Version : 11gR2

      Apex Version : Apex 4.1


      Thanks in Advance