=RCHgetElementNumber($B3, 25), will not work when $B3= JJA, nor will =RCHgetElementNumber($B3,13862) when $B3=JJA for description However, for stock symbols...
3492
dab_mango
Feb 3, 2008 1:44 am
I was able to use RCHGetYahooQuotes for the same. Would like to understand however the difference, if someone has time, but not urgent. ... found...
3493
agundrum
Feb 3, 2008 11:51 am
The problem is that there is no P/E 5-year high or low for WAG from the web page you are retrieving the data from. This will make the Rule #1 formulas fail...
3494
carlh888
Feb 4, 2008 8:44 pm
I downloaded the original excel file from prof. Damodaran's web site and you can also see it Under upload by forum members. But can someone please explain how...
3495
dab_mango
Feb 5, 2008 3:44 am
How does one use RCHGetTableCell on following URL to access all the tables ? http://www.stockq.org/wide_en.php I tried using ...
3496
Matto
mattohume
Feb 5, 2008 5:12 am
Do you want complete tables or just certain cells. Complete tables via =rchgethtmltable($A$1,A2,-1,A2,1) array entered over a 6 col by 25 row range where A1 =...
3497
turley.muller
Feb 5, 2008 5:13 pm
Are you asking about Dr. Damodaran's ? or the the one in the files section that I uploaded ? The models are a little different....
3498
carlh888
Feb 5, 2008 5:55 pm
Turley, Thanks for the reply and I noticed the difference between Dr. Damodaran's and your. So I'm going to use yours to ask some questions if you don't mind. ...
3499
turley.muller
Feb 5, 2008 10:38 pm
Carl, The model calculates the equity risk premium of the market (Sp500) using: 1) Current Price 2) Expected Dividends 3) Expected Growth Rates Taking these...
3500
L.V.Gandhi
lvgandhi
Feb 6, 2008 2:12 am
I am accessing a web page in national stock exchange of India NSE by login and get a table in a frame. I could get the page link seeing a separate frame. The...
3501
carlh888
Feb 6, 2008 5:44 am
Turley, Thank you very much. I will let you know if I have further question. ... one ... g ... assumptions. ... for ... that ... next ... help. ... questions ...
3502
Richard Power
rpower0714
Feb 8, 2008 5:52 pm
Which is the best element number for getting the next dividend amount? Thanks in advance Richard...
3503
turley.muller
Feb 8, 2008 8:18 pm
Richard, "Next" dividend- are you asking for the future dividend for the next year?...
3504
Richard
rpower0714
Feb 8, 2008 8:28 pm
Yes ... an examble ... DD ex-dividend date is Feb 13 ... what I am looking for is the amount of the dividend for Feb 13 I hope this helps Richard ... From:...
3505
turley.muller
Feb 8, 2008 8:42 pm
1421-1512 will give you DPS data: Check the element definitions spreadsheet for the exact specifics. fyi, I noticed DD is a little tricky: they pay PS...
3506
Richard
rpower0714
Feb 8, 2008 8:48 pm
Thanks ... From: turley.muller To: smf_addin@yahoogroups.com Sent: Friday, February 08, 2008 3:42 PM Subject: [smf_addin] Re: Element Number 1421-1512 will...
3507
zordan.rm
Feb 10, 2008 4:28 pm
hi there, i donwloaded the zip file in C:\programs files\smf add-in i am using the formula =RCHGetElementNumber(B1,848) and also 543, 15011, 15010 B1 is a...
3508
zordan.rm
Feb 10, 2008 5:23 pm
... i found the issue...
3509
Praveen Bhatia
praveenkbhatia
Feb 15, 2008 3:43 pm
Is there a way I can closing price of 30 days ago using RCHGetYahooHistory? If not, which macro would do that?...
3510
turley.muller
Feb 16, 2008 3:47 am
You need closing price for a single day, 30 days days ago, or closing prices for the past 30 days? Both are easy to do....
3511
p.bhatia@...
praveenkbhatia
Feb 17, 2008 12:16 am
Closing price for a single day, 30 days ago. ... From: "turley.muller" <tmuller2@...> ... You need closing price for a single day, 30 days days ago, or...
3512
turley.muller
Feb 17, 2008 12:20 am
use =smfLastPrice(ticker,date) ... closing prices for...
3513
dab_mango
Feb 25, 2008 12:15 am
Has anyone heard from Randy ? It is very very unusual for him to disappear like this. I am concerned that something is wrong here ! I hope I am wrong and he is...
3514
turley.muller
Feb 25, 2008 3:07 pm
I have not heard anything, I have been wondering myself. It's troubling. He's been gone for a long while, when he usually was always around daily. I pray...
3515
Don Guillett
donaldb36
Feb 25, 2008 3:09 pm
As I recall, he is from the Phoenix area?????? Don Guillett Microsoft MVP Excel SalesAid Software dguillett1@... ... From: turley.muller To:...
3516
Alf Hind
alfhind
Feb 25, 2008 3:51 pm
His profile says St Paul, MN ... From: Don Guillett To: smf_addin@yahoogroups.com Sent: Monday, February 25, 2008 3:08 PM Subject: Re: [smf_addin] Re: Still...
3517
Matto
mattohume
Feb 25, 2008 4:09 pm
Yes, but he mentioned recently moving to AZ in a post on one of the newsgroups or perhaps in personal correspondence. Matt _____ From:...
3518
turley.muller
Feb 25, 2008 8:43 pm
Yeah, I am pretty sure he recently moved to the phoenix/scottsdale area....
3519
Don Guillett
donaldb36
Feb 25, 2008 9:06 pm
I looked on some of the people finders such as whitepages,anywho, etc and only found one in St. Paul. I called the number and left a message. Have no idea who...
3520
Randy Harmelink
rharmelink
Feb 29, 2008 3:28 am
I just got back tonight. I had a complete failure of the kidneys at the end of November. I have virtually no memory of December and January because I was...
