I'm having trouble understanding the use of element #851 Zack's Rank of Industry. When I pull the element data for BESTBUY (bby) I get the result of "49 of...
Elements #851 and #852 are "Rank of Industry" and "Rank Within Industry" rankings generated by the Zacks service themselves. Elements #13889 and #13890 are...
I could not get the 5-Count() to do what I wanted to do. My spreadsheet looks for 10 years of data. It is also keyed to the last year reported - 2006 or...
The Devil is in the details. Thanks. The Tools/References fixed me up. I was also able to unhide the Yahoo Historical Prices sheet. Ron Spruell ... ...
Randy - I have this running, but I am having strange Excel problems. I have the stand alone macro in the workbook. smfPricesBetween I have done the Tools >...
Randy - Excellent Tool! Thanks so much for developing this and please let me know if you take donations. This is my first day using the tool. I've been able...
Do you have any idea why the formula....=RCHGetElementNumber("txn", 956) would not work for the symbol TXN but will for any other symbol i type in.....??? On...
When I look at the MSN Money Purchase Information Page for a mutual fund I see a section with this information: Fees and Expenses Total Expense Ratio 1.92% ...
It's working fine for me. I have seen some messages on various forums over the weekend about parts of Yahoo not working correctly -- particularly the...
Boy, did you throw me for a loop. I looked and looked and looked on the web pages for a Redemption amount and couldn't find one. And then I realized you said...
... Absolutely NOT! It's a labor of love. I program because I enjoy it. ... I don't have many mutual fund elements preprogrammed, as I've never done much...
... I just spent some time looking all over Yahoo Finance and could not find it either! This is obviously an oversite on Yahoo's part. I'll try your solution...
Randy - I found the problem. The macro name. It likes to be called Module1. When I change the name to smfPricesBetween, the problems start. There must be...
When I change the macro name to RCH_SMF_PricesBetween, the next time I open Excel and make a change, Excel crashes. When I change the name to smfPricesBetween,...
Hello, I try to find the yahoo parameter for Volume, also for EPS est. and other values and it seems I can't locate them; is it anywhere a file with this...
As far as I know, that CAN'T be the problem. There must be something happening when you edit the VBA code. Is the workbook small? Can you upload it to the...
... I don't know which function you're talking about? But documentation for the functions can be found in the "Documentation" folder of the files area. If...
It looks like it would require some special programming. I could only find the data for the S&P 500 history section in an XLS data available from the Standard...
I looked at this spreadsheet and decided it would be too much work to do from free sources - and slow. Two sources of stock data in the database format are ...
... This is good to know. I will rename and make it an Add-In. In the mean time, I wrote 6 small spreadsheets and saved and ran each one. Disabled means that...
Hi Randy, been out for a while. Anwyay can I change it in the routine? The quote is just one thing. I download once a week several numbers (zacks ranks,...
There are ways to change the limits, but without testing the actual changes -- which means doing a LOT of downloading -- I'm not sure what other things might...
Randy, in message n° 1076 u explain how u can semi-automate a download of stock symbols. I was wondering ... Is there a way to somehow find out if symbols...
The Zacks screener (even the free one) can give you a list of stocks with options. That gives me a list of 3383 stocks right now. You should be able to get...
Hello Randy, is it possible to have that Value calculation done or downloaded with SMF? From my research this is considered a conservative calculation of a...
So far, I haven't had any luck getting data out of Java applications. Plus, I think I would need them to have an API to drive it ahead of time to fill in the...
In Column A (A3 to A64) I have stock ticker symbols. In Columns M and N I want the closing and adjusted closing prices as of a certain date. The values in M2...
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.
