9 New Messages
Digest #2559
Messages
Sun Mar 24, 2013 7:38 am (PDT) . Posted by:
"rr76012" rr76012
1. Randy, Since I do not the most recent version add-in, should I update?
2. I am using symbol "INTC for Intel.
3. I existed, and restarted excel and still got the error message.
4. Yes, I see the MSN webpage when I plug in the url that you gave me from the previous message into excel : Data, Get external, from web page?
This message pops up when I plugged in your url:
"Do you want to view only the webpage content that was delivered securely?
This webpage contains content that will not be delivered using a secure HTTPS connection, which could compromise the security of the entire webpage."
you have to choice: Yes or NO.
I choosed, NO.
Randy, =rchgetelementnumber($E$2,B29), instead of saying "Error" in the cell, I now get this message "#NAME?"in the excel cell.
Beta =rchgetelementnumber($E$2,24) =#NAME?
Last Price =rchgetelementnumber($E$2,25)=#NAME?
52 Week Low =rchgetelementnumber($E$2,33)=#NAME?
52 Week High =rchgetelementnumber($E$2,34)=#NAME?
Thanks,
Rene
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Not the most recent version of the add-in, but the element definitions look
> correct.
>
> What ticker symbols are returning "Error"?
>
> If you exit and restart EXCEL, do you still get "Error" on those elements?
> How about with ticker "MMM"?
>
> Do you see a reasonable web page, filled with data, when you visit this URL
> with the EXCEL Web Query dialog:
>
> http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=MMM
>
> On Thu, Mar 21, 2013 at 9:06 AM, rr76012 <rr76012@...> wrote:
>
> > Hello Randy, I plugged your formulas into the spreadsheet, here are the
> > answers I got.
> >
> > 1. Stock Market Functions add-in, Version 2.1.2012.01.30 (C:\Program
> > Files\SMF Add-In; 1)
> >
> > 2. MSN;Financial Highlights -- Return on Equity;
> > http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;FINANCIALHIGHLIGHTS;RETURN ON EQUITY; ; ;0;0;0;0
> >
> > 3. MSN;Financial Highlights -- Earnings/Share;
> > http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;FINANCIALHIGHLIGHTS;EARNINGS/SHARE; ; ;0;0;0;0
> >
> > 4. MSN;Financial Highlights -- Book Value/Share;
> > http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;FINANCIALHIGHLIGHTS;BOOK VALUE/SHARE; ; ;0;0;0;0
> >
> >
> >
>
2. I am using symbol "INTC for Intel.
3. I existed, and restarted excel and still got the error message.
4. Yes, I see the MSN webpage when I plug in the url that you gave me from the previous message into excel : Data, Get external, from web page?
This message pops up when I plugged in your url:
"Do you want to view only the webpage content that was delivered securely?
This webpage contains content that will not be delivered using a secure HTTPS connection, which could compromise the security of the entire webpage."
you have to choice: Yes or NO.
I choosed, NO.
Randy, =rchgetelementnumbe
Beta =rchgetelementnumbe
Last Price =rchgetelementnumbe
52 Week Low =rchgetelementnumbe
52 Week High =rchgetelementnumbe
Thanks,
Rene
--- In smf_addin@yahoogrou
>
> Not the most recent version of the add-in, but the element definitions look
> correct.
>
> What ticker symbols are returning "Error"
>
> If you exit and restart EXCEL, do you still get "Error" on those elements?
> How about with ticker "MMM"
>
> Do you see a reasonable web page, filled with data, when you visit this URL
> with the EXCEL Web Query dialog:
>
> http://investing.
>
> On Thu, Mar 21, 2013 at 9:06 AM, rr76012 <rr76012@
>
> > Hello Randy, I plugged your formulas into the spreadsheet, here are the
> > answers I got.
> >
> > 1. Stock Market Functions add-in, Version 2.1.2012.01.
> > Files\SMF Add-In; 1)
> >
> > 2. MSN;Financial Highlights -- Return on Equity;
> > http://investing.
> >
> > 3. MSN;Financial Highlights -- Earnings/Share;
> > http://investing.
> >
> > 4. MSN;Financial Highlights -- Book Value/Share;
> > http://investing.
> >
> >
> >
>
Sun Mar 24, 2013 7:43 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
#NAME? on a freshly entered add-in formula would either mean the
function name is misspelled or the add-in is not active.
Your element definitions appeared to be current, so updating to the
most recent version shouldn't fix that. But it wouldn't hurt...
Otherwise, I'm at a loss as to why you're getting errors...
On Sun, Mar 24, 2013 at 7:38 AM, rr76012 <rr76012@yahoo.com > wrote:
> 1. Randy, Since I do not the most recent version add-in, should I update?
> 2. I am using symbol "INTC for Intel.
> 3. I existed, and restarted excel and still got the error message.
> 4. Yes, I see the MSN webpage when I plug in the url that you gave me from the previous message into excel : Data, Get external, from web page?
>
> This message pops up when I plugged in your url:
>
> "Do you want to view only the webpage content that was delivered securely?
>
> This webpage contains content that will not be delivered using a secure HTTPS connection, which could compromise the security of the entire webpage."
>
> you have to choice: Yes or NO.
>
> I choosed, NO.
>
> Randy, =rchgetelementnumber($E$2,B29), instead of saying "Error" in the cell, I now get this message "#NAME?"in the excel cell.
>
> Beta =rchgetelementnumber($E$2,24) =#NAME?
> Last Price =rchgetelementnumber($E$2,25)=#NAME?
> 52 Week Low =rchgetelementnumber($E$2,33)=#NAME?
> 52 Week High =rchgetelementnumber($E$2,34)=#NAME?
function name is misspelled or the add-in is not active.
Your element definitions appeared to be current, so updating to the
most recent version shouldn'
Otherwise, I'm at a loss as to why you're getting errors...
On Sun, Mar 24, 2013 at 7:38 AM, rr76012 <rr76012@yahoo.
> 1. Randy, Since I do not the most recent version add-in, should I update?
> 2. I am using symbol "INTC for Intel.
> 3. I existed, and restarted excel and still got the error message.
> 4. Yes, I see the MSN webpage when I plug in the url that you gave me from the previous message into excel : Data, Get external, from web page?
>
> This message pops up when I plugged in your url:
>
> "Do you want to view only the webpage content that was delivered securely?
>
> This webpage contains content that will not be delivered using a secure HTTPS connection, which could compromise the security of the entire webpage."
>
> you have to choice: Yes or NO.
>
> I choosed, NO.
>
> Randy, =rchgetelementnumbe
>
> Beta =rchgetelementnumbe
> Last Price =rchgetelementnumbe
> 52 Week Low =rchgetelementnumbe
> 52 Week High =rchgetelementnumbe
Sun Mar 24, 2013 9:21 am (PDT) . Posted by:
"rr76012" rr76012
Hi Randy,
I have good news and bad news!
You were right about the message "#NAME?". For my smf-addin, I went to excel office button, excel options, Add-ins, and discovered my smf-addin was disabled. I enabled it. I do not know how this happened, maybe when I updated my smf files? So most of my smf functions are now working again.
I am still trying to work out the "Error" messages.
Example: The symbol I am using is "INTC", Intel.
Last Price, =RCHGetElementNumber($F$1,25). I get the "Error" message.
Randy, you fixed my 1st problem, any ideas how I can fix the "Error" messages.
Thank you.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> #NAME? on a freshly entered add-in formula would either mean the
> function name is misspelled or the add-in is not active.
>
> Your element definitions appeared to be current, so updating to the
> most recent version shouldn't fix that. But it wouldn't hurt...
>
> Otherwise, I'm at a loss as to why you're getting errors...
>
> On Sun, Mar 24, 2013 at 7:38 AM, rr76012 <rr76012@...> wrote:
> > 1. Randy, Since I do not the most recent version add-in, should I update?
> > 2. I am using symbol "INTC for Intel.
> > 3. I existed, and restarted excel and still got the error message.
> > 4. Yes, I see the MSN webpage when I plug in the url that you gave me from the previous message into excel : Data, Get external, from web page?
> >
> > This message pops up when I plugged in your url:
> >
> > "Do you want to view only the webpage content that was delivered securely?
> >
> > This webpage contains content that will not be delivered using a secure HTTPS connection, which could compromise the security of the entire webpage."
> >
> > you have to choice: Yes or NO.
> >
> > I choosed, NO.
> >
> > Randy, =rchgetelementnumber($E$2,B29), instead of saying "Error" in the cell, I now get this message "#NAME?"in the excel cell.
> >
> > Beta =rchgetelementnumber($E$2,24) =#NAME?
> > Last Price =rchgetelementnumber($E$2,25)=#NAME?
> > 52 Week Low =rchgetelementnumber($E$2,33)=#NAME?
> > 52 Week High =rchgetelementnumber($E$2,34)=#NAME?
>
I have good news and bad news!
You were right about the message "#NAME?
I am still trying to work out the "Error" messages.
Example: The symbol I am using is "INTC"
Last Price, =RCHGetElementNumbe
Randy, you fixed my 1st problem, any ideas how I can fix the "Error" messages.
Thank you.
--- In smf_addin@yahoogrou
>
> #NAME? on a freshly entered add-in formula would either mean the
> function name is misspelled or the add-in is not active.
>
> Your element definitions appeared to be current, so updating to the
> most recent version shouldn'
>
> Otherwise, I'm at a loss as to why you're getting errors...
>
> On Sun, Mar 24, 2013 at 7:38 AM, rr76012 <rr76012@
> > 1. Randy, Since I do not the most recent version add-in, should I update?
> > 2. I am using symbol "INTC for Intel.
> > 3. I existed, and restarted excel and still got the error message.
> > 4. Yes, I see the MSN webpage when I plug in the url that you gave me from the previous message into excel : Data, Get external, from web page?
> >
> > This message pops up when I plugged in your url:
> >
> > "Do you want to view only the webpage content that was delivered securely?
> >
> > This webpage contains content that will not be delivered using a secure HTTPS connection, which could compromise the security of the entire webpage."
> >
> > you have to choice: Yes or NO.
> >
> > I choosed, NO.
> >
> > Randy, =rchgetelementnumbe
> >
> > Beta =rchgetelementnumbe
> > Last Price =rchgetelementnumbe
> > 52 Week Low =rchgetelementnumbe
> > 52 Week High =rchgetelementnumbe
>
Sun Mar 24, 2013 9:27 am (PDT) . Posted by:
"rr76012" rr76012
--- In smf_addin@yahoogrou
>
> Hi Randy,
>
> I have good news and bad news!
>
> You were right about the message "#NAME?
>
> I am still trying to work out the "Error" messages. It seems to be all the MSN elements. I tried some yahoo elements and they worked but not the MSN elements like last price, beta, etc.. elments # 24,25,33,34,
>
> Example: The symbol I am using is "INTC"
>
> Last Price, =RCHGetElementNumbe
>
> Randy, you fixed my 1st problem, any ideas how I can fix the "Error" messages.
>
> Thank you.
>
> --- In smf_addin@yahoogrou
> >
> > #NAME? on a freshly entered add-in formula would either mean the
> > function name is misspelled or the add-in is not active.
> >
> > Your element definitions appeared to be current, so updating to the
> > most recent version shouldn'
> >
> > Otherwise, I'm at a loss as to why you're getting errors...
> >
> > On Sun, Mar 24, 2013 at 7:38 AM, rr76012 <rr76012@
> > > 1. Randy, Since I do not the most recent version add-in, should I update?
> > > 2. I am using symbol "INTC for Intel.
> > > 3. I existed, and restarted excel and still got the error message.
> > > 4. Yes, I see the MSN webpage when I plug in the url that you gave me from the previous message into excel : Data, Get external, from web page?
> > >
> > > This message pops up when I plugged in your url:
> > >
> > > "Do you want to view only the webpage content that was delivered securely?
> > >
> > > This webpage contains content that will not be delivered using a secure HTTPS connection, which could compromise the security of the entire webpage."
> > >
> > > you have to choice: Yes or NO.
> > >
> > > I choosed, NO.
> > >
> > > Randy, =rchgetelementnumbe
> > >
> > > Beta =rchgetelementnumbe
> > > Last Price =rchgetelementnumbe
> > > 52 Week Low =rchgetelementnumbe
> > > 52 Week High =rchgetelementnumbe
> >
>
Sun Mar 24, 2013 1:53 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
OK, since you had to reactivate the add-in, let's start from the top.
What do you get with:
=RCHGetElementNumber("Version")
=RCHGetElementNumber("INTC",25)
=smfGetAParms(25)
=RCHGetWebData("http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=INTC ",1,20)
=RCHGetTableCell("http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=INTC ",1,"Last
Price")
On Sun, Mar 24, 2013 at 9:27 AM, rr76012 <rr76012@yahoo.com > wrote:
>> Example: The symbol I am using is "INTC", Intel.
>>
>> Last Price, =RCHGetElementNumber($F$1,25). I get the "Error" message.
>>
>> Randy, you fixed my 1st problem, any ideas how I can fix the "Error" messages.
>>
>> Thank you.
What do you get with:
=RCHGetElementNumbe
=RCHGetElementNumbe
=smfGetAParms(
=RCHGetWebData(
=RCHGetTableCell(
Price")
On Sun, Mar 24, 2013 at 9:27 AM, rr76012 <rr76012@yahoo.
>> Example: The symbol I am using is "INTC"
>>
>> Last Price, =RCHGetElementNumbe
>>
>> Randy, you fixed my 1st problem, any ideas how I can fix the "Error" messages.
>>
>> Thank you.
Sun Mar 24, 2013 8:27 am (PDT) . Posted by:
"NicholasDavid" davidnicholas738
Yes, of course it works. Except for dummies like me. Here is the formula I put in to get the p/e:
=RCHCreateComment(A1,54). Oh well. See ya. David
----- Original Message -----
From: "Randy Harmelink" < rharmelink@gmail.com >
To: "smf addin" < smf_addin@yahoogroups.com >
Sent: Saturday, March 23, 2013 2:03:24 PM
Subject: Re: [smf_addin] P/E Ratio
It works fine here:
=RCHGetElementNumber("BP",54)
...returns 11.6.
As for reliability, I have no comment. I've not done any kind of comparison.
On Sat, Mar 23, 2013 at 12:49 PM, ufdn16 < ufdn16@yahoo.com > wrote:
What is the most reliable element number to get the current P/E?
I've used #54 but I get an error for BP. Please lead me to a good number. Thanks, David
=RCHCreateComment(
----- Original Message -----
From: "Randy Harmelink" < rharmelink@gmail.
To: "smf addin" < smf_addin@yahoogrou
Sent: Saturday, March 23, 2013 2:03:24 PM
Subject: Re: [smf_addin] P/E Ratio
It works fine here:
=RCHGetElementNumbe
...returns 11.6.
As for reliability, I have no comment. I've not done any kind of comparison.
On Sat, Mar 23, 2013 at 12:49 PM, ufdn16 < ufdn16@yahoo.
What is the most reliable element number to get the current P/E?
I've used #54 but I get an error for BP. Please lead me to a good number. Thanks, David
Sun Mar 24, 2013 11:08 pm (PDT) . Posted by:
"andyha8" andyha8
Hey Randy, I hope you had a good weekend.
I would like to be able to get the street ratings guide and have the buy, hold and sell rating along with the a b c d etc. and the colors into my spreadsheet.
http://www.thestreet.com/quote/UTHR/details/analyst-ratings.html
Is that a possibility with the plugin?
Thanks
I would like to be able to get the street ratings guide and have the buy, hold and sell rating along with the a b c d etc. and the colors into my spreadsheet.
http://www.thestree
Is that a possibility with the plugin?
Thanks
Sun Mar 24, 2013 11:15 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
See: http://finance.groups.yahoo.com/group/smf_addin/message/21489
Found by searching the archives for "thestreet analyst".
You can use conditional formatting for the colors.
On Sun, Mar 24, 2013 at 11:08 PM, andyha8 <andyha8@gmail.com > wrote:
>
> I would like to be able to get the street ratings guide and have the buy,
> hold and sell rating along with the a b c d etc. and the colors into my
> spreadsheet.
>
> http://www.thestreet.com/quote/UTHR/details/analyst-ratings.html
>
> Is that a possibility with the plugin?
>
Found by searching the archives for "thestreet analyst"
You can use conditional formatting for the colors.
On Sun, Mar 24, 2013 at 11:08 PM, andyha8 <andyha8@gmail.
>
> I would like to be able to get the street ratings guide and have the buy,
> hold and sell rating along with the a b c d etc. and the colors into my
> spreadsheet.
>
> http://www.thestree
>
> Is that a possibility with the plugin?
>
Sun Mar 24, 2013 11:38 pm (PDT) . Posted by:
"andyha8" andyha8
Ha, 2 minutes after I emailed you I found that link! Sorry about that.
Of course , I can use conditional formatting, I should have thought of that. So to get the ticker from an excel cell, I just put in "&C2&" in place of the ticker in your example and it works like a charm!
The grasshopper is learning!
Thanks Randy
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> See: http://finance.groups.yahoo.com/group/smf_addin/message/21489
>
> Found by searching the archives for "thestreet analyst".
>
> You can use conditional formatting for the colors.
>
> On Sun, Mar 24, 2013 at 11:08 PM, andyha8 <andyha8@...> wrote:
>
> >
> > I would like to be able to get the street ratings guide and have the buy,
> > hold and sell rating along with the a b c d etc. and the colors into my
> > spreadsheet.
> >
> > http://www.thestreet.com/quote/UTHR/details/analyst-ratings.html
> >
> > Is that a possibility with the plugin?
> >
>
Of course , I can use conditional formatting, I should have thought of that. So to get the ticker from an excel cell, I just put in "&C2&
The grasshopper is learning!
Thanks Randy
--- In smf_addin@yahoogrou
>
> See: http://finance.
>
> Found by searching the archives for "thestreet analyst"
>
> You can use conditional formatting for the colors.
>
> On Sun, Mar 24, 2013 at 11:08 PM, andyha8 <andyha8@
>
> >
> > I would like to be able to get the street ratings guide and have the buy,
> > hold and sell rating along with the a b c d etc. and the colors into my
> > spreadsheet.
> >
> > http://www.thestree
> >
> > Is that a possibility with the plugin?
> >
>
Tidak ada komentar:
Posting Komentar