Gary: Barron's has developed an index of 400 stocks that beats the S&P. Barron's Sept 3 issue has a feature article on it. It would be neat if QP/HGS could...
The index is available at bigcharts.com. I still haven't found the components. Lionel From: Lionel Issen [mailto:lissen@...] Sent: Monday, September...
For various details: http://online.barrons.com/public/page/barrons_400.html http://online.barrons.com/public/page/barrons_400_characteristics.html For...
Here is a CSV file with the symbols and company name ... From: quotes-plus@yahoogroups.com [mailto:quotes-plus@yahoogroups.com] On Behalf Of Randy Harmelink ...
Randy: Thanks for this additional information. Lionel From: quotes-plus@yahoogroups.com [mailto:quotes-plus@yahoogroups.com] On Behalf Of Randy Harmelink Sent:...
Allan: Thanks much. Lionel From: quotes-plus@yahoogroups.com [mailto:quotes-plus@yahoogroups.com] On Behalf Of Allan Wade Sent: Monday, September 03, 2007 6:07...
Lionel, I don't know if you are aware of the smf_addin forum on Yahoo Groups. This is a VERY useful add-in for Excel, allowing you to pull all sorts of stock ...
Donald: I was not aware of this Group. Thanks for this very valuable information. I have joined it. Regards Lionel PS. are you related to the famous aviator,...
Lionel, Glad you liked the smf_addin. I use it a lot in evaluating my stocks. I suggest you take a look at the files section and especially the User Downloaded...
You can speed that spreadsheet up significantly. As coded, you are using the RCHGetYahooQuotes() function to get each data item individually. That means you...
Randy, I see the value of the array entry for speed of download, but I want the capability of sorting the data on different columns, and my understanding is ...
Where do I find out about these commands like =RCHGetYahooQuotes(A3:A202,"ohgl1pb3b2a2") to access Yahoo Quotes? Lionel From: quotes-plus@yahoogroups.com...
Donald: You are correct, but I think that you can copy cells to another row/column and the array formula will not be copied. You can then operate on the new ...
True. Just don't sort the array-entered portion -- the array-entered formulas will recalculate quickly after you sort the column that includes the ticker...
Lionel, Go to the Files section of the smf_addin group, and grab all the documentation files. All the answers are there, although it occasionally requires a...
I have seen referances to the ability to directly import data from the QP database to Excel, but have not been able to find out how to do this. Can someone...
If you go to the SMF add-in Yahoo group: http://finance.groups.yahoo.com/group/smf_addin/ The add-in, documentation on its functions, and templates and...
Hi It's described in the help file. Just go to start - programs - quotes plus - QP Help File. Look in the Integration with Microsoft Excel section. Basically,...
Tools> Add-Ins, browse to QP's Excel subfolder and select qp21com.xla. Then select a cell, Insert> Function, (User Defined category), scroll down to the QP_xxx...
Randy: Thanks for this information. I took a quick look at this web site and I am sure that it will keep me out of mischief and off the streets for a while. J)...
Gary, Thanks, I found it and it works great. One question though. Several of the functions ask for a value DAY. The only thing that seems to work is an ...
Randy, Thanks. The second suggestion work fine. I just moved the array off to an unused section of the spreadsheet then referenced the cells in the active ...
hi, at the beginning of September I made a list of symbols that my system evaluates for entry. Today I find that 233 of these symbols are emptied out. It...
Hi Those are all dead symbols that were deleted. They didn't have current data, the last close was carried forward with 0 volume for them. Best regards, Gary...
hi, thanks. have they been deleted this week? Thanks, Ed ... From: gary To: quotes-plus@yahoogroups.com Sent: Wednesday, September 05, 2007 2:55 PM Subject:...
Hi They were deleted yesterday Best regards Gary ... From: Edward Pottasch To: quotes-plus@yahoogroups.com Sent: Wednesday, September 05, 2007 8:59 AM Subject:...
Gary: There was no data for !MUT yesterday. I just downloaded the morning updates. Can you check and see what happened? Thanks in advance. R/ Dennis ...
Howard, Thanks. That did exactly what I wanted. Donald F Lindberg ... From: quotes-plus@yahoogroups.com [mailto:quotes-plus@yahoogroups.com] On Behalf Of...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
