'Name' function not working

Discussion in 'Troubleshooting' started by carolberger, Jul 13, 2016.

'Name' function not working

  1. carolberger

    carolberger New Member

    Joined:
    Jul 13, 2016
    Messages:
    8
    Likes Received:
    0
    I am using the Name function in my spreadsheets to pull in various mutual funds, etc. and it is not working. I am on version 5.0.0.0 and recently upgraded to Office 2016. It looks like my license is valid (Basic). Can you help?
     
  2. ScottPalmer

    ScottPalmer New Member

    Joined:
    Mar 2, 2016
    Messages:
    6
    Likes Received:
    0
    I'm experiencing the same problem with the Name function...
     
  3. wwkoenig

    wwkoenig New Member

    Joined:
    Jul 13, 2016
    Messages:
    7
    Likes Received:
    0
    I have the same problem, Sector is not working either
     
  4. bcooke

    bcooke New Member

    Joined:
    Jul 13, 2016
    Messages:
    8
    Likes Received:
    0
    YHOO_Price is returning #VALUE as well  has not been working since yesterday

     
     
  5. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Hi,

    I see the issue with the name function, I am working on these.

    Kind regards

    Ankur for MarketXLS
     
  6. bcooke

    bcooke New Member

    Joined:
    Jul 13, 2016
    Messages:
    8
    Likes Received:
    0
    Any update on this issue? Still not working as of this morning
     
  7. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Hi Brad,

    I have invested these issues. The name function, sector function and all currency functions are not working. These are being worked on to be fixed in coming release on Monday or Tuesday (18th of 19th of July) release. You will receive an email as soon as the new version is released.

    Apologies for the inconvenience.

    Kind regards

    Ankur
     
  8. carolberger

    carolberger New Member

    Joined:
    Jul 13, 2016
    Messages:
    8
    Likes Received:
    0
    I've installed the update and certain symbols are still not working with the Name function. Looks like stocks and ETFs are working but not mutual funds?
     
  9. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Hi Carol,

    Name function is still being fixed on our server, it will start working soon.

    Kind regards

    Ankur for MarketXLS
     
  10. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    The name function is now working fine for everything Mutual funds and everything else.

    Kind regards

    Ankur
     
  11. bcooke

    bcooke New Member

    Joined:
    Jul 13, 2016
    Messages:
    8
    Likes Received:
    0
    Still not working on my end as of 7/25/2016.
     
  12. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Hi Brad,

    I have see a few symbols not working, so I am adding more symbols to the masterlist.

    Does this work for you? =Name(A1) where A1 has MSFT? If yes, then please can you give me an example of symbol which is returning NA?

    Thanks

    Ankur
     
  13. bcooke

    bcooke New Member

    Joined:
    Jul 13, 2016
    Messages:
    8
    Likes Received:
    0
    no that does not work. every symbol is returning #value in the cell
     
  14. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Please can you see in Excel's function browser if you have MarketXLS functions active? Does this work for you?

    =Ask(A1) , or Last(A1) where A1 is MSFT

    Thanks

    Ankur
     
  15. bcooke

    bcooke New Member

    Joined:
    Jul 13, 2016
    Messages:
    8
    Likes Received:
    0
    Yes both Ask and Lasttradeprice function work
     
  16. carolberger

    carolberger New Member

    Joined:
    Jul 13, 2016
    Messages:
    8
    Likes Received:
    0
    Some mutual funds are returning N/A. DEMSX, DFTWX, VBIIX, and VTIBX are some that I've seen not working. Why would some Vanguard or DFA funds work, but not all?
     
  17. bcooke

    bcooke New Member

    Joined:
    Jul 13, 2016
    Messages:
    8
    Likes Received:
    0
    Are you going to correct these basic functions or walk me through how to fix it? It has been over 2 weeks. If this is not resolved, I would like a refund issued. This is unacceptable for a paid service.
     
  18. carolberger

    carolberger New Member

    Joined:
    Jul 13, 2016
    Messages:
    8
    Likes Received:
    0
  19. bcooke

    bcooke New Member

    Joined:
    Jul 13, 2016
    Messages:
    8
    Likes Received:
    0
    Still waiting for a response...
     
  20. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Hi Brad,

    I am still working to fix this problem with the name functions and Mutual funds. Sorry for the delay but please expect all these working by this weekend.

    Thanks for your understanding.

    Kind Regards

    Ankur
     

Share This Page