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...
946
Randy Harmelink
rharmelink
Jan 1, 2007 11:36 pm
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...
947
zordan.rm
Jan 2, 2007 2:25 pm
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...
948
zordan.rm
Jan 2, 2007 3:15 pm
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...
950
Randy Harmelink
rharmelink
Jan 2, 2007 8:11 pm
I don't know Italian, but here are examples of some formulas to get a few items off that page: ...
951
Randy Harmelink
rharmelink
Jan 2, 2007 8:32 pm
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...
952
bpeven
Jan 2, 2007 11:30 pm
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...
953
gauchogamesguy
Jan 3, 2007 12:00 am
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...
954
Randy Harmelink
rharmelink
Jan 3, 2007 1:40 am
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...
955
Randy Harmelink
rharmelink
Jan 3, 2007 3:12 am
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...
956
bpeven
Jan 3, 2007 6:29 pm
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...
957
Randy Harmelink
rharmelink
Jan 3, 2007 7:23 pm
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...
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...
961
Randy Harmelink
rharmelink
Jan 4, 2007 5:40 pm
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= ...
962
Don Guillett
donaldb36
Jan 4, 2007 5:49 pm
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,...
963
Ronald McEwan
ronmac17
Jan 4, 2007 10:03 pm
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...
964
maximon2013
Jan 7, 2007 2:21 pm
... 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...
965
Randy Harmelink
rharmelink
Jan 8, 2007 1:52 am
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...
966
JASON STOESS
dianejase
Jan 8, 2007 2:25 am
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...
967
Randy Harmelink
rharmelink
Jan 8, 2007 2:56 am
... 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...
968
JASON STOESS
dianejase
Jan 8, 2007 3:48 am
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...
969
Randy Harmelink
rharmelink
Jan 8, 2007 4:19 am
... 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...
970
Frank C Presson III
fpresson
Jan 8, 2007 4:30 am
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...
971
Alfred Tagher
tagtrade
Jan 8, 2007 5:21 am
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...
972
Randy Harmelink
rharmelink
Jan 8, 2007 7:10 am
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...
973
Alfred Tagher
tagtrade
Jan 8, 2007 8:06 am
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...
974
bpeven
Jan 8, 2007 3:01 pm
Randy, Can you post your Guru file that I've been asking about a billion questions about? Thanks ... formula ... ...
975
Randy Harmelink
rharmelink
Jan 8, 2007 7:58 pm
Uploaded as...
976
oaucamp
Jan 8, 2007 7:59 pm
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...