I have a spreadsheet with over 80 symbols that was working fine yesterday. Now all formula return zero. Thanks, Jim

Having issues with Yahoo historical data no downloading for random ETF tickers when I refresh or open. Seems to be different tickers missing each time I refresh. have tried to delete all data once whe

Hi everyone, the break yesterday in DDE communication between Excel and IBKR API after the latest TWS update while easy enough to fix (roll back to stable reversion) got me thinking it might be worth

Hello, I hope someone can help me. I want to add a pinball indicator for stocks to my excel sheet. The Momentum Pinball strategy is easy to use and easy to understand. The strategy uses a purpose-buil

Are other people having trouble retrieving Yahoo data from last Friday, 1/24??

Hello, this formula is pulling in the intraday date/time but not the intraday price data... do you know why it's not pulling in historical price data for intraday? =xlqIntraTime("IBM",A6,"iqfeed") and

i am using the formula =xlqIntraVolume($C$4,A45) - it is only pullilng intraday data for today, and not for historical days, but I want to go back several weeks. - how do i point this to iqfeed. I pre

Hello, Can someone assist me on how to obtain VSA and Breakouts calculations for Excel ? Regards, AH

Hi There, I've got a moderately complex worksheet which is pulling in data via XLQ from various sources while also maintaining an active DDE bridge to IBKR to manage my portfolio. I've got lots of VBA

Leo, I noted this morning after updating 6.6 to 6.6a, that some of my TDA history formulas were returning #num. I was watching the status box while asking the program to refresh TDA history and this e

Hi Xlq / xlq2 6.6a is now available for download from the site. It fixes different issues that have been reported since the release of 6.6, including based on crash reports. If you are using TDAmeritr

For some reason some of my historic prices are coming back "#RANGE", while others and most of them come back fine. I am using IQFEED data and it is 7AM eastern time (non market hours). I have had issu

Looks like you’re after Ken Long’s work Sent: 02 January 2020 17:15 To: XLQ@groups.io Subject: [XLQ Users] 10day high Hello Im trying to compute the following (10day high -price)/price ---> one column

Had to start a new post, sorry. Reinstalled again, used a different folder, and it works now.

Started crashing this morning . . . uninstalled like I did last time and it fixed it. Not now. Continues to crash after I installed latest version from December 9. Anyone else?

Anyone currently utilizing AAII with XLQ? I did a search and saw several issues years ago and was wondering how well the data was currently?

Does Yahoo Finance provide real-time data?

Hi More info on the new TDAmeritrade login, in case it is useful. Previously you would have entered your TDA login in xlq preferences under data source specific TDAmeritrade, and you continue to do so

Thank you for your help! I uninstalled 6.6 and reinstalled (mine is 32 bit). TDA with XLQ keeps running now. Thx, Ken

Anyone also have a problem with TDA data crashing after a few minutes of updating? Requires Excel file close and reopen. Works for 3 minutes… crashes or stops. I am using XLQ 6.6, properly logged on i