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...
Message search is now enhanced, find messages faster. Take it for a spin.

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 945 - 976 of 7948   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
945
Hi there, First of all let me thank you for this wonderful tool. I just ran element 15012 on GOOG and it gives me 1111.12 however the latest rule #1 MOS...
zordan.rm
Offline Send Email
Jan 1, 2007
10:49 pm
946
The SMF version is just a simple one that doesn't look at multiple sources for the various data items. It just uses: -- Average of "5-year High P/E" and...
Randy Harmelink
rharmelink
Offline Send Email
Jan 1, 2007
11:36 pm
947
Hi again, I'm interested in trading Italian stocks because virtually nobody does value investing in Italy and the market is far from efficient therefore the...
zordan.rm
Offline Send Email
Jan 2, 2007
2:25 pm
948
I found an even better data source for value ratios: http://www.borse.it/Scheda.php?ID=163 All the stocks quoted in italy will have a progressive ID's and each...
zordan.rm
Offline Send Email
Jan 2, 2007
3:15 pm
950
I don't know Italian, but here are examples of some formulas to get a few items off that page: ...
Randy Harmelink
rharmelink
Offline Send Email
Jan 2, 2007
8:11 pm
951
For some reason, that URL doesn't work for the XMLHTTP protocol. It errors out and doesn't return the source code of the web page. No idea why. It looks like...
Randy Harmelink
rharmelink
Offline Send Email
Jan 2, 2007
8:32 pm
952
Randy, I once again picked up this mini-project, and the sample template that you created is working for me -- I'm able to pull in Industry and Sub Industry...
bpeven
Offline Send Email
Jan 2, 2007
11:30 pm
953
So how do you discover the parameters? For example, on the site we were discussing, how did you discover that b = base currency, etc.? I have a couple other...
gauchogamesguy
Online Now Send Email
Jan 3, 2007
12:00 am
954
My first cut is two different ways: 1. Examine the HTML coding for the form 2. Use a bookmarklet (a.k.a. favelet) to expose the parameters For (1), if I look...
Randy Harmelink
rharmelink
Offline Send Email
Jan 3, 2007
1:40 am
955
I played around with the RCHGetWebData() function on the George Soros holdings (he had a bunch). From that data, I was able to extract the industry number...
Randy Harmelink
rharmelink
Offline Send Email
Jan 3, 2007
3:12 am
956
That works great, and it's actually a fairly complete list of industries. Now, if I want to make a list of ALL holdings, how do I reference second and third...
bpeven
Offline Send Email
Jan 3, 2007
6:29 pm
957
Hmm? You'd just set up additional formulas based on the URL of each page, adding the additional parameter. In essence, that's what I did to get the industry...
Randy Harmelink
rharmelink
Offline Send Email
Jan 3, 2007
7:23 pm
958
http://online.wsj.com/mdc/public/page/marketsdata.html?mod=mdc_topnav_2_3 000...
Ronald McEwan
ronmac17
Offline Send Email
Jan 3, 2007
7:54 pm
960
Damn, this is so frustrating. I feel like I'm asking questions that I should be able to figure out on my own. You understood my question perfectly, and...
bpeven
Offline Send Email
Jan 4, 2007
4:36 pm
961
If A1 contains the Guru name and A2 contains the page number, the formula would be: =RCHGetTableCell("http://www.gurufocus.com/holdings.php?GuruName="&A1&"&p= ...
Randy Harmelink
rharmelink
Offline Send Email
Jan 4, 2007
5:40 pm
962
Sub makenamelist() lr = Cells(Rows.Count, "I").End(xlUp).Row For Each c In Range("i2:i" & lr) mylist = mylist & "," & c Next c mylist = Right(mylist,...
Don Guillett
donaldb36
Offline Send Email
Jan 4, 2007
5:49 pm
963
SEC revisits ruling on market data fees The Securities and Exchange Commission will review its decision to allow markets to charge fees for formerly free stock...
Ronald McEwan
ronmac17
Offline Send Email
Jan 4, 2007
10:03 pm
964
... Payments" table is filed ... Greetings, I also had the same problem. Here are some symbols: PFE VZ MO T C MRK GM DD GE JPM Best to all, JC...
maximon2013
Offline Send Email
Jan 7, 2007
2:21 pm
965
Will be fixed in the next release. When I looked at PFE, it was because there was no "Splits" table on the page. The element extract was looking for the...
Randy Harmelink
rharmelink
Offline Send Email
Jan 8, 2007
1:52 am
966
Hello Randy, I have been looking and testing your TA functions. WOW, I am so impressed with how compact your algorithms are. I have a few questions if you...
JASON STOESS
dianejase
Offline Send Email
Jan 8, 2007
2:25 am
967
... with how ... Thanks. I was going for sweet and simple. ... close are the ... on these ... I think the error actually is when High and Low match, because...
Randy Harmelink
rharmelink
Offline Send Email
Jan 8, 2007
2:56 am
968
Passing the EMA would be a good idea I agree since it is used in many functions. Have you looked into the Bollinger functions since they are such a widely...
JASON STOESS
dianejase
Offline Send Email
Jan 8, 2007
3:48 am
969
... Bollinger bands wouldn't be difficult. It's all there already anyway. Just use either the SMA, EMA, or linear regression to get your midpoint, then the...
Randy Harmelink
rharmelink
Offline Send Email
Jan 8, 2007
4:19 am
970
Randy- I really appreciate your willingness to share your code with the public. These ideas are of great value to me. Many thanks. Your last comment below is...
Frank C Presson III
fpresson
Offline Send Email
Jan 8, 2007
4:30 am
971
Hi Randy, Would you share some ideas on the parallels between gambling, horse racing and the markets. Especially in the area of proper bet sizing. Kind...
Alfred Tagher
tagtrade
Offline Send Email
Jan 8, 2007
5:21 am
972
Proper bet sizing for horse racing is relatively easy with Kelly wagering. Basically, it calculates your bet size based on four factors: -- The fair return...
Randy Harmelink
rharmelink
Offline Send Email
Jan 8, 2007
7:10 am
973
Hi Randy, Many thanks for your detailed response. a very good book on the subject is Gambling Wizards by Richard Munchkin. kind regards, Alfred ... From: Randy...
Alfred Tagher
tagtrade
Offline Send Email
Jan 8, 2007
8:06 am
974
Randy, Can you post your Guru file that I've been asking about a billion questions about? Thanks ... formula ... ...
bpeven
Offline Send Email
Jan 8, 2007
3:01 pm
975
Uploaded as...
Randy Harmelink
rharmelink
Offline Send Email
Jan 8, 2007
7:58 pm
976
Hi Randy I use the yahoohistory function to populate a few data sheets. The formula I use is one you gave me a while back that enables me to retrieve the last...
oaucamp
Offline Send Email
Jan 8, 2007
7:59 pm
Messages 945 - 976 of 7948   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