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...
Hear how Yahoo! Groups has changed the lives of others. Take me there.

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 5181 - 5210 of 7953   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
5181
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...
kaloyan_kolew
Offline Send Email
Oct 1, 2008
11:16 am
5182
I can´t search the coorect datas of the sapin quotes at the page http://es.finance.yahoo.com/ for example iberdrola. ...
estoymirandocotizacio...
estoymirando...
Offline Send Email
Oct 1, 2008
12:11 pm
5183
You would need to use the RCHGetTableCell() function to do the extractions. I don't have anything pre-defined for non-US web pages....
Randy Harmelink
rharmelink
Offline Send Email
Oct 1, 2008
3:05 pm
5184
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...
Randy Harmelink
rharmelink
Offline Send Email
Oct 1, 2008
3:13 pm
5185
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...
MKK
estoymirando...
Offline Send Email
Oct 1, 2008
3:23 pm
5186
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 ...
Don Guillett
donaldb36
Offline Send Email
Oct 1, 2008
3:45 pm
5187
Something like: =RCHGetTableCell("http://es.finance.yahoo.com/q?s=ibe&m=MC",1,"Capitalización:")...
Randy Harmelink
rharmelink
Offline Send Email
Oct 1, 2008
5:48 pm
5188
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 Harmelink
rharmelink
Offline Send Email
Oct 1, 2008
5:53 pm
5189
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...
halandkeri
Offline Send Email
Oct 2, 2008
3:41 am
5190
It looks like the website has a new owner and different site content....
Randy Harmelink
rharmelink
Offline Send Email
Oct 2, 2008
3:58 am
5191
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...
Randy Harmelink
rharmelink
Offline Send Email
Oct 2, 2008
4:35 am
5192
Hmmm. It looks like the data -- more of the data? -- can be gotten from StockHouse. For example: ...
Randy Harmelink
rharmelink
Offline Send Email
Oct 2, 2008
4:49 am
5193
i just downloaded your tool and looked at the docs but i did not see a refresh feature or timer?...
Jeremy
jeremym72704
Online Now Send Email
Oct 2, 2008
2:25 pm
5194
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...
tim_w_dittmer
Offline Send Email
Oct 2, 2008
2:25 pm
5195
Three possibilities: -- Copy and paste everything as values -- Turn off recalculation (problematic if you're just working offline) -- Write a VBA routine to do...
Randy Harmelink
rharmelink
Offline Send Email
Oct 2, 2008
3:17 pm
5196
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...
Randy Harmelink
rharmelink
Offline Send Email
Oct 2, 2008
3:22 pm
5197
I'm looking for a way to pull this element - Cash (MRQ)$ - from this page: http://www.stockhouse.com/tools/?page=%2FFinancialTools%2Fsn% ...
"What's in a name? Th...
jpsartrean
Offline Send Email
Oct 2, 2008
4:58 pm
5198
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...
Randy Harmelink
rharmelink
Offline Send Email
Oct 2, 2008
8:02 pm
5199
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. ...
"What's in a name? Th...
jpsartrean
Offline Send Email
Oct 2, 2008
8:19 pm
5200
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...
"What's in a name? Th...
jpsartrean
Offline Send Email
Oct 2, 2008
9:46 pm
5201
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...
Randy Harmelink
rharmelink
Offline Send Email
Oct 2, 2008
10:27 pm
5202
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...
kenncurry
Offline Send Email
Oct 2, 2008
10:42 pm
5203
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....
Don Guillett
donaldb36
Offline Send Email
Oct 2, 2008
11:01 pm
5204
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 ...
Randy Harmelink
rharmelink
Offline Send Email
Oct 2, 2008
11:06 pm
5205
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...
roasthawg
Offline Send Email
Oct 3, 2008
12:30 am
5206
Check the "Documentation" folder of the files area......
Randy Harmelink
rharmelink
Offline Send Email
Oct 3, 2008
12:30 am
5207
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...
Kenn Curry
kenncurry
Offline Send Email
Oct 3, 2008
12:51 am
5208
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 Harmelink
rharmelink
Offline Send Email
Oct 3, 2008
2:06 am
5209
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 ...
Mr. Duke Jones
sectorfund
Offline Send Email
Oct 3, 2008
4:38 pm
5210
Has anyone determined if the add-in is compatible with Excel for Mac?...
Mark Blessington
markblessing...
Offline Send Email
Oct 3, 2008
4:48 pm
Messages 5181 - 5210 of 7953   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