8 New Messages
Digest #2527
Messages
Thu Feb 28, 2013 2:00 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I don't know the details of how thestreet.com gets the rating on the web
page...
I would have thought it was from that *.js file, but apparently not.
Instead, apparently, it's within the JavaScript of the web page itself.
On Thu, Feb 28, 2013 at 2:58 PM, mdouglashaas douglashaas4974@earthlink.net
> wrote:
> Yes, That is what I needed. Now I am confused -- what's the difference ?
>
page...
I would have thought it was from that *.js file, but apparently not.
Instead, apparently, it's within the JavaScript of the web page itself.
On Thu, Feb 28, 2013 at 2:58 PM, mdouglashaas douglashaas4974@
> wrote:
> Yes, That is what I needed. Now I am confused -- what's the difference ?
>
Thu Feb 28, 2013 4:16 pm (PST) . Posted by:
"andyha8" andyha8
Works like a charm! Thankyou!
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> This is just a normal EXCEL operation of concatenation:
>
> =RCHGetTableCell("http://finance.yahoo.com/q?s= "&A4,1,"Next Earnings
> Date:",,,,0)
>
> On Wed, Feb 27, 2013 at 11:13 AM, andyha8 wrote:
>
> >
> > I want to get the next earnings date for a list of stocks.
> >
> > In excel, I have a list of tickers in cells A1-A12
> >
> > Is there a way to use this formula:
> >
> > =RCHGetTableCell("http://finance.yahoo.com/q?s=BAC&ql=1 ",1,"Next Earnings
> > Date:",,,,0)
> >
> > to get the ticker from the cells instead of having to write the ticker
> > into the formula every time?
> >
>
--- In smf_addin@yahoogrou
>
> This is just a normal EXCEL operation of concatenation:
>
> =RCHGetTableCell(
> Date:",
>
> On Wed, Feb 27, 2013 at 11:13 AM, andyha8 wrote:
>
> >
> > I want to get the next earnings date for a list of stocks.
> >
> > In excel, I have a list of tickers in cells A1-A12
> >
> > Is there a way to use this formula:
> >
> > =RCHGetTableCell(
> > Date:",
> >
> > to get the ticker from the cells instead of having to write the ticker
> > into the formula every time?
> >
>
Thu Feb 28, 2013 5:33 pm (PST) . Posted by:
"Chris Ball" peggysue281
Thanks Randy that solved the problem.
On Thu, Feb 28, 2013 at 3:19 PM, Randy Harmelink rharmelink@gmail.com >wrote:
> **
>
>
> I would suggest just using the latest official release. Exit EXCEL,
> download it from the group, and then extract all of the files into your SMF
> add-in folder, replacing files as needed. Then restart EXCEL and you should
> have that version of the add-in, and the latest element definitions.
>
> You can check which version the add-in is with:
>
> =RCHGetElementNumber("Version")
>
>
> On Thu, Feb 28, 2013 at 12:50 PM, Chris Ball crball02@gmail.com > wrote:
>
>>
>> The other day my computer crashed and I had to reboot my hard drive.
>> Since rebooting I have been receiving these errors when running the add in:
>>
>> =RCHGetElementNumber(Ticker,25)
>>
>> =RCHGetElementNumber(Ticker,48)
>>
>> =RCHGetElementNumber(Ticker,84)
>>
>> =RCHGetElementNumber(Ticker,AN12)
>>
>> I know the issue is I need to download new element definitions but it has
>> been so long since I had to do it I am not sure what element definitions I
>> need to download. Any help is appreciated.
>>
>>
>>
>
>
--
Thanks,
Chris Ball
On Thu, Feb 28, 2013 at 3:19 PM, Randy Harmelink rharmelink@gmail.
> **
>
>
> I would suggest just using the latest official release. Exit EXCEL,
> download it from the group, and then extract all of the files into your SMF
> add-in folder, replacing files as needed. Then restart EXCEL and you should
> have that version of the add-in, and the latest element definitions.
>
> You can check which version the add-in is with:
>
> =RCHGetElementNumbe
>
>
> On Thu, Feb 28, 2013 at 12:50 PM, Chris Ball crball02@gmail.
>
>>
>> The other day my computer crashed and I had to reboot my hard drive.
>> Since rebooting I have been receiving these errors when running the add in:
>>
>> =RCHGetElementNumbe
>>
>> =RCHGetElementNumbe
>>
>> =RCHGetElementNumbe
>>
>> =RCHGetElementNumbe
>>
>> I know the issue is I need to download new element definitions but it has
>> been so long since I had to do it I am not sure what element definitions I
>> need to download. Any help is appreciated.
>>
>>
>>
>
>
--
Thanks,
Chris Ball
Thu Feb 28, 2013 7:41 pm (PST) . Posted by:
"wrgreeley38" wrgreeley38
The following always returns error: =rchgetelementnumber("IBM";,989). I am using excel 2002. What is wrong. It used to work long ago.
Thu Feb 28, 2013 8:01 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
It's working fine here. Which version of the add-in are you using? Do you
have old element definitions? That element changed in late 2010 because
Yahoo changed their web page content.
On Thu, Feb 28, 2013 at 8:41 PM, wrgreeley38 wrgreeley38@yahoo.com > wrote:
> The following always returns error: =rchgetelementnumber("IBM";,989). I am
> using excel 2002. What is wrong. It used to work long ago.
>
have old element definitions? That element changed in late 2010 because
Yahoo changed their web page content.
On Thu, Feb 28, 2013 at 8:41 PM, wrgreeley38 wrgreeley38@
> The following always returns error: =rchgetelementnumbe
> using excel 2002. What is wrong. It used to work long ago.
>
Thu Feb 28, 2013 8:26 pm (PST) . Posted by:
"Brent" freefaller6
Hi Randy, just curious. Do you have the Rule #1 or Paybacktime calculations included? I saw one for calculating the margin of safety (MOS), but regardless of the stock I picked, I got an error. Thanks.
Brent
________________________________
From: Randy Harmelink rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Thursday, February 28, 2013 4:16 PM
Subject: Re: [smf_addin] What is can’t ?
It's usually the result of misinterpretation of characters by various email clients and/or browsers. Not all of them used the same coding protocols.
On Thu, Feb 28, 2013 at 11:55 AM, almondtree almondtree@yahoo.com > wrote:
#21481 and #21482
>
>can’t
>Â
>Â Â Â Â Â
>>
>> >
>Is there a reason for for all this extra stuff in messages?
>What is can’t ?
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>
>
Brent
____________
From: Randy Harmelink rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Thursday, February 28, 2013 4:16 PM
Subject: Re: [smf_addin] What is can’t ?
It's usually the result of misinterpretation of characters by various email clients and/or browsers. Not all of them used the same coding protocols.
On Thu, Feb 28, 2013 at 11:55 AM, almondtree almondtree@yahoo.
#21481 and #21482
>
>can’t
>Â
>Â Â Â Â Â
>>
>> >
>Is there a reason for for all this extra stuff in messages?
>What is can’t ?
>
>
>
>
>--------
>
>Yahoo! Groups Links
>
>
>
>
Thu Feb 28, 2013 8:29 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
See: http://finance.groups.yahoo.com/group/smf_addin/message/19452
On Thu, Feb 28, 2013 at 9:26 PM, Brent freefaller6@yahoo.com > wrote:
>
> Hi Randy, just curious. Do you have the Rule #1 or Paybacktime
> calculations included? I saw one for calculating the margin of safety
> (MOS), but regardless of the stock I picked, I got an error. Thanks.
> Brent
>
On Thu, Feb 28, 2013 at 9:26 PM, Brent freefaller6@
>
> Hi Randy, just curious. Do you have the Rule #1 or Paybacktime
> calculations included? I saw one for calculating the margin of safety
> (MOS), but regardless of the stock I picked, I got an error. Thanks.
> Brent
>
Fri Mar 1, 2013 3:15 am (PST) . Posted by:
"j14mako" j14mako
I'm wondering if I can pull the hyperlinks into my spreadsheet so I can have a single place to open the PDFs from the web?
e.g. From this page, there are links to PDFs:
http://www.asx.com.au/asx/statistics/announcements.do?by=asxCode&asxCode=hvn&timeframe=Y&year=2013
I tried this:
=RCHGetHTMLTable("http://www.asx.com.au/asx/statistics/announcements.do?by=asxCode&asxCode=hvn&timeframe=Y&year=2013 ","Date",-1,"",1)
But the hyperlinks are returned as plain text.
e.g. From this page, there are links to PDFs:
http://www.asx.
I tried this:
=RCHGetHTMLTable(
But the hyperlinks are returned as plain text.
Tidak ada komentar:
Posting Komentar