|
XLQ Stopped Working
The XLQ program has suddenly stopped working. I have used XLQ for years and this has never happened before. I rebooted the program, but that didn't help. I downloaded the XLQ program again with no suc
|
The XLQ program has suddenly stopped working. I have used XLQ for years and this has never happened before. I rebooted the program, but that didn't help. I downloaded the XLQ program again with no suc
|
By
...
· #3104
·
|
|
Random errors on xlqrhHighestClose
I went over to the demo and input MEDFF, using yahoo as source and it works. I used the formula of: =xlqrhHighestClose("Symbol","Date Ref1", "Date Ref2","Source") It appears that you have to use speci
|
I went over to the demo and input MEDFF, using yahoo as source and it works. I used the formula of: =xlqrhHighestClose("Symbol","Date Ref1", "Date Ref2","Source") It appears that you have to use speci
|
By
...
· #3084
·
|
|
Use Multiple Data Sources
Ed, I can’t tell you why, but yes, I am getting info from TDA on approx. 1300 different stocks. Rich
|
Ed, I can’t tell you why, but yes, I am getting info from TDA on approx. 1300 different stocks. Rich
|
By
...
· #3082
·
|
|
Microsoft excel is waiting for another application to complete an OLE action
I use XLQ with Excel 365. Works fine; although recently I notice that excel shuts down and automatically reboots. Don’t understand it and to my knowledge I don’t have any virus or malware to cause thi
|
I use XLQ with Excel 365. Works fine; although recently I notice that excel shuts down and automatically reboots. Don’t understand it and to my knowledge I don’t have any virus or malware to cause thi
|
By
...
· #3077
·
|
|
TDA Update
TDA doesn’t provide Price to Book. Yahoo does. =xlqPricePerBook("Symbol","Source") For Dividend with TDA, use: =xlqDividendAmount("Symbol","Source") I don’t know about the others.
|
TDA doesn’t provide Price to Book. Yahoo does. =xlqPricePerBook("Symbol","Source") For Dividend with TDA, use: =xlqDividendAmount("Symbol","Source") I don’t know about the others.
|
By
...
· #3074
·
|
|
Use Multiple Data Sources
The recent loss of Yahoo as a day data source had a silver lining. I learned a lot more about the XLQ program. Like many users, I had to move from Yahoo to TDA. I also had to become more familiar with
|
The recent loss of Yahoo as a day data source had a silver lining. I learned a lot more about the XLQ program. Like many users, I had to move from Yahoo to TDA. I also had to become more familiar with
|
By
...
· #3073
·
|
|
=xlqName #N/A
Make sure to review the demo spreadsheet. There is a worksheet for historic and another for day formulas. Make sure to go into the xlq preferences and set the default source for day to TDA and the def
|
Make sure to review the demo spreadsheet. There is a worksheet for historic and another for day formulas. Make sure to go into the xlq preferences and set the default source for day to TDA and the def
|
By
...
· #3071
·
|
|
=xlqName #N/A
Best to read the previous comments about this subject in the xlq group. Also go into the xlq spreadsheet demo to review the formula. You do not need to put the data source in the formula if you have p
|
Best to read the previous comments about this subject in the xlq group. Also go into the xlq spreadsheet demo to review the formula. You do not need to put the data source in the formula if you have p
|
By
...
· #3069
·
|
|
=xlqName #N/A
Make sure you read all of the past comments about this issue. There are a variety of reasons why u could be having problems. Have u signed up for TDA account and completed everything they require. Hav
|
Make sure you read all of the past comments about this issue. There are a variety of reasons why u could be having problems. Have u signed up for TDA account and completed everything they require. Hav
|
By
...
· #3066
·
|
|
TDA not updating
Hello, mine is working. You might want to go into preference and Delete all data on exit – once. That may help to reset it. Thanks
|
Hello, mine is working. You might want to go into preference and Delete all data on exit – once. That may help to reset it. Thanks
|
By
...
· #3058
·
|
|
xlqAverageVolume with TDA
For dividend, use this formula: =xlqDividendAmount Not sure why xlqdivpershare is even listed. Rich
|
For dividend, use this formula: =xlqDividendAmount Not sure why xlqdivpershare is even listed. Rich
|
By
...
· #3034
·
|
|
IQFeed vs. TDA
I know that dividends are included along with very fast real time stock prices, price changes, p/e, peg, 12 mo hi and lo prices. I am still looking for 4 or 5 year average dividend yield. Rich
|
I know that dividends are included along with very fast real time stock prices, price changes, p/e, peg, 12 mo hi and lo prices. I am still looking for 4 or 5 year average dividend yield. Rich
|
By
...
· #3018
·
|
|
TDA RT Data “Busy” – SOLVED
There are a variety of things to look at: XLQ Preference: Do you have Default Day Source set for TDA? Did you enter your TDA username and password in the DATA SOURCE SPECIFIC / TD AMERITRADE SPREADSHE
|
There are a variety of things to look at: XLQ Preference: Do you have Default Day Source set for TDA? Did you enter your TDA username and password in the DATA SOURCE SPECIFIC / TD AMERITRADE SPREADSHE
|
By
...
· #3015
·
|
|
XLQ Day Date with XLQ Lite
Yahoo is no longer providing intra day data; however, there are several other options. TDA is free and provides data for up to 600 symbols. There is also IQ Feed, but they charge around $100 for 500.
|
Yahoo is no longer providing intra day data; however, there are several other options. TDA is free and provides data for up to 600 symbols. There is also IQ Feed, but they charge around $100 for 500.
|
By
...
· #3010
·
|
|
Multiple XLQ Accounts?
Leo, Thanks for the info on dtnig.com; however, do you have them set up as a source in XLQ? Rich
|
Leo, Thanks for the info on dtnig.com; however, do you have them set up as a source in XLQ? Rich
|
By
...
· #3002
·
|
|
Multiple XLQ Accounts?
I happen to track about 1500 stocks using XLQ and since TDA only handles 600, I wondered if it would be feasible to have 3 XLQ accounts. That way I could follow 500 on each account. Curious if anyone
|
I happen to track about 1500 stocks using XLQ and since TDA only handles 600, I wondered if it would be feasible to have 3 XLQ accounts. That way I could follow 500 on each account. Curious if anyone
|
By
...
· #3000
·
|
|
TDA to replace Daily Yahoo Data
How much did you pay for IQ Feed?
|
How much did you pay for IQ Feed?
|
By
...
· #2996
·
|
|
Status
It appears that you will have to move to TDA (TD Ameritrade). Actually, it is pretty easy. Just go to TD Ameritrade web site and sign up. Then go back to XLQ preferences and change the source to TDA a
|
It appears that you will have to move to TDA (TD Ameritrade). Actually, it is pretty easy. Just go to TD Ameritrade web site and sign up. Then go back to XLQ preferences and change the source to TDA a
|
By
...
· #2995
·
|
|
TDA Setup
I got everything up and running just by signing up with TDA account. Didn't even have to put any money into the account and didn't open anything wit think and swim. Get Outlook for Android
|
I got everything up and running just by signing up with TDA account. Didn't even have to put any money into the account and didn't open anything wit think and swim. Get Outlook for Android
|
By
...
· #2991
·
|
|
TDA to replace Daily Yahoo Data
Check with quantumonline to make sure they are still active or havent changed symbol. Get Outlook for Android
|
Check with quantumonline to make sure they are still active or havent changed symbol. Get Outlook for Android
|
By
...
· #2988
·
|
