Hi Does anybody know how to extract data from the stockhouse site for example: http://www.stockhouse.com/FinancialTools/sn_technicalanalysis.asp?symbol=MSFT I...
You're probably running into problems because they use framed web pages and the data you want is in a frame instead of in the source code of the URL you're...
How about an external query with a macro for variables and extraction of desired info to another sheet? Don Guillett Microsoft MVP Excel SalesAid Software ...
I don't think queries work properly with framed web pages. You'd still need to go to URL of the frame to get your table count to work correctly. Besides, why...
Randy: It appears the SmallCapCenter.com element numbers in file #9 are giving me "Error" the last few days on my SMF UD file. Any idea if the site is having...
Ahhh. It appears they moved to a new website name. An example: http://www.stockscores.com/quickreport.asp?ticker=MMM I'll upload a new smf-elements-9.txt to...
I'm using RCHGetYahooHistory, but would like to find a low-effort way to avoid @VALUE! appearing in place of the data whenever I make a small change / work...
Three possibilities: -- Copy and paste everything as values -- Turn off recalculation (problematic if you're just working offline) -- Write a VBA routine to do...
There is no automatic refresh of data, as the add-in was written for ad hoc data acquisition. But you can run the smfForceRecalculation macro to empty the...
Try this: =RCHGetTableCell("http://www.stockhouse.com/FinancialTools/sn_financials.asp?symbol=V.SGQ&asp=1",1,"Cash (MRQ)$") The problem with the original URL...
You're the best Randy - thank you EVER so much. - jps ... ("http://www.stockhouse.com/FinancialTools/sn_financials.asp? symbol=V.SGQ&asp=1",1,"Cash ... want. ...
I'd really like to be able to pull some liability data from stockhouse.com financials, but their table setup is INSANE. Any idea how I could formulate...
No insights here. I gave up on it last time someone asked. I can extract data, but not reliably. And even an EXCEL web query returns unusually formatted...
I'm trying to get a listing of all the symbols for a given Sector and Industry. I'm using Yahoo's Industry Index from -> http://biz.yahoo.com/ic/ind_index.html...
Can get convoluted but try this where you first establish the external query (change to refresh if looping urls).Then look for what you need using FIND....
Hi there, I just found this group today and am very excited to try and get the add in to work for me. I'm just wondering if there is a set of instructions for...
Thanks. I'll try these. From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink Sent: Thursday, October 02, 2008 6:06...
I've had people ask me about getting greeks and implied volatility for options in the past. I just stumbled across such options data at the Zacks site --...
Randy, first let me say like many others this add-in is fantastic and a real time saver. If I could ask a question in regards to refreshing the links. In some ...
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.
