Jumat, 12 April 2013

[smf_addin] Digest Number 2582

15 New Messages

Digest #2582
1a
Re: [NEWBIE] Can NASDAQ Real-Time data be captured ? by "David Murphy" jshgfhjsgdfhjgsdfutef
1c
Re: [NEWBIE] Can NASDAQ Real-Time data be captured ? by "David Murphy" jshgfhjsgdfhjgsdfutef
1e
Re: [NEWBIE] Can NASDAQ Real-Time data be captured ? by "David Murphy" jshgfhjsgdfhjgsdfutef
4b

Messages

Fri Apr 12, 2013 3:23 am (PDT) . Posted by:

"David Murphy" jshgfhjsgdfhjgsdfutef

DOH! sorry

Here is the page http://www.nasdaq.com/symbol/amzn/real-time
Info I am after is current price and timestamp - i think Yahoo has
something similar, but I thought theat the Nasdaq would be more accurate ?
Now obviously the page updates every x seconds - would this cause a
problem with the 1000 page limit in the vba array ?

Many thanks

Dave

Amazon.com Inc. (AMZN)-NasdaqGS

269.85 0.00(0.00%) 4:00PM EDT|After Hours : 270.30 Up 0.45 (0.17%)7:34PM
EDT - Nasdaq Real Time Price

On 12/04/2013 02:27, Randy Harmelink wrote:
>
>
> Sample URL please?
>
> On Thu, Apr 11, 2013 at 5:25 PM, jshgfhjsgdfhjgsdfutef
> <cybersurferuk@googlemail.com <mailto:cybersurferuk@googlemail.com>>
> wrote:
>
> Apologies if this has been addressed somewhere already
>
> Have just found this forum and I am wondering if there is the
> ability to read the Amazon page of the NASDAQ real-time share
> price info - ideally the current price and the time of this price ?
>
>
>
>
>

Fri Apr 12, 2013 9:33 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

These work for me:

=0+smfGetTagContent("http://www.nasdaq.com/symbol/amzn/real-time
","div",-1,"id=""qwidget_lastsale""")
=0+smfGetTagContent("http://www.nasdaq.com/symbol/amzn/real-time
","div",-1,"id=""qwidget_netchange""")
=0+smfGetTagContent("http://www.nasdaq.com/symbol/amzn/real-time
","div",-1,"id=""qwidget_percent""")
=smfGetTagContent("http://www.nasdaq.com/symbol/amzn/real-time
","span",-1,"id=""qwidget_markettime""")

You'll need to use the smfForceRecalculation macro to get updates, so the
1000 page limit won't apply (it gets reset with each macro invocation). See
the LINKS area of the group for info on the macro.

However, I wouldn't do this for a whole lot of stocks, since you would be
getting a new web page for each quote. Too many and you'll have a long
update process.

On Fri, Apr 12, 2013 at 3:23 AM, David Murphy
<cybersurferuk@googlemail.com>wrote:

> DOH! sorry
>
> Here is the page http://www.nasdaq.com/symbol/amzn/real-time
> Info I am after is current price and timestamp - i think Yahoo has
> something similar, but I thought theat the Nasdaq would be more accurate ?
> Now obviously the page updates every x seconds - would this cause a
> problem with the 1000 page limit in the vba array ?
>
> Many thanks
>
> Dave
> Amazon.com Inc. (AMZN) -NasdaqGS
>
> 269.85 0.00(0.00%) 4:00PM EDT|After Hours : 270.30 [image: Up] 0.45
> (0.17%) 7:34PM EDT - Nasdaq Real Time Price
>
>

Fri Apr 12, 2013 10:35 am (PDT) . Posted by:

"David Murphy" jshgfhjsgdfhjgsdfutef

Hi Randy

Thanks for those - i could get the last 3 working, but the 1st seems to
give a #VALUE error ?
Also, the smfForceRecalc macro - is this in the addin or does it need to
be downloaded seperately, as I couldn't find it in the user defined
functions list - gives #NAME error ?

Cheers

Dave

On 12/04/2013 12:33, Randy Harmelink wrote:
>
>
> These work for me:
>
> =0+smfGetTagContent("http://www.nasdaq.com/symbol/amzn/real-time","div",-1,"id=""qwidget_lastsale""")
> =0+smfGetTagContent("http://www.nasdaq.com/symbol/amzn/real-time","div",-1,"id=""qwidget_netchange""")
> =0+smfGetTagContent("http://www.nasdaq.com/symbol/amzn/real-time","div",-1,"id=""qwidget_percent""")
> =smfGetTagContent("http://www.nasdaq.com/symbol/amzn/real-time","span",-1,"id=""qwidget_markettime""")
>
> You'll need to use the smfForceRecalculation macro to get updates, so
> the 1000 page limit won't apply (it gets reset with each macro
> invocation). See the LINKS area of the group for info on the macro.
>
> However, I wouldn't do this for a whole lot of stocks, since you would
> be getting a new web page for each quote. Too many and you'll have a
> long update process.
>
> On Fri, Apr 12, 2013 at 3:23 AM, David Murphy
> <cybersurferuk@googlemail.com <mailto:cybersurferuk@googlemail.com>>
> wrote:
>
> DOH! sorry
>
> Here is the page http://www.nasdaq.com/symbol/amzn/real-time
> Info I am after is current price and timestamp - i think Yahoo has
> something similar, but I thought theat the Nasdaq would be more
> accurate ?
> Now obviously the page updates every x seconds - would this cause
> a problem with the 1000 page limit in the vba array ?
>
> Many thanks
>
> Dave
>
>
> Amazon.com Inc. (AMZN)-NasdaqGS
>
> 269.85 0.00(0.00%) 4:00PM EDT|After Hours : 270.30 Up 0.45
> (0.17%)7:34PM EDT - Nasdaq Real Time Price
>
>
>
>
>
>

Fri Apr 12, 2013 10:41 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmmm. Just tried the first again and it works fine here. Drop the "0+" and
see what text is being returned from the function.

It wouldn't be listed in the user defined functions list, since an add-in
is not considered to be an "open workbook". You need to type in the name. I
have it on a toolbar button.

Did you read the LINKS entry on the macro?

On Fri, Apr 12, 2013 at 10:35 AM, David Murphy <cybersurferuk@googlemail.com
> wrote:

>
> Thanks for those - i could get the last 3 working, but the 1st seems to
> give a #VALUE error ?
> Also, the smfForceRecalc macro - is this in the addin or does it need to
> be downloaded seperately, as I couldn't find it in the user defined
> functions list - gives #NAME error ?
>
> On 12/04/2013 12:33, Randy Harmelink wrote:
>
> These work for me:
>
> =0+smfGetTagContent("http://www.nasdaq.com/symbol/amzn/real-time
> ","div",-1,"id=""qwidget_lastsale""")
> =0+smfGetTagContent("http://www.nasdaq.com/symbol/amzn/real-time
> ","div",-1,"id=""qwidget_netchange""")
> =0+smfGetTagContent("http://www.nasdaq.com/symbol/amzn/real-time
> ","div",-1,"id=""qwidget_percent""")
> =smfGetTagContent("http://www.nasdaq.com/symbol/amzn/real-time
> ","span",-1,"id=""qwidget_markettime""")
>
> You'll need to use the smfForceRecalculation macro to get updates, so the
> 1000 page limit won't apply (it gets reset with each macro invocation). See
> the LINKS area of the group for info on the macro.
>
> However, I wouldn't do this for a whole lot of stocks, since you would be
> getting a new web page for each quote. Too many and you'll have a long
> update process.
>
>

Fri Apr 12, 2013 11:05 am (PDT) . Posted by:

"David Murphy" jshgfhjsgdfhjgsdfutef

Hi Randy

Thanks for that - worked out that Excel objected to the $ - I'm running
on £s here in the UK but funny it wouldn't accept =0+£23.50 as a test
either - anyway it's easily fixed.

I have managed to get ForceRecalc working with a shift-ctrl key, but
couldn't get a button to work - I thought 2007 didn't allow custom
buttons on the toolbar ?
Tried adding a button to the spreadsheet, but the buttonclick() function
didn't recognize smfForceRecalculation

My intention is to have auto refresh say every 5 seconds, working on 56
stocks, 19 currencies, and 16 indices - do you think this would prevent
a 5 second update / suppose I could increase to say 20 seconds - what do
you reckon ?

My cunning plan is to have the data updating in the background, with a
monitor function to alert me to any interesting activity

Cheers

Dave*_

_*
On 12/04/2013 13:41, Randy Harmelink wrote:
>
>
> Hmmm. Just tried the first again and it works fine here. Drop the "0+"
> and see what text is being returned from the function.
>
> It wouldn't be listed in the user defined functions list, since an
> add-in is not considered to be an "open workbook". You need to type in
> the name. I have it on a toolbar button.
>
> Did you read the LINKS entry on the macro?
>
> On Fri, Apr 12, 2013 at 10:35 AM, David Murphy
> <cybersurferuk@googlemail.com <mailto:cybersurferuk@googlemail.com>>
> wrote:
>
>
> Thanks for those - i could get the last 3 working, but the 1st
> seems to give a #VALUE error ?
> Also, the smfForceRecalc macro - is this in the addin or does it
> need to be downloaded seperately, as I couldn't find it in the
> user defined functions list - gives #NAME error ?
>
> On 12/04/2013 12:33, Randy Harmelink wrote:
>> These work for me:
>>
>> =0+smfGetTagContent("http://www.nasdaq.com/symbol/amzn/real-time","div",-1,"id=""qwidget_lastsale""")
>> =0+smfGetTagContent("http://www.nasdaq.com/symbol/amzn/real-time","div",-1,"id=""qwidget_netchange""")
>> =0+smfGetTagContent("http://www.nasdaq.com/symbol/amzn/real-time","div",-1,"id=""qwidget_percent""")
>> =smfGetTagContent("http://www.nasdaq.com/symbol/amzn/real-time","span",-1,"id=""qwidget_markettime""")
>>
>> You'll need to use the smfForceRecalculation macro to get
>> updates, so the 1000 page limit won't apply (it gets reset with
>> each macro invocation). See the LINKS area of the group for info
>> on the macro.
>>
>> However, I wouldn't do this for a whole lot of stocks, since you
>> would be getting a new web page for each quote. Too many and
>> you'll have a long update process.
>
>
>
>
>

Fri Apr 12, 2013 1:25 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

In EXCEL 2007, I have it on the QAT (Quick Access Toolbar)...

Sounds like you'd be better off with Real Time quotes from Yahoo. You could
get the 56 stocks, 19 currencies, and 16 indices with one Internet access.

Personally, I prefer not to follow things so closely, so I don't have any
experience in the area.

But you'll need VBA processing to do the refresh, retain the old values,
and compare to new values.

On Fri, Apr 12, 2013 at 11:05 AM, David Murphy <cybersurferuk@googlemail.com
> wrote:

>
> Thanks for that - worked out that Excel objected to the $ - I'm running on
> £s here in the UK but funny it wouldn't accept =0+£23.50 as a test either -
> anyway it's easily fixed.
>
> I have managed to get ForceRecalc working with a shift-ctrl key, but
> couldn't get a button to work - I thought 2007 didn't allow custom buttons
> on the toolbar ?
> Tried adding a button to the spreadsheet, but the buttonclick() function
> didn't recognize smfForceRecalculation
>
> My intention is to have auto refresh say every 5 seconds, working on 56
> stocks, 19 currencies, and 16 indices - do you think this would prevent a 5
> second update / suppose I could increase to say 20 seconds - what do you
> reckon ?
>
> My cunning plan is to have the data updating in the background, with a
> monitor function to alert me to any interesting activity
>

Fri Apr 12, 2013 4:59 am (PDT) . Posted by:

"weekeewawa" weekeewawa

haha,

i guess programming is taxing me till i made all sort of silly errors.

i was testing on the codes at 4 traders and i ran into some problems

1) i keep getting the #VALUE error for certain rows but it works fine for other rows. the codes work fine but when i input the row reference name for example

''Mean consensus'' in
http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/consensus/

''Yield&#39;', ''Announcement Date'', ''PER (Price / EPS)'',''Capitalization / Revenue'', ''EV / Revenue'', ''operating laverage (Delta EBIT / Delta Sales)'&#39;,Capital Intensity (Assets / Sales). ''Company Value'&#39;

in the size, valuation, profitability and balance sheeet analysis of
http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/financials/
but examples like EBITDA, ROA, ROE works well!

Annual publications in
http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/calendar/ gives the #VALUE Error

although the code is as simple as
=0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/"&A1&"/calendar/",1,"Sales";)," ","")

in which i just replace ''Annual Results'' with the relevant row reference. It shouldnt have any problem logically but the #VALUE Error shows in the above example rows

2) i was also testing this code
=smfGetTagContent("http://http://www.4-traders.com/"&D$125&"/news-history/"",1,""LatestNews")

on

http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/news-history/
as the extraction in specific news site are based on this code. But also, it gives a VALUE Error. Am i close to getting it right?

3) in
http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/quotes-ticks/

i understand that the row reference is not horizontal but instead is vertical down.

So what should be tweaked in
=0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/"&A1&"/calendar/",1,"Sales";)," ","")

for the case of the vertical column reference?

thanks

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I told you -- you're using TWO APOSTROPHES instead of a double quote, twice
> (on either side of the &A1&).
>
> You don't want two ' characters. You want one " character. They're the same
> key on the keyboard, but the apostrophe is the unshifted version of the key.
>
> On Thu, Apr 11, 2013 at 10:58 PM, weekeewawa <weekeewawa@...> wrote:
>
> >
> > it is incredibly strange
> >
> > i typed in the exact same code
> >
> > =0+SUBSTITUTE(RCHGetTableCell("
> > http://www.4-traders.com/''&A1&&#39;'/financials/",4,"(EBITDA)")," ","")
> >
> > vs
> >
> > yours
> >
> > =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/"&A1&"/financials/",4,"(EBITDA)"),"
> > ","")
> >
> > but mine is value error and urs is correct!
> >
> > how did u get the '' on the keyboard?
> >
>

Fri Apr 12, 2013 9:45 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

This works fine for me:

=RCHGetTableCell("
http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/consensus/",
1,">Mean Consensus")

For news, I would use:

=RCHGetHTMLTable("
http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/news-history/",
">Latest News on",1,"",2)

For sales, I would use:

=RCHGetHTMLTable("
http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/quotes-ticks/",
">Quantity&quot;,-1,"",1)

Are you trying these on the template I suggested?

On Fri, Apr 12, 2013 at 4:59 AM, weekeewawa <weekeewawa@yahoo.com> wrote:

> haha,
>
> i guess programming is taxing me till i made all sort of silly errors.
>
> i was testing on the codes at 4 traders and i ran into some problems
>
> 1) i keep getting the #VALUE error for certain rows but it works fine for
> other rows. the codes work fine but when i input the row reference name for
> example
>
> ''Mean consensus'' in
> http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/consensus/
>
> ''Yield&#39;', ''Announcement Date'', ''PER (Price / EPS)'',''Capitalization /
> Revenue'', ''EV / Revenue'', ''operating laverage (Delta EBIT / Delta
> Sales)'&#39;,Capital Intensity (Assets / Sales). ''Company Value'&#39;
>
> in the size, valuation, profitability and balance sheeet analysis of
> http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/financials/
> but examples like EBITDA, ROA, ROE works well!
>
> Annual publications in
> http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/calendar/ gives
> the #VALUE Error
>
> although the code is as simple as
> =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/"&A1&"/calendar/",1,"Sales";),"
> ","")
>
> in which i just replace ''Annual Results'' with the relevant row
> reference. It shouldnt have any problem logically but the #VALUE Error
> shows in the above example rows
>
> 2) i was also testing this code
> =smfGetTagContent("http://http://www.4-traders.com/
> "&D$125&"/news-history/"",1,""LatestNews")
>
> on
>
> http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/news-history/
> as the extraction in specific news site are based on this code. But also,
> it gives a VALUE Error. Am i close to getting it right?
>
> 3) in
> http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/quotes-ticks/
>
> i understand that the row reference is not horizontal but instead is
> vertical down.
>
> So what should be tweaked in
> =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/"&A1&"/calendar/",1,"Sales";),"
> ","")
>
> for the case of the vertical column reference?
>

Fri Apr 12, 2013 6:47 am (PDT) . Posted by:

"R" venkat1926

. I am in India and these are Indian stocks. for the past few years I
used to download using smf add in and get good data of my stocks. I was
then having excel 2003. now after getting new compputer I am having
excel 2007 (compatabilit mode). since then the smf addi is not working
properly. today on 12th April I get some data for current data some old
data I am gioving tgruncated data with last price and date for few
stocks
symbol last trade date^NSEI 5835.25 3/18/2013ADSL.BO 12.5
4/12/2013AMTEKAUTO.BO 64.05 4/12/2013AXISBANK.BO 1270
4/12/2013BAJAJAUT.BO 1718.5 4/12/2013BHARATFOR.NS 220.35
3/18/2013BHARTIART.NS 307.5 3/18/2013bhel.bo 179.4 4/12/2013BRITANNIA.bo
530.6 4/12/2013CCCL.bo 12.2 4/12/2013CLASSICD.BO 2.9 4/12/2013

what is the problem. is it because that smf addin is not compatable with
excel 2007 or it is because problem in yahoo finance data.
what is the solution or what is the alternative. I used this data to
monitor selling the stocks at pre arranged criteria for e.g. lproit of
10%. thanks

Fri Apr 12, 2013 9:16 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I use EXCEL 2007. I tried BHARATFOR.NS and got today's date.

Do you have your Internet Options set to always get new content when a web
page is visited? That's the only thing I can think of, but I can't believe
it would cache data that old.

On Fri, Apr 12, 2013 at 6:47 AM, R <venkat1926@yahoo.com> wrote:

>
> . I am in India and these are Indian stocks. for the past few years I
> used to download using smf add in and get good data of my stocks. I was
> then having excel 2003. now after getting new compputer I am having excel
> 2007 (compatabilit mode). since then the smf addi is not working properly.
> today on 12th April I get some data for current data some old data I am
> gioving tgruncated data with last price and date for few stocks
>
> symbol last trade date
> ^NSEI 5835.25 *3/18/2013*
> ADSL.BO 12.5 4/12/2013
> AMTEKAUTO.BO 64.05 4/12/2013
> AXISBANK.BO 1270 4/12/2013
> BAJAJAUT.BO 1718.5 4/12/2013
> BHARATFOR.NS 220.35* 3/18/2013*
> BHARTIART.NS 307.5 *3/18/2013*
> bhel.bo 179.4 4/12/2013
> BRITANNIA.bo 530.6 4/12/2013
> CCCL.bo 12.2 4/12/2013
> CLASSICD.BO 2.9 4/12/2013
>
>
> what is the problem. is it because that smf addin is not compatable with
> excel 2007 or it is because problem in yahoo finance data.
>
> what is the solution or what is the alternative. I used this data to
> monitor selling the stocks at pre arranged criteria for e.g. lproit of
> 10%. thanks
>
>

Fri Apr 12, 2013 12:59 pm (PDT) . Posted by:

"rr76012" rr76012

Hello Randy,

I have given up on rchgetelementnumbers, example =rcghetelementnumber(B7, 25) for the current price. It works about 40-50% for me.

I am going to use this:

=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&#92;
&Symbol=EXC",1,"Last Price")

How do I automate this process with the cell reference B7?

I tried using ampersand before and after the cell like this, &B7& what am I doing wrong? It is not working I get an error message?

=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&#92;
&Symbol=&B7&",1,"Last Price")

Randy, thanks.

Fri Apr 12, 2013 1:04 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Why not just use the RCHGetYahooQuotes() function?

By the way, "Last Price" on that MSN web page is the previous day's closing
price.

If you want to concatenate a string to a cell reference:

="...string..." & B7

On Fri, Apr 12, 2013 at 12:59 PM, rr76012 <rr76012@yahoo.com> wrote:

>
> I have given up on rchgetelementnumbers, example =rcghetelementnumber(B7,
> 25) for the current price. It works about 40-50% for me.
>
> I am going to use this:
>
> =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&#92;
> &Symbol=EXC",1,"Last Price")
>
> How do I automate this process with the cell reference B7?
>
> I tried using ampersand before and after the cell like this, &B7& what am
> I doing wrong? It is not working I get an error message?
>
> =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&#92;
> &Symbol=&B7&",1,"Last Price")
>

Fri Apr 12, 2013 1:14 pm (PDT) . Posted by:

"rr76012" rr76012

I think you are right, I will use the rchgetyahooquotes() function.

Awesome:

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Why not just use the RCHGetYahooQuotes() function?
>
> By the way, "Last Price" on that MSN web page is the previous day's closing
> price.
>
> If you want to concatenate a string to a cell reference:
>
> ="...string..." & B7
>
> On Fri, Apr 12, 2013 at 12:59 PM, rr76012 <rr76012@...> wrote:
>
> >
> > I have given up on rchgetelementnumbers, example =rcghetelementnumber(B7,
> > 25) for the current price. It works about 40-50% for me.
> >
> > I am going to use this:
> >
> > =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&#92;
> > &Symbol=EXC",1,"Last Price")
> >
> > How do I automate this process with the cell reference B7?
> >
> > I tried using ampersand before and after the cell like this, &B7& what am
> > I doing wrong? It is not working I get an error message?
> >
> > =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&#92;
> > &Symbol=&B7&",1,"Last Price")
> >
>

Fri Apr 12, 2013 1:06 pm (PDT) . Posted by:

"rr76012" rr76012

Randy would you try using the symbol for Excelon "EXC" with these 2 methods. I keep getting an error?

=RCHGetElementNumber("exc";,25) give me "Error"

B7 = EXC,
=RCHGetElementNumber(B7, 25), gives me "Error"

Randy thanks, do you recommend other rchgetelementnumber numbers for current: price, dividend, and eps?

Thanks,

Fri Apr 12, 2013 1:15 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Both work fine for me. But if you got "Error" with one, you will get
"Error" with the other -- they are both extracting data from the same saved
web page.

I always use RCHGetYahooQuotes() for current prices. It also has codes for
dividend and EPS, although it is a trailing dividend. Most people desire a
forward dividend.

On Fri, Apr 12, 2013 at 1:06 PM, rr76012 <rr76012@yahoo.com> wrote:

> Randy would you try using the symbol for Excelon "EXC" with these 2
> methods. I keep getting an error?
>
> =RCHGetElementNumber("exc";,25) give me "Error"
>
> B7 = EXC,
> =RCHGetElementNumber(B7, 25), gives me "Error"
>
> Randy thanks, do you recommend other rchgetelementnumber numbers for
> current: price, dividend, and eps?
>
Diposting oleh EXCEL FEED LEARNING di 13.25

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)