=ASK() not consistently working

Discussion in 'Formulae' started by Anthony Meleg, Nov 2, 2017.

=ASK() not consistently working

  1. Anthony Meleg

    Anthony Meleg New Member

    Joined:
    Nov 2, 2017
    Messages:
    3
    Likes Received:
    0
    I have a table of stock symbols (my portfolio) and I simply want the current price, so the function =ASK([@Table Column Name]) is used. The issue is that it does not consistently work. It works for none of my ETF symbols and it does not work for V (Visa) or MCD (McDonalds) and a bunch of others. It just returns "-". Interestingly in another column, =CHANGE() always works, even for the etf symbols and the symbols that didn't work on =ASK().
     

Share This Page