V4.0.0.0 Wrong 52-Week-High data

Discussion in 'Troubleshooting' started by therzog, Mar 30, 2016.

V4.0.0.0 Wrong 52-Week-High data

  1. therzog

    therzog New Member

    Joined:
    Feb 18, 2016
    Messages:
    6
    Likes Received:
    0
    Just updated to v4.0.0 and amm my 52 week high fields are incorrect.

    AAPL showing 134.54 s/b $110

    Grrrrrrrrrrrrr...new release and a basic bug like this. Did anyone even bother to test this release?
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,099
    Likes Received:
    10
    Hi Todd,

    Ok, I am checking this.

    Kind Regards
    Ankur
     
  3. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,099
    Likes Received:
    10
    [​IMG]

     

    It was indeed 134.54, are we missing something here?

    Thanks

    Ankur
     
  4. therzog

    therzog New Member

    Joined:
    Feb 18, 2016
    Messages:
    6
    Likes Received:
    0
    The something else is going on.  I have conditional formatting on the 52High field to change the color when it is at a new high and every stock is showing as a new 52 week high  (green).  before update, I had (2) stocks near high (yellow) and everything else with default (white) formatting.  The only change I made was the upgrade.
     
  5. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,099
    Likes Received:
    10
    Hi Todd,

    Right, I checked with many stocks and all values seems to be correct. May be there is something with the conditional formatting then. If you need help around it I am available as well. If you find any stock where the number is not what it must be then please let me know.

    Kind regards

    Ankur

     
     
  6. therzog

    therzog New Member

    Joined:
    Feb 18, 2016
    Messages:
    6
    Likes Received:
    0
    I give up. under the old version things basically worked. under v4, everything is a mess.  (a) Conditional formatting on cells is changed. (b) when my   =Last("AAPL") refresh the number formatting is messed up (should be "comma" with (2) decimal not 109.4867 left justified; (c) My =Last1("someIndex") e.g. "^DJI" now return #VALUE; (d) it is still really slow to refresh.

    I do not trust anything in my sheet now.

    I quit my software development job because I got tired of testing someone else software.  Why am I doing it again?
     
  7. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,099
    Likes Received:
    10
    Hi Todd,

    Sure I understand. Apologies for the inconvenience on your point C.  For rest please see my comments below..

    (a) Conditional formatting on cells is changed. - Again this needs to be Excel setting we have no control over it. 

    (b) when my =Last("€œAAPL"€) refresh the number formatting is messed up (should be "€œcomma"€ with (2) decimal not 109.4867 left justified - Ok, this is about your cell format. As long as the value is okay I do not think that should be an issue. 

    (c) My =Last1("€œsomeIndex"€) e.g. "€œ^DJI"€ now return #VALUE; - Please can you use "=Last" for indices?

    (d) it is still really slow to refresh. - Ok - I am checking this.

    Kind regards

    Ankur
     
  8. therzog

    therzog New Member

    Joined:
    Feb 18, 2016
    Messages:
    6
    Likes Received:
    0
    Conditional formatting does not work and it is ties to marketXLS

    Column F=Symbol

    Column H=Last(F58)

    Column O=FiftyTwo_weekHigh(F58)

    [​IMG]

     

    [​IMG]

    If Column H is changed to a pure number (remove function) the conditional formatting works.  So there is a hierarchy of evaluation issue here.

    And the obvious solution if to change the conditional formatting rule to =Last(H58)>O58, but Excel gives and error and rejects the marketxls function.

    so therefore "(a) Conditional formatting on cells is changed. "€“ Again this needs to be Excel setting we have no control over it. " is not true.

    Please provide a solution to this bug.

     

    ************SYMBOLS************

    What is the Symbol for the S&P 500 Index?

    What is the Symbol for the DJIA?

    Changing to =Last("xxx") from =Last1("xxx") resolved some issues, but not all.
     
  9. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,099
    Likes Received:
    10
    Hi Todd,

    Thank You for your questions.

    Regarding the conditional formatting issue, the best way is to use the = Value function of Excel with MarketXLS functions.

    So, in summary, use the formulas like following and I think that should solve conditional formatting issue....
    Column H=Value(Last(F58))
    Column O=Value(FiftyTwo_weekHigh(F58))

    **** Symbols***
    Regarding indexes, please use them as follows...

    =Ask("€œ^GSPC"€) for S&P
    =Last1("€œSPX:IND"€) for S&P
    =Last("€œ^GSPC"€) for S&P
    =Last("€œ^DJI"€) for Dow Industrial
    =Last("€œ^IXIC"€) for NASDAQ
    =Last1("€œCCMP:IND"€) for NASDAQ
    =Last1("€œINDU:IND"€) for DJIA

    Let me know if this solves the issue.

    Kind regards
    Ankur for MarketXLS Support
     
  10. Zhao Yan

    Zhao Yan New Member

    Joined:
    Nov 13, 2017
    Messages:
    2
    Likes Received:
    0
    Hi,
    How about OpenPrice("^GSPC"), DaysLow("^GSPC"), and DaysHigh("^GSPC")? They return NA on my excel.
    Thanks,
    Zhao
     

Share This Page