Search the web
Sign In
New User? Sign Up
smf_addin · EXCEL Stock Market Functions Add-in
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Show off your group to the world. Share a photo of your group with us.

Best of Y! Groups

   Check them out and nominate your group.
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.

Messages

  Messages Help
Advanced
Messages 2601 - 2630 of 7926   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
2601
Your problem is the "Low" is not a sufficient placement string to find the table you are trying to get. Try this, array-entering it over 5 columns and ... ...
Randy Harmelink
rharmelink
Offline Send Email
Sep 3, 2007
8:44 am
2602
Another attempt at non-wrapping formulas for grabbing 52-week lows: =RCHGetHTMLTable("http://quote.morningstar.com/highlow.html",">Today's 52-week...
Randy Harmelink
rharmelink
Offline Send Email
Sep 3, 2007
8:46 am
2603
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the smf_addin group. File : /Uploads by...
smf_addin@yahoogroups...
Send Email
Sep 3, 2007
8:54 am
2604
I'm getting odd dividend yield values for some tickers. For example: =RCHGetYahooQuotes("FDC","y") returns 58.04, and MO has a yield of 36.28. Most other...
wabmester
Offline Send Email
Sep 4, 2007
7:55 am
2605
Those numbers appear to be correct, more or less. The reason the numbers appear so unusual is that they are the TRAILING dividend amount and yield, inflated...
Randy Harmelink
rharmelink
Offline Send Email
Sep 4, 2007
8:31 am
2606
does anyone know if yahoo, etc allows us to use these functions for "bulk downloads". i am not talking about abusing the system with bulk stock updates ...
sergeh3
Offline Send Email
Sep 5, 2007
3:48 pm
2607
probably not - for example, they limit individual quote retrieves to 200 I think. what do you mean by BULK Downloads? Marty ... From: sergeh3...
Martin Topper
mtopper
Offline Send Email
Sep 5, 2007
5:31 pm
2608
Just curious, I couldnt get the non-wrapping formulas to work either.... did they happen to work for you?...
troypahrrk
Offline Send Email
Sep 5, 2007
6:06 pm
2609
I just went to the Yahoo group, brought up the second message with the non-wrapping formulas (in a table), then cut and pasted them one by one. All of them...
Randy Harmelink
rharmelink
Offline Send Email
Sep 5, 2007
6:23 pm
2610
=RCHGetHTMLTable("http://quote.morningstar.com/highlow.html",">Today's 52-week Lows",1,"",2) The above formula worked for me. (Don't forget, it must be array...
Martin Topper
mtopper
Offline Send Email
Sep 5, 2007
6:23 pm
2611
Thanks for that followup, I was able to get it to work after I reopened excel and visited the Morningstar site.... I think the cookie, etc. must have been what...
troypahrrk
Offline Send Email
Sep 5, 2007
9:12 pm
2612
Given the number of tools that use the Yahoo current quotes interface, I doubt they have a problem with it. But, as mentioned, they do limit it to 200 tickers...
Randy Harmelink
rharmelink
Offline Send Email
Sep 5, 2007
11:04 pm
2613
There have been short discussions of parsing SEC filings in the past. In general, my view is that it would be a waste of effort because of the changes that may...
Randy Harmelink
rharmelink
Offline Send Email
Sep 5, 2007
11:11 pm
2614
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the smf_addin group. File : /Add-In...
smf_addin@yahoogroups...
Send Email
Sep 6, 2007
1:03 am
2615
Overview of changes for version 2.0f: -- Added parm to RCHGetYahooQuotes() function to allow refreshing of quotes when spreadsheet recalculates -- Fixed...
Randy Harmelink
rharmelink
Offline Send Email
Sep 6, 2007
1:32 am
2616
What is the password used to extract the zip file? Thanks, Jan-Erik ... supplementary files. You would extract all of the files into the "C:\Program Files\SMF...
Jan-Erik Fougli
jefougli
Offline Send Email
Sep 6, 2007
4:39 am
2617
??? It's not password protected. I just tried it and it never asked for a password....
Randy Harmelink
rharmelink
Offline Send Email
Sep 6, 2007
4:45 am
2618
I got it now, not sure what was going on the last time. Thanks, Jan-Erik ... a password....
Jan-Erik Fougli
jefougli
Offline Send Email
Sep 6, 2007
5:34 am
2619
You can write a macro to loop 200 at a time. I recently did this for a client for currency trading history at 200 0 at a time. I did say 2000 days of currency...
Don Guillett
donaldb36
Offline Send Email
Sep 6, 2007
6:52 am
2620
The limit of 200 is on the number of ticker symbols for a current quotes request using the RCHGetYahooQuotes() function. The only limit on the amount of...
Randy Harmelink
rharmelink
Offline Send Email
Sep 6, 2007
7:23 am
2621
Thank you everyone for your help, and above all your patience. ... interface, ... limit ... function ... I ... RCHGetElementNumber() ... retrieve ... speeds ...
sergeh3
Offline Send Email
Sep 6, 2007
11:58 am
2622
Hi Randy! I've been distracted this last week and have not been able to attempt to get my spreadsheet running again until now. To refresh your memory my system...
Tim
timbabear
Offline Send Email
Sep 6, 2007
1:38 pm
2623
A further update.... When I opened Excel, on the blank notebook it automatically opens, I went to TOOLS==>ADD-INS==>BROWSE then went to the Program Files\SMF ...
Tim
timbabear
Offline Send Email
Sep 6, 2007
3:18 pm
2624
The problem is that when you save an EXCEL workbook that uses an add-in function, it saves a hard-coded path to the location of the add-in. It appears you...
Randy Harmelink
rharmelink
Offline Send Email
Sep 6, 2007
3:24 pm
2625
... Thank you! I did find a workaround: =(RCHGetYahooQuotes(K5,pTwo))*100/100 Excel treats the text return correctly as a number in the above formula. Of...
edgarmusgrove
Offline Send Email
Sep 6, 2007
3:39 pm
2626
WHOOOOOOOOO HOOOOOOOOOOOOOOOOOOOO!!!!!!!!!!!!!!!!!!!!!!!!!! THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU As you might by now suspect, it is...
Tim
timbabear
Offline Send Email
Sep 6, 2007
5:10 pm
2627
Is anyone having trouble getting yahoo quotes the past couple of days? I've been using this add-in for about 6 months and it stopped working yesterday. The...
troygaunt
Offline Send Email
Sep 6, 2007
5:39 pm
2628
Hi I have been working of RCH function from last one month. I found it very usful in facilitating my work But i am not able to retrive data for the following...
madaan.nitin
Offline Send Email
Sep 6, 2007
7:18 pm
2629
Secondly from this i want to know whether we can change source of information or not Like Yahoo Finance apart from Google finance I think there are element...
Martin Topper
mtopper
Offline Send Email
Sep 6, 2007
7:44 pm
2630
It's erroring out because Google keeps changing the page layout. It still works most of the time for me, but I had to switch the process over to use the IE...
Randy Harmelink
rharmelink
Offline Send Email
Sep 6, 2007
8:13 pm
Messages 2601 - 2630 of 7926   Oldest  |  < Older  |  Newer >  |  Newest
Advanced
Add to My Yahoo!      XML What's This?

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help