smf_addin : Messages : 6681-6712 of 18759

Messages: Simplify \| Expand (Group by Topic)		Author	Sort by Date

6681		faitdumal	Jun 1, 2009 9:41 pm
	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...
6682		Randy Harmelink rharmelink	Jun 1, 2009 10:37 pm
	Try using the current version of the add-in. That message hasn't existed for quite some time......
6683		tonyfonda	Jun 2, 2009 3:38 pm
	Anyone can suggest a simple line to capture Yahoo live data feed? (price only. Most grateful. Tony...
6684		Randy Harmelink rharmelink	Jun 2, 2009 3:42 pm
	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...
6685		tonyfonda	Jun 2, 2009 9:57 pm
	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 ...
6687		Randy Harmelink rharmelink	Jun 2, 2009 10:06 pm
	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...
6688		Graham Jervis gajervis	Jun 3, 2009 7:39 am
	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...
6689		Randy Harmelink rharmelink	Jun 3, 2009 8:04 am
	The Fwallstreet workbook uses mostly MorningStar data elements. Those can't be retrieved unless you create an IE cookie for Morningstar -- basically, you just...
6690		Graham Jervis gajervis	Jun 3, 2009 8:17 am
	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...
6691		Graham Jervis gajervis	Jun 3, 2009 7:13 pm
	... 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...
6692		Graham Jervis gajervis	Jun 3, 2009 7:19 pm
	... Hi Randy, i simply got Google Chrome, the program works now. Thanks alot....
6693		Don Guillett donaldb36	Jun 3, 2009 7:25 pm
	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. ...
6694		truemavsfan	Jun 3, 2009 9:57 pm
	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....
6695		Randy Harmelink rharmelink	Jun 3, 2009 10:16 pm
	You could retrieve such data with the RCHGetTableCell() function. For example, the YTD performance can be retrieved with: =RCHGetTableCell(" ...
6696		nyemahame	Jun 4, 2009 12:02 am
	... I've loaded this page and checked my environment and the #NAME? still appears in the result column....
6697		Randy Harmelink rharmelink	Jun 4, 2009 12:36 am
	Do you have unresolved links? What does the formula look like? For example, see: http://finance.groups.yahoo.com/group/smf_addin/message/4918...
6698		Randy Harmelink rharmelink	Jun 4, 2009 12:45 am
	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"...
6699		stevenletzer	Jun 4, 2009 1:00 am
	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...
6700		Randy Harmelink rharmelink	Jun 4, 2009 1:59 am
	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...
6701		bwidensky	Jun 4, 2009 4:35 pm
	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...
6702		David Van Aken tambourman2001	Jun 4, 2009 7:29 pm
	I too am looking for this; if anyone knows. Thank you, Dave...
6703		Dave MacKay blaiserboy	Jun 5, 2009 3:56 am
	Perhaps open and fund a small account with Interactive Brokers Dave MacKay ... From: bwidensky <bwidensky@...> Subject: [smf_addin] Real time option...
6704		Ralph Bagwell ralphbag	Jun 5, 2009 12:34 pm
	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...
6705		Randy Harmelink rharmelink	Jun 5, 2009 1:43 pm
	Just run the smfForceRecalculation macro. I have it assigned to both a toolbar button and a keyboard shortcut....
6706		Larry Hill laurancehill	Jun 5, 2009 6:00 pm
	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 ...
6707		Randy Harmelink rharmelink	Jun 5, 2009 6:34 pm
	http://www.alltipsandtricks.com/how-to-assign-a-toolbar-button-to-a-macro-in-ms-excel...
6709		megaberrys66	Jun 6, 2009 1:07 pm
	Hi, For some reason, I have a problem with the Toronto main index OSPTX.TO in RCHGetYahooHistory - but not in RCHGetYahooQuotes. Entering ...
6710		Randy Harmelink rharmelink	Jun 6, 2009 1:12 pm
	Not a bug. The reason you have a problem is that Yahoo simply doesn't carry historical quotes for that ticker symbol. See: ...
6711		Don Guillett donaldb36	Jun 6, 2009 1:23 pm
	Historical Prices Get Historical Prices for: SET DATE RANGE Start Date: JanFebMarAprMayJunJulAugSepOctNovDec Eg. Jan 1, 2003 End Date:...
6712		Ralph Bagwell ralphbag	Jun 6, 2009 6:27 pm
	... Using Excel 2007 , you can also : "Run a macro by clicking a button on the Quick Access Toolbar" "help" tells you how. Ralph...

Yahoo! Groups

Group Information

Yahoo! Groups Tips

Did you know...

Messages