Messages In This Digest (9 Messages)
- 1a.
- Re: Does RCHGetTableCell function work in array? From: boo1712
- 1b.
- Re: Does RCHGetTableCell function work in array? From: Randy Harmelink
- 2a.
- FINRA From: justy_sports
- 2b.
- Re: FINRA From: Randy Harmelink
- 2c.
- Re: FINRA From: justy_sports
- 2d.
- Re: FINRA From: Randy Harmelink
- 3a.
- Previous Report Date From: rdenotari
- 3b.
- Re: Previous Report Date From: Randy Harmelink
- 3c.
- Re: Previous Report Date From: Robert de Notaristefani
Messages
- 1a.
-
Re: Does RCHGetTableCell function work in array?
Posted by: "boo1712" boo1712@yahoo.co.uk boo1712
Mon Aug 1, 2011 10:10 am (PDT)
Thanks for your reply.
It is just that when populating cells in array format, columns of maybe 30 cells takes like few seconds.
But if the formula is not entered in array, it may take like maybe half a minute.
I do not know why but excel sheets refresh much faster in a single array
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It does not work in an array. I don't understand your second comment. Even
> if it did work in an array, it would be doing the same amount of work to
> fill the range. There was no point in making it an array, since arrays just
> complicate worksheet usage.
>
> On Sun, Jul 31, 2011 at 5:51 AM, boo1712 <boo1712@...> wrote:
>
> >
> > Just want to confirm whether the function work in array?
> >
> > Hard to get more than a handful of cells if it cannot work in array.
> >
>
- 1b.
-
Re: Does RCHGetTableCell function work in array?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Aug 1, 2011 12:29 pm (PDT)
That's because something like RCHGetYahooQuotes() can get multiple items of
data on multiple stocks in a single Internet access. It's WHY the function
is designed to be array-entered -- BECAUSE it is ABLE to get all of the data
at one time. It's nature of the data source.
But with something like RCHGetElementNumber(), multiple ticker symbols still
require going to separate web pages to get the data. So if it were to be
array-entered over a range for multiple tickers, it would STILL need to get
all of those individual web pages.
It's the number of Internet accesses that determine how fast the functions
run.
I wish every function COULD get all the necessary data in one Internet
access. :)
On Mon, Aug 1, 2011 at 10:10 AM, boo1712 <boo1712@yahoo.co.uk > wrote:
>
> It is just that when populating cells in array format, columns of maybe 30
> cells takes like few seconds.
>
> But if the formula is not entered in array, it may take like maybe half a
> minute.
>
> I do not know why but excel sheets refresh much faster in a single array
>
- 2a.
-
FINRA
Posted by: "justy_sports" justy_sports@yahoo.com justy_sports
Mon Aug 1, 2011 12:21 pm (PDT)
Is there a way to import corporate bond data from the FINRA website to EXCEL using this add in? I am just looking to import basic information like price, coupon, maturity, etc.
Thanks.
- 2b.
-
Re: FINRA
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Aug 1, 2011 1:53 pm (PDT)
More details, such as a source URL. I have no idea what to look for on their
web site. You might also search the message archives?
On Mon, Aug 1, 2011 at 8:54 AM, justy_sports <justy_sports@yahoo.com > wrote:
> Is there a way to import corporate bond data from the FINRA website to
> EXCEL using this add in? I am just looking to import basic information like
> price, coupon, maturity, etc.
>
- 2c.
-
Re: FINRA
Posted by: "justy_sports" justy_sports@yahoo.com justy_sports
Mon Aug 1, 2011 2:24 pm (PDT)
I am just looking to import a portfolio of bonds from the "Watchlist" feature on FINRA's website.
http://cxa.marketwatch.com/finra/ BondCenter/ Watchlist. aspx
I have looked through a few of the messages archived on here, but will continue to dig deeper through them...
Thanks.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> More details, such as a source URL. I have no idea what to look for on their
> web site. You might also search the message archives?
>
> On Mon, Aug 1, 2011 at 8:54 AM, justy_sports <justy_sports@...> wrote:
>
> > Is there a way to import corporate bond data from the FINRA website to
> > EXCEL using this add in? I am just looking to import basic information like
> > price, coupon, maturity, etc.
> >
>
- 2d.
-
Re: FINRA
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Aug 1, 2011 3:58 pm (PDT)
Can't help there. I have nothing to extract...
On Mon, Aug 1, 2011 at 2:23 PM, justy_sports <justy_sports@yahoo.com > wrote:
> I am just looking to import a portfolio of bonds from the "Watchlist"
> feature on FINRA's website.
>
> http://cxa.marketwatch.com/finra/ BondCenter/ Watchlist. aspx
>
> I have looked through a few of the messages archived on here, but will
> continue to dig deeper through them...
>
- 3a.
-
Previous Report Date
Posted by: "rdenotari" rdenotari@yahoo.com rdenotari
Mon Aug 1, 2011 12:54 pm (PDT)
Hi everyone, I'm currently looking for a function to get the "Previous Report Date"
I was using this function to get the "Next Report Date", however I can't find the Prev report date on Zacks anywhere. Does anyone know where else I could find/get it? Please note, I'm looking for the actual EPS report date, not the fiscal quarter date.
RCHGetTableCell("http://www.zacks. com/research/ "&A3,1,"Next Report Date")report.php? type=estimates& t=
Thanks so much for the help,
Rob
- 3b.
-
Re: Previous Report Date
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Aug 1, 2011 1:51 pm (PDT)
Try earnings.com:
http://www.earnings.com/company. asp?client= cb&ticker= MMM
Or, MSN has a "Stmt Source Date" on their financials:
http://moneycentral.msn.com/ investor/ invsub/results/ statemnt. aspx?symbol= MMM&stmtView= Qtr
On Mon, Aug 1, 2011 at 12:53 PM, rdenotari <rdenotari@yahoo.com > wrote:
> Hi everyone, I'm currently looking for a function to get the "Previous
> Report Date"
>
> I was using this function to get the "Next Report Date", however I can't
> find the Prev report date on Zacks anywhere. Does anyone know where else I
> could find/get it? Please note, I'm looking for the actual EPS report date,
> not the fiscal quarter date.
>
> RCHGetTableCell("
> http://www.zacks.com/research/ "&A3,1,"Nextreport.php? type=estimates& t=
> Report Date")
>
- 3c.
-
Re: Previous Report Date
Posted by: "Robert de Notaristefani" rdenotari@yahoo.com rdenotari
Mon Aug 1, 2011 2:13 pm (PDT)
The MSN date works great. Thank you
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Monday, August 1, 2011 4:51 PM
Subject: Re: [smf_addin] Previous Report Date
Try earnings.com:
http://www.earnings.com/company. asp?client= cb&ticker= MMM
Or, MSN has a "Stmt Source Date" on their financials:
http://moneycentral.msn.com/ investor/ invsub/results/ statemnt. aspx?symbol= MMM&stmtView= Qtr
On Mon, Aug 1, 2011 at 12:53 PM, rdenotari <rdenotari@yahoo.com > wrote:
Hi everyone, I'm currently looking for a function to get the "Previous Report Date"
>
>I was using this function to get the "Next Report Date", however I can't find the Prev report date on Zacks anywhere. Does anyone know where else I could find/get it? Please note, I'm looking for the actual EPS report date, not the fiscal quarter date.
>
>RCHGetTableCell("http://www.zacks. com/research/ "&A3,1,"Next Report Date")report.php? type=estimates& t=
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar