Hey thanks for all the help, Is there anything special I need to do to try and get this working? I paste your code in and nothing happens. Should I run the ...
1550
Randy Harmelink
rharmelink
Apr 14, 2007 11:06 pm
I'm not sure that's so easy. I don't see anything in the URL of the image that is a straight-forward use of ticker symbol or time period. But you might be...
1549
Randy Harmelink
rharmelink
Apr 14, 2007 9:57 pm
It looks to me like there is no longer an Italian quotes server. For example, you said: ...
1548
Thierry Vaccari
thierry_vaccari
Apr 14, 2007 9:19 pm
Hi Randy, I use your function in some code. They worked perfectly until yesterday. The line of my code where problem start is: lData =...
1547
dfaris1
Apr 14, 2007 6:01 pm
AH HA now we are getting someplace. Thank you. Now one more question, how do I change this link so it will use the stock symbol in the A colume to select the...
1546
Randy Harmelink
rharmelink
Apr 14, 2007 5:39 pm
Ahhhh...I was looking at the wrong template. Ok. In order to get the collapse/expand image function, you need to do this: 1. Create a cell with the URL of the...
1545
Randy Harmelink
rharmelink
Apr 14, 2007 5:27 pm
I'm also an AAII lifetime member. SIPro is one of the more comprehensive screeners out there, unless you start getting into the real costly ones. The biggest...
1544
dfaris1
Apr 14, 2007 4:57 pm
Well When I copy paste this formula into excel it gives me what looks like a hyperlink. When I click on it it asks if I want to open the PNG file. If I say it...
1543
Randy Harmelink
rharmelink
Apr 14, 2007 4:34 pm
I don't see how that formula can possibly give you a link? The only thing I can think of is that you mean it only shows up when you do a rollover, like a...
1542
dfaris1
Apr 14, 2007 3:15 pm
Yes I'm just asking how to do this. If i put this formula in my sheet all i get is a link. I'm trying to figure out how to do it like the example in the files...
1541
Randy Harmelink
rharmelink
Apr 14, 2007 2:25 pm
Are you just asking how to do this? =RCHCreateComment("http://www.schaeffersresearch.com/ChartFX62/Temp/CFT0414_10201009181.png",99)...
1540
kilo1994
Apr 14, 2007 1:12 pm
Randy, Do you use it? Can you give your impression of the program? I've been a lifetime member of AAII, and I use the Shadow Stock Portfolio in my IRA. I...
1539
dfaris1
Apr 14, 2007 6:45 am
Hello, I have been trying to work with an example file you have that gets a Volitility chart and lets us click on the chart to expand it. I would like to use...
1538
Lists
sectorfund
Apr 13, 2007 3:38 pm
Randy, I am a recently new user of your add-ins am still trying to learn the ropes. However, I am always looking for new ways to pull and manipulate data from...
1537
infochuck
Apr 13, 2007 2:42 pm
Yup, I use it. As to the second question: I can't say I'd have an immediate use for such a function, but if one existed I'm sure I'd find something! Let me...
1536
Randy Harmelink
rharmelink
Apr 13, 2007 7:07 am
Several question on the product: 1. Anyone in the group using it? 2. Anyone interested in having an SMF function to access its data? I think I have a routine...
1535
pengjingyi
Apr 12, 2007 8:40 pm
This is exactly what I am looking for, thank you! Jingyi ... history ... split...
1534
Randy Harmelink
rharmelink
Apr 12, 2007 1:15 am
Funny you should ask. I just created a sample worksheet for someone the other day that grabs the raw data and the dividend- and split-adjusted data from Yahoo...
1533
pengjingyi
Apr 12, 2007 12:46 am
Since the split/dividend adjusted data keeps changing from time to time, it would be more conveniet to download dividend and split history seperately and...
1532
leslie.huff
Apr 10, 2007 12:31 pm
Thanks, I'll give this a try. I've been out of town and just got time to read this and respond. The options on futures expire one month before the futures...
1531
Randy Harmelink
rharmelink
Apr 10, 2007 3:56 am
... are. ... I didn't see this ... Yahoo page and if so ... I do have some documentation on available codes in the files area of the group: 3.0 -...
1530
Linda
ladyamom
Apr 10, 2007 3:37 am
I've been reading the posts. I don't follow them all yet because I've just recently started with excel add ins. I use to do quite a bid of dos basic...
1529
Matto
mattohume
Apr 9, 2007 4:57 am
Randy: Sorry for the delay in this response. I kinda fell off the end of the world and March was a blur. Yes, the RCHGetTableCell would work on those pages to...
1528
bob warasila
lswpubrlw
Apr 9, 2007 1:24 am
OK that works for me now. The l.c. l got changed to a cap L for some reason and the price retrieve didn't work. I changed it to a l.c. and everything was...
1527
bob warasila
lswpubrlw
Apr 8, 2007 11:19 pm
Just tried that. It prints out the stock symbol in A7. Bob ... From: Richard To: smf_addin@yahoogroups.com Sent: Sunday, April 08, 2007 2:57 PM Subject: Re:...
1526
Richard
rpower0714
Apr 8, 2007 6:57 pm
I believe it should be this ... =RCHGetYahooQuotes(A7,"l1") Richard ... From: lswpubrlw To: smf_addin@yahoogroups.com Sent: Sunday, April 08, 2007 2:49 PM ...
1525
Randy Harmelink
rharmelink
Apr 8, 2007 6:56 pm
The second parameter is a string. It's not the number eleven, but the lower case letter "L" followed by the number one -- "l1". In some fonts, the lower case...
1524
lswpubrlw
Apr 8, 2007 6:49 pm
I'm having some problems using this function on my asset SS. I'm using the following statement in a cell: =RCHGetYahooQuotes(A7,11) I'm looking for the last...
1523
dfaris1
Apr 7, 2007 11:29 pm
This is very nice and works great. I have it working just the way I want. Thank you very much for the help and the formula. There is no way I could have...
1522
Randy Harmelink
rharmelink
Apr 7, 2007 10:23 pm
These seems to work for most: =VALUE(RCHGetWebData("http://www.ivolatility.com/calc/calc.j?frm&ticker="&A1,"""vola""",5,57)) Note that if you use a non-numeric...
