CloseHistory Function not work

Discussion in 'Troubleshooting' started by chunwaihome, May 15, 2016.

CloseHistory Function not work

  1. chunwaihome

    chunwaihome New Member

    Joined:
    May 15, 2016
    Messages:
    3
    Likes Received:
    0
    Hello,

    I am software buyer from Hong Kong, e.g.

    =Close_Historical("APPL","5/5/2016")

    Second, 200 day moving average is also inaccurate when i compare the value calculate from Yahoo Finance.

    This EMA is simple moving average?

     
     
  2. chunwaihome

    chunwaihome New Member

    Joined:
    May 15, 2016
    Messages:
    3
    Likes Received:
    0
    All ShengShei Stock also not working

    e.g

    600216.SS
    600015.SS
    600007.SS
    600029.SS
    600757.SS
     
  3. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    Hi Chun,

    Do you want AAPL? instead of what you used in this function?

    =Close_Historical("€œAPPL"€,"€5/5/2016"€³)

    I checked the database and the function for AAPL seems to be working fine.

    "200 day moving average is also inaccurate" - May I ask which symbol you are looking at? EMA is exponential moving average. SMA is the Simple Moving Average.

    For ShengShei Stocks please can you use the following?

    =LastPriceRealTime("600216.SS") = 12.99

     

    Let me know.

    Ankur for MarketXLS

     
     
  4. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    Hi Chun,

    About the close_historical function, looks like you are right, there are some datapoints that seem to be missing in the database. We will fix this tomorrow.

    Kind regards

    Ankur for MarketXLS
     
  5. chunwaihome

    chunwaihome New Member

    Joined:
    May 15, 2016
    Messages:
    3
    Likes Received:
    0
    stockNo   200moving average   50 moving average

    0001.HK 99.16    96.84
    0002.HK 67.45   71.37
    0003.HK 14.6     14.46
    0004.HK 41.7    41.79
    0005.HK 54.6    49.16
    0006.HK 72.29   69.5
    0007.HK 0.68    0.68
    0008.HK 4.72    5.16
    0009.HK 1.13    0.89

    200,50 moving average seem to be inaccurate, I compare them with the value that calculate and found from other website.

     
     
  6. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    Hi Chun,

    Ok, we are checking on these.

    Kind regards
    Ankur
     

Share This Page