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...
5182
estoymirandocotizacio...
estoymirando...
Oct 1, 2008 12:11 pm
I can´t search the coorect datas of the sapin quotes at the page http://es.finance.yahoo.com/ for example iberdrola. ...
5183
Randy Harmelink
rharmelink
Oct 1, 2008 3:05 pm
You would need to use the RCHGetTableCell() function to do the extractions. I don't have anything pre-defined for non-US web pages....
5184
Randy Harmelink
rharmelink
Oct 1, 2008 3:13 pm
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...
5185
MKK
estoymirando...
Oct 1, 2008 3:23 pm
So if i want de only the data of the market capitalizacion of ibe at http://es.finance.yahoo.com what can I do? De: smf_addin@yahoogroups.com...
5186
Don Guillett
donaldb36
Oct 1, 2008 3:45 pm
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...
5189
halandkeri
Oct 2, 2008 3:41 am
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...
5190
Randy Harmelink
rharmelink
Oct 2, 2008 3:58 am
It looks like the website has a new owner and different site content....
5191
Randy Harmelink
rharmelink
Oct 2, 2008 4:35 am
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...
5192
Randy Harmelink
rharmelink
Oct 2, 2008 4:49 am
Hmmm. It looks like the data -- more of the data? -- can be gotten from StockHouse. For example: ...
5193
Jeremy
jeremym72704
Oct 2, 2008 2:25 pm
i just downloaded your tool and looked at the docs but i did not see a refresh feature or timer?...
5194
tim_w_dittmer
Oct 2, 2008 2:25 pm
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...
5195
Randy Harmelink
rharmelink
Oct 2, 2008 3:17 pm
Three possibilities: -- Copy and paste everything as values -- Turn off recalculation (problematic if you're just working offline) -- Write a VBA routine to do...
5196
Randy Harmelink
rharmelink
Oct 2, 2008 3:22 pm
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...
5197
"What's in a...
jpsartrean
Oct 2, 2008 4:58 pm
I'm looking for a way to pull this element - Cash (MRQ)$ - from this page: http://www.stockhouse.com/tools/?page=%2FFinancialTools%2Fsn% ...
5198
Randy Harmelink
rharmelink
Oct 2, 2008 8:02 pm
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...
5199
"What's in a...
jpsartrean
Oct 2, 2008 8:19 pm
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. ...
5200
"What's in a...
jpsartrean
Oct 2, 2008 9:46 pm
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...
5201
Randy Harmelink
rharmelink
Oct 2, 2008 10:27 pm
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...
5202
kenncurry
Oct 2, 2008 10:42 pm
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...
5203
Don Guillett
donaldb36
Oct 2, 2008 11:01 pm
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....
5204
Randy Harmelink
rharmelink
Oct 2, 2008 11:06 pm
There are much easier ways to get sector/industry lists. For example: http://finviz.com/export.ashx?v=111&ft=1&ta=1&p=d&r=1 ...
5205
roasthawg
Oct 3, 2008 12:30 am
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...
5206
Randy Harmelink
rharmelink
Oct 3, 2008 12:30 am
Check the "Documentation" folder of the files area......
5207
Kenn Curry
kenncurry
Oct 3, 2008 12:51 am
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...
5208
Randy Harmelink
rharmelink
Oct 3, 2008 2:06 am
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 --...
5209
Mr. Duke Jones
sectorfund
Oct 3, 2008 4:38 pm
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 ...
5210
Mark Blessington
markblessing...
Oct 3, 2008 4:48 pm
Has anyone determined if the add-in is compatible with Excel for Mac?...