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...
Want your group to be featured on the Yahoo! Groups website? Add a group photo to Flickr.

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 6681 - 6712 of 7919   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
6681
I receive the same error on my new vista laptop. It works perfectly fine on my old machine. I installed it in exactly the same way. Any idea why this might...
faitdumal
Offline Send Email
Jun 1, 2009
9:41 pm
6682
Try using the current version of the add-in. That message hasn't existed for quite some time......
Randy Harmelink
rharmelink
Offline Send Email
Jun 1, 2009
10:37 pm
6683
Anyone can suggest a simple line to capture Yahoo live data feed? (price only. Most grateful. Tony...
tonyfonda
Offline Send Email
Jun 2, 2009
3:38 pm
6684
It's my understanding that if you are signed up for the Yahoo real-time quotes and have created the IE security cookie, the RCHGetYahooQuotes() function does...
Randy Harmelink
rharmelink
Offline Send Email
Jun 2, 2009
3:42 pm
6685
Thanks for that, but my quest is much simpler: Yahoo seems to offer a free "streaming quote", as can be seen on this page for the FTSE ...
tonyfonda
Offline Send Email
Jun 2, 2009
9:57 pm
6687
The add-in won't be able to help you. It grabs web page source code and extracts data from it. The data from the live streaming quote you're referring to is...
Randy Harmelink
rharmelink
Offline Send Email
Jun 2, 2009
10:06 pm
6688
Hi Randy, i installed your SMF Add-In into excel, then i downloaded the Fwallstreet_model excel program, however, all i am getting is errors. However, what is...
Graham Jervis
gajervis
Offline Send Email
Jun 3, 2009
7:39 am
6689
The Fwallstreet workbook uses mostly MorningStar data elements. Those can't be retrieved unless you create an IE cookie for Morningstar -- basically, you just...
Randy Harmelink
rharmelink
Offline Send Email
Jun 3, 2009
8:04 am
6690
Hi Again folks, this is very confusing, i download the SMF add-in, created a folder in C program files. then i opened a blank excel sheet, attached the add in...
Graham Jervis
gajervis
Offline Send Email
Jun 3, 2009
8:17 am
6691
... Thanks Randy, where can i find this excel web querry? Conveniently, with this new Windows IE8 when i go to Morningstar, the page crashes, i cant believe...
Graham Jervis
gajervis
Offline Send Email
Jun 3, 2009
7:13 pm
6692
... Hi Randy, i simply got Google Chrome, the program works now. Thanks alot....
Graham Jervis
gajervis
Offline Send Email
Jun 3, 2009
7:19 pm
6693
I don't know what url you are using but I just copied this one into a new external query and it loaded just fine. ...
Don Guillett
donaldb36
Offline Send Email
Jun 3, 2009
7:25 pm
6694
Is there a link to individual stock performance YTD, etc. via morningstar? I am new to this add-in and still trying to figure things out. Thanks....
truemavsfan
Offline Send Email
Jun 3, 2009
9:57 pm
6695
You could retrieve such data with the RCHGetTableCell() function. For example, the YTD performance can be retrieved with: =RCHGetTableCell(" ...
Randy Harmelink
rharmelink
Offline Send Email
Jun 3, 2009
10:16 pm
6696
... I've loaded this page and checked my environment and the #NAME? still appears in the result column....
nyemahame
Offline Send Email
Jun 4, 2009
12:02 am
6697
Do you have unresolved links? What does the formula look like? For example, see: http://finance.groups.yahoo.com/group/smf_addin/message/4918...
Randy Harmelink
rharmelink
Offline Send Email
Jun 4, 2009
12:36 am
6698
When in EXCEL, the keyboard shortcut to bring up the EXCEL Web Query is alt-d, d, w. Enter "morningstar.com" into the address and then click on the "Go"...
Randy Harmelink
rharmelink
Offline Send Email
Jun 4, 2009
12:45 am
6699
Can you help me capture data from http://emma.msrb.org/default.aspx ? This is the web site for municipal bond data. At the Muni Search field, the CUSIP is...
stevenletzer
Offline Send Email
Jun 4, 2009
1:00 am
6700
Unfortunately, none of the data is in tables, so you'd need to extract the data out of the web page using the RCHGetWebData() function. Easiest to do with...
Randy Harmelink
rharmelink
Offline Send Email
Jun 4, 2009
1:59 am
6701
Is there a service (free or subscription based) that I can used to download real time option bids and asks? I thought subscribing to real-time yahoo quotes...
bwidensky
Online Now Send Email
Jun 4, 2009
4:35 pm
6702
I too am looking for this; if anyone knows. Thank you, Dave...
David Van Aken
tambourman2001
Offline Send Email
Jun 4, 2009
7:29 pm
6703
Perhaps open  and fund a small account with Interactive Brokers Dave MacKay  ... From: bwidensky <bwidensky@...> Subject: [smf_addin] Real time option...
Dave MacKay
blaiserboy
Offline Send Email
Jun 5, 2009
3:56 am
6704
I use this: =RCHCreateComment("http://www.weblinks247.com/indexes/idx24_usd_en_2.gif",99,200,150,1) And several other Kitco small charts and it works just...
Ralph Bagwell
ralphbag
Offline Send Email
Jun 5, 2009
12:34 pm
6705
Just run the smfForceRecalculation macro. I have it assigned to both a toolbar button and a keyboard shortcut....
Randy Harmelink
rharmelink
Offline Send Email
Jun 5, 2009
1:43 pm
6706
Randy, How do you assign a macro to a toolbar button? Larry ... From: Randy Harmelink To: smf_addin@yahoogroups.com Sent: Friday, June 05, 2009 6:42 AM ...
Larry Hill
laurancehill
Offline Send Email
Jun 5, 2009
6:00 pm
6707
http://www.alltipsandtricks.com/how-to-assign-a-toolbar-button-to-a-macro-in-ms-excel...
Randy Harmelink
rharmelink
Offline Send Email
Jun 5, 2009
6:34 pm
6709
Hi, For some reason, I have a problem with the Toronto main index OSPTX.TO in RCHGetYahooHistory - but not in RCHGetYahooQuotes. Entering ...
megaberrys66
Offline Send Email
Jun 6, 2009
1:07 pm
6710
Not a bug. The reason you have a problem is that Yahoo simply doesn't carry historical quotes for that ticker symbol. See: ...
Randy Harmelink
rharmelink
Offline Send Email
Jun 6, 2009
1:12 pm
6711
Historical Prices Get Historical Prices for: SET DATE RANGE Start Date: JanFebMarAprMayJunJulAugSepOctNovDec Eg. Jan 1, 2003 End Date:...
Don Guillett
donaldb36
Offline Send Email
Jun 6, 2009
1:23 pm
6712
... Using Excel 2007 , you can also : "Run a macro by clicking a button on the Quick Access Toolbar" "help" tells you how. Ralph...
Ralph Bagwell
ralphbag
Offline Send Email
Jun 6, 2009
6:27 pm
Messages 6681 - 6712 of 7919   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