12 New Messages
Digest #2671
Messages
Tue Jun 25, 2013 5:25 am (PDT) . Posted by:
"ssztaba" ssztaba
I'm using =RCHGetYahooQuotes(B7:B207,C6:D6,,NOW()) as my array formula.
In C6 I have 'n' and in D6 I have 'l1' which gets me the Name and last price of the stock in Column A. I think the 'n' and 'l1' are called the Yahoo codes.
I've looked in the Files section, but I am not finding, a list of other available Yahoo codes. I'm specifically looking for the Yahoo codes for 'Next Earnings Date" and for "Next Ex Date"
Thanks
Stan Sztaba
In C6 I have 'n' and in D6 I have 'l1' which gets me the Name and last price of the stock in Column A. I think the 'n' and 'l1' are called the Yahoo codes.
I've looked in the Files section, but I am not finding, a list of other available Yahoo codes. I'm specifically looking for the Yahoo codes for 'Next Earnings Date" and for "Next Ex Date"
Thanks
Stan Sztaba
Tue Jun 25, 2013 6:08 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The documentation for the RCHGetYahooQuotes() function is in the
DOCUMENTATION folder in the FILES area of the group. It contains a list of
the Yahoo codes.
Unfortunately, neither "Next Earnings Date" nor "Ex-Dividend Date" are
things that Yahoo provides on their current quotes CSV interface.
On Tue, Jun 25, 2013 at 5:25 AM, ssztaba <ssjurik@optonline.net > wrote:
> I'm using =RCHGetYahooQuotes(B7:B207,C6:D6,,NOW()) as my array formula.
>
> In C6 I have 'n' and in D6 I have 'l1' which gets me the Name and last
> price of the stock in Column A. I think the 'n' and 'l1' are called the
> Yahoo codes.
>
> I've looked in the Files section, but I am not finding, a list of other
> available Yahoo codes. I'm specifically looking for the Yahoo codes for
> 'Next Earnings Date" and for "Next Ex Date"
>
DOCUMENTATION folder in the FILES area of the group. It contains a list of
the Yahoo codes.
Unfortunately, neither "Next Earnings Date" nor "Ex-Dividend Date" are
things that Yahoo provides on their current quotes CSV interface.
On Tue, Jun 25, 2013 at 5:25 AM, ssztaba <ssjurik@optonline.
> I'm using =RCHGetYahooQuotes(
>
> In C6 I have 'n' and in D6 I have 'l1' which gets me the Name and last
> price of the stock in Column A. I think the 'n' and 'l1' are called the
> Yahoo codes.
>
> I've looked in the Files section, but I am not finding, a list of other
> available Yahoo codes. I'm specifically looking for the Yahoo codes for
> 'Next Earnings Date" and for "Next Ex Date"
>
Tue Jun 25, 2013 6:55 am (PDT) . Posted by:
"bs2167" bs2167
Hello,
Now that earnings.com has moved and changed significantly, I'm trying to import the Yahoo Earnings Calendar into Excel. I'd like to pull in the entire calendar from yesterday, today, and tomorrow. So far I've tried countless combinations of PFinds and PDirs with RCHGetHTMLTable() but with no luck - all cells are either blank or full of errors. If anyone could help with what I'm doing wrong I would very much appreciate it.
My last try was array entering the following:
=rchgetHTMLTable("http://biz.yahoo.com/research/earncal/20130626.html ","Earnings Announcements for",-1,"Earnings Announcements for",1)
Thanks
Now that earnings.com has moved and changed significantly, I'm trying to import the Yahoo Earnings Calendar into Excel. I'd like to pull in the entire calendar from yesterday, today, and tomorrow. So far I've tried countless combinations of PFinds and PDirs with RCHGetHTMLTable(
My last try was array entering the following:
=rchgetHTMLTable(
Thanks
Tue Jun 25, 2013 8:10 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The problem is that your search string doesn't exist in the document. It
was coded as:
<b>Earnings
Announcements for
Wednesday, June 26</b>
...so it wraps and has other characters in it. Instead, try:
=RCHGetHTMLTable("http://biz.yahoo.com/research/earncal/20130626.html
",">Conference",-1,"",1)
On Tue, Jun 25, 2013 at 6:55 AM, bs2167 <bs2167@yahoo.com > wrote:
>
> Now that earnings.com has moved and changed significantly, I'm trying to
> import the Yahoo Earnings Calendar into Excel. I'd like to pull in the
> entire calendar from yesterday, today, and tomorrow. So far I've tried
> countless combinations of PFinds and PDirs with RCHGetHTMLTable() but with
> no luck - all cells are either blank or full of errors. If anyone could
> help with what I'm doing wrong I would very much appreciate it.
>
> My last try was array entering the following:
>
> =rchgetHTMLTable("http://biz.yahoo.com/research/earncal/20130626.html ","Earnings
> Announcements for",-1,"Earnings Announcements for",1)
>
was coded as:
<b>Earnings
Announcements for
Wednesday, June 26</b>
...so it wraps and has other characters in it. Instead, try:
=RCHGetHTMLTable(
","
On Tue, Jun 25, 2013 at 6:55 AM, bs2167 <bs2167@yahoo.
>
> Now that earnings.com has moved and changed significantly, I'm trying to
> import the Yahoo Earnings Calendar into Excel. I'd like to pull in the
> entire calendar from yesterday, today, and tomorrow. So far I've tried
> countless combinations of PFinds and PDirs with RCHGetHTMLTable(
> no luck - all cells are either blank or full of errors. If anyone could
> help with what I'm doing wrong I would very much appreciate it.
>
> My last try was array entering the following:
>
> =rchgetHTMLTable(
> Announcements for",-1,
>
Tue Jun 25, 2013 8:22 am (PDT) . Posted by:
"bs2167" bs2167
Thank you Randy. I see (I think)...if I'm understanding correctly, the search string I enter has to match the entire string inside a > < pair... is that correct?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The problem is that your search string doesn't exist in the document. It
> was coded as:
>
> <b>Earnings
> Announcements for
> Wednesday, June 26</b>
>
> ...so it wraps and has other characters in it. Instead, try:
>
> =RCHGetHTMLTable("http://biz.yahoo.com/research/earncal/20130626.html
> ",">Conference",-1,"",1)
>
> On Tue, Jun 25, 2013 at 6:55 AM, bs2167 <bs2167@...> wrote:
>
> >
> > Now that earnings.com has moved and changed significantly, I'm trying to
> > import the Yahoo Earnings Calendar into Excel. I'd like to pull in the
> > entire calendar from yesterday, today, and tomorrow. So far I've tried
> > countless combinations of PFinds and PDirs with RCHGetHTMLTable() but with
> > no luck - all cells are either blank or full of errors. If anyone could
> > help with what I'm doing wrong I would very much appreciate it.
> >
> > My last try was array entering the following:
> >
> > =rchgetHTMLTable("http://biz.yahoo.com/research/earncal/20130626.html ","Earnings
> > Announcements for",-1,"Earnings Announcements for",1)
> >
>
--- In smf_addin@yahoogrou
>
> The problem is that your search string doesn't exist in the document. It
> was coded as:
>
> <b>Earnings
> Announcements for
> Wednesday, June 26</b>
>
> ...so it wraps and has other characters in it. Instead, try:
>
> =RCHGetHTMLTable(
> ","
>
> On Tue, Jun 25, 2013 at 6:55 AM, bs2167 <bs2167@.
>
> >
> > Now that earnings.com has moved and changed significantly, I'm trying to
> > import the Yahoo Earnings Calendar into Excel. I'd like to pull in the
> > entire calendar from yesterday, today, and tomorrow. So far I've tried
> > countless combinations of PFinds and PDirs with RCHGetHTMLTable(
> > no luck - all cells are either blank or full of errors. If anyone could
> > help with what I'm doing wrong I would very much appreciate it.
> >
> > My last try was array entering the following:
> >
> > =rchgetHTMLTable(
> > Announcements for",-1,
> >
>
Tue Jun 25, 2013 8:32 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
No. Just enough to be unique. Or use multiple search terms so that the last
one is unique and gets you to where you need to be.
The add-in strips out carriage returns and line feeds, so the actual search
for your term would have been:
=RCHGetHTMLTable("http://biz.yahoo.com/research/earncal/20130626.html ",
"EarningsAnnouncements for",-1,"",1)
On Tue, Jun 25, 2013 at 8:22 AM, bs2167 <bs2167@yahoo.com > wrote:
> Thank you Randy. I see (I think)...if I'm understanding correctly, the
> search string I enter has to match the entire string inside a > < pair...
> is that correct?
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > The problem is that your search string doesn't exist in the document. It
> > was coded as:
> >
> > <b>Earnings
> > Announcements for
> > Wednesday, June 26</b>
> >
> > ...so it wraps and has other characters in it. Instead, try:
> >
> > =RCHGetHTMLTable("http://biz.yahoo.com/research/earncal/20130626.html
> > ",">Conference",-1,"",1)
>
one is unique and gets you to where you need to be.
The add-in strips out carriage returns and line feeds, so the actual search
for your term would have been:
=RCHGetHTMLTable(
"EarningsAnnou
On Tue, Jun 25, 2013 at 8:22 AM, bs2167 <bs2167@yahoo.
> Thank you Randy. I see (I think)...if I'm understanding correctly, the
> search string I enter has to match the entire string inside a > < pair...
> is that correct?
>
> --- In smf_addin@yahoogrou
> >
> > The problem is that your search string doesn't exist in the document. It
> > was coded as:
> >
> > <b>Earnings
> > Announcements for
> > Wednesday, June 26</b>
> >
> > ...so it wraps and has other characters in it. Instead, try:
> >
> > =RCHGetHTMLTable(
> > ","
>
Tue Jun 25, 2013 9:40 am (PDT) . Posted by:
"bs2167" bs2167
Ah, now I've got it. Thanks again.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> No. Just enough to be unique. Or use multiple search terms so that the last
> one is unique and gets you to where you need to be.
>
> The add-in strips out carriage returns and line feeds, so the actual search
> for your term would have been:
>
> =RCHGetHTMLTable("http://biz.yahoo.com/research/earncal/20130626.html ",
> "EarningsAnnouncements for",-1,"",1)
>
> On Tue, Jun 25, 2013 at 8:22 AM, bs2167 <bs2167@...> wrote:
>
> > Thank you Randy. I see (I think)...if I'm understanding correctly, the
> > search string I enter has to match the entire string inside a > < pair...
> > is that correct?
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > The problem is that your search string doesn't exist in the document. It
> > > was coded as:
> > >
> > > <b>Earnings
> > > Announcements for
> > > Wednesday, June 26</b>
> > >
> > > ...so it wraps and has other characters in it. Instead, try:
> > >
> > > =RCHGetHTMLTable("http://biz.yahoo.com/research/earncal/20130626.html
> > > ",">Conference",-1,"",1)
> >
>
--- In smf_addin@yahoogrou
>
> No. Just enough to be unique. Or use multiple search terms so that the last
> one is unique and gets you to where you need to be.
>
> The add-in strips out carriage returns and line feeds, so the actual search
> for your term would have been:
>
> =RCHGetHTMLTable(
> "EarningsAnnou
>
> On Tue, Jun 25, 2013 at 8:22 AM, bs2167 <bs2167@.
>
> > Thank you Randy. I see (I think)...if I'm understanding correctly, the
> > search string I enter has to match the entire string inside a > < pair...
> > is that correct?
> >
> > --- In smf_addin@yahoogrou
> > >
> > > The problem is that your search string doesn't exist in the document. It
> > > was coded as:
> > >
> > > <b>Earnings
> > > Announcements for
> > > Wednesday, June 26</b>
> > >
> > > ...so it wraps and has other characters in it. Instead, try:
> > >
> > > =RCHGetHTMLTable(
> > > ","
> >
>
Tue Jun 25, 2013 12:00 pm (PDT) . Posted by:
"bobjerritts" bobjerritts
Hi,
Are there any spreadsheets to backtest stock performances?
Bob j
Are there any spreadsheets to backtest stock performances?
Bob j
Tue Jun 25, 2013 12:07 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
No. The add-in is a tool for doing things like due diligence on a few
stocks, not for building databases for screening and/or backtesting.
Getting proper data for backtesting is very difficult, because you need it
to be "point-in-time", without a survivorship bias.
The best backtester I know is portfolio123.com.
On Tue, Jun 25, 2013 at 11:17 AM, bobjerritts <bobjerritts@yahoo.com > wrote:
>
> Are there any spreadsheets to backtest stock performances?
>
stocks, not for building databases for screening and/or backtesting.
Getting proper data for backtesting is very difficult, because you need it
to be "point-
The best backtester I know is portfolio123.
On Tue, Jun 25, 2013 at 11:17 AM, bobjerritts <bobjerritts@
>
> Are there any spreadsheets to backtest stock performances?
>
Tue Jun 25, 2013 7:34 pm (PDT) . Posted by:
"V. Shankar" tarakayan
what exactly is this?
________________________________
From: Randy H <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Tuesday, June 25, 2013 1:33 PM
Subject: [smf_addin] Re: MSN Moneycentral Investor Stock Quotes in excel..
Sounds like adding a third parameter may help?
http://www.excelforum.com/excel-formulas-and-functions/932893-msn-stock-quotes-plugin-stopped-working-june-2013-a.html
____________
From: Randy H <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Tuesday, June 25, 2013 1:33 PM
Subject: [smf_addin] Re: MSN Moneycentral Investor Stock Quotes in excel..
Sounds like adding a third parameter may help?
http://www.excelfor
Tue Jun 25, 2013 8:09 pm (PDT) . Posted by:
"ron125" ron125
Thanks for sending the link to the directions. Unfortunately, I am using office 2010. Is there a way to get this to work in office 2010?
I created a new folder called "SMF Add-In" in the directory "C:\Program Files\". Then extracted the file to the new directory folder.
After that I tried to install the add-in as directed by the Quick start: Activate and use an add-in: http://office.microsoft.com/en-us/excel-help/quick-start-activate-and-use-an-add-in-HA010370161.aspx It did say, You can use the same general process for installing and activating many other add-ins.
I went to File>Options>Add-ins> I had to browse "Ad-ins" and did not see it. I browsed the location and added it. The add-in showed up in the dialogue along with one other from Microsoft. . However, the add-in does not show up on the top of the add-in tab.
I tried the process again, and when trying to install the add-in I get a message saying the add-in exists in this location. Do you want to replace it? If I say yes, I get a message saying, cannot find the add in.
Any Idea as to why this is happening? And more importantly, how can I get this to work.
--- In smf_addin@yahoogroups.com , "Kermit W. Prather" <kermitp@...> wrote:
>
> Here is an excellent write-up on installing the SMF ADDIN. Even my wife could follow it.
>
> So I have attached a very small spreadsheet that will test for a proper install.
>
> <http://www.traineetrader.com/importing-stock-quotes-to-excel-using-smf-add-in/ > http://www.traineetrader.com/importing-stock-quotes-to-excel-using-smf-add-in/
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
> Sent: Friday, June 21, 2013 1:51 PM
> To: smf_addin@yahoogroups.com
> Subject: Re: [smf_addin] Re: MSN moved the goal posts
>
>
>
> You'd need to install the SMF add-in found the FILES area. Documentation is in the DOCUMENTATION folder. Tips and FAQ are in the LINKS area of the group, including several links to several blogs of people showing step-by-step instructions for installing the add-in.
> On Fri, Jun 21, 2013 at 10:32 AM, ron125 <ron125@...> wrote:
> I have been looking and cannot find the function. I'm assuming I need to set this up as an add-in like I did with MSN stock quotes.
>
> I did try entering the following in the first row:
> ARNA #NAME?
> The first row is the stock symbol and the second row has =RCHGetYahooQuotes( "ARNA","l1" )
>
> What am I missing?
>
I created a new folder called "SMF Add-In" in the directory "C:\
After that I tried to install the add-in as directed by the Quick start: Activate and use an add-in: http://office.
I went to File>Options>
I tried the process again, and when trying to install the add-in I get a message saying the add-in exists in this location. Do you want to replace it? If I say yes, I get a message saying, cannot find the add in.
Any Idea as to why this is happening? And more importantly, how can I get this to work.
--- In smf_addin@yahoogrou
>
> Here is an excellent write-up on installing the SMF ADDIN. Even my wife could follow it.
>
> So I have attached a very small spreadsheet that will test for a proper install.
>
> <http://www.traineet
>
> From: smf_addin@yahoogrou
> Sent: Friday, June 21, 2013 1:51 PM
> To: smf_addin@yahoogrou
> Subject: Re: [smf_addin] Re: MSN moved the goal posts
>
>
>
> You'd need to install the SMF add-in found the FILES area. Documentation is in the DOCUMENTATION folder. Tips and FAQ are in the LINKS area of the group, including several links to several blogs of people showing step-by-step instructions for installing the add-in.
> On Fri, Jun 21, 2013 at 10:32 AM, ron125 <ron125@.
> I have been looking and cannot find the function. I'm assuming I need to set this up as an add-in like I did with MSN stock quotes.
>
> I did try entering the following in the first row:
> ARNA #NAME?
> The first row is the stock symbol and the second row has =RCHGetYahooQuotes( "ARNA"
>
> What am I missing?
>
Tue Jun 25, 2013 8:21 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
There's no reason it would show up on the add-in tab.
The SMF add-in is primarily a collection of user-defined functions.
An easy check to see if the add-in has been installed:
=RCHGetElementNumber("Version")
If this returns #NAME?, it's not installed. Otherwise, it should tell you
what version of the add-in you have installed.
On Tue, Jun 25, 2013 at 8:09 PM, ron125 <ron125@yahoo.com > wrote:
>
> I went to File>Options>Add-ins> I had to browse "Ad-ins" and did not see
> it. I browsed the location and added it. The add-in showed up in the
> dialogue along with one other from Microsoft. . However, the add-in does
> not show up on the top of the add-in tab.
>
> I tried the process again, and when trying to install the add-in I get a
> message saying the add-in exists in this location. Do you want to replace
> it? If I say yes, I get a message saying, cannot find the add in.
>
The SMF add-in is primarily a collection of user-defined functions.
An easy check to see if the add-in has been installed:
=RCHGetElementNumbe
If this returns #NAME?, it's not installed. Otherwise, it should tell you
what version of the add-in you have installed.
On Tue, Jun 25, 2013 at 8:09 PM, ron125 <ron125@yahoo.
>
> I went to File>Options>
> it. I browsed the location and added it. The add-in showed up in the
> dialogue along with one other from Microsoft. . However, the add-in does
> not show up on the top of the add-in tab.
>
> I tried the process again, and when trying to install the add-in I get a
> message saying the add-in exists in this location. Do you want to replace
> it? If I say yes, I get a message saying, cannot find the add in.
>
Tidak ada komentar:
Posting Komentar