How to download Philippine Stock Exchange Data

Discussion in 'General Questions' started by charboe, Aug 19, 2016.

How to download Philippine Stock Exchange Data

  1. charboe

    charboe New Member

    Joined:
    Aug 15, 2016
    Messages:
    9
    Likes Received:
    0
    Hi I recently purchased MarketXLS Pro. How can I download the Philippine stock market data.Is it also possible to download data from other sources other than yahoo like morning star and msn.
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,123
    Likes Received:
    10
    Hi Charles,

    Please can you send me names of some companies you wish to track as examples?

    Thanks
    Ankur for MarketXLS
     
  3. charboe

    charboe New Member

    Joined:
    Aug 15, 2016
    Messages:
    9
    Likes Received:
    0
    Hi Ankur thanks for respoding to my inquiry.

     

    Here are the examples of the company

    Ticker      Company

    URC         Universal Robina

    MPI          Metropacific Inc

    GTCAP     GT Capital

    SEVN       Philippine Seven Corporation

    GMA7       GMA Network Inc

    ALI           Ayala Land Inc

    I cant find it in Yahoo although some data are available in MSN, Morning star has by far the more complete i see.

    Here is the address in morning star for sample data;

    http://financials.morningstar.com/company-profile/c.action?t=SECB&region=PHL&culture=en_US

    Hope you can help me as I am eager to use the add in.Thanks

     

    Charles

     
     
  4. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,123
    Likes Received:
    10
    Hi Charles,

    Please can you try as shown below for all of these?
    =Last1("GMA7:pM")

    Let me know.

    Kind regards
    Ankur for MarketXLS
     
  5. charboe

    charboe New Member

    Joined:
    Aug 15, 2016
    Messages:
    9
    Likes Received:
    0
    Dear Ankur,

    Hi. Thanks for your reply. Yes its returning the price now.However I tried downloading the financial data like cashflow and balance sheet and it returning the following ;

     

    Microsoft excel cannot access the file xxxxxxxxxxxxxxxxxxxxxx

    Check subscription id or symbol you have inthe cell.The symbol must be a valid US stock symbol

     

     
     
  6. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,123
    Likes Received:
    10
    Hi Charles,

    I am afraid, many such features are not available for Philipines stock market for now. You may want to consider downgrading to a lower version. But we intend to add popular stock markets apart from US and EU soon.

    Kind regards

    Ankur

     

     
     
  7. charboe

    charboe New Member

    Joined:
    Aug 15, 2016
    Messages:
    9
    Likes Received:
    0
    Will the Philippine Stock be included in the future update when will that be?I cant seem to download also the EPS,BVPS,Voume , Open High Low ,Close ,Volume  etch any suggestions,The custom dates download doesnt work as well. Very frustrating. Help please

     

    Charles
     
  8. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,123
    Likes Received:
    10
    Hi Charles,

    Philipine stock market will be included in future for sure. But it may save some time. I can issue you a refund for now and ping you back as soon as we have all that data.

    Sorry for the inconvenience.

    Let me know if this sounds okay to you?

     

    Thanks

    Ankur for MarketXLS
     
  9. charboe

    charboe New Member

    Joined:
    Aug 15, 2016
    Messages:
    9
    Likes Received:
    0
    Dear Ankur,

    Hi. Yes i opt to have the refund at this time. Kindly let me know when the Philippine stock will be available. Thanks for the assistance.

     

    Charles
     
  10. charboe

    charboe New Member

    Joined:
    Aug 15, 2016
    Messages:
    9
    Likes Received:
    0
    Dear Ankur,

     

    Hi. I would like to follow up status of my request for refund. Thanks

     

    Charles
     
  11. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,123
    Likes Received:
    10
    Hi Charles,

    Sent you a reply on your ticket. Please suggest.

    Thanks
    Ankur for MarketXLS
     

Share This Page