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...
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...
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...
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...
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, 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...
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...
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...
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...
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...
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...
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= ...
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,...
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...
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...
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...
... 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...
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...
... 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- 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...
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...
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...
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...
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...
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.
