Selasa, 19 Maret 2013

[smf_addin] Digest Number 2552

12 New Messages

Digest #2552
1a
Re: More GetYahooQuotes? Next Earnings Date. by "Randy Harmelink" rharmelink
4b
6a
Re: smfGetTagContent standalone file by "Jovica Bozic" jovica.bozic
6b
Re: smfGetTagContent standalone file by "Randy Harmelink" rharmelink
6c
Re: smfGetTagContent standalone file by "Jovica Bozic" jovica.bozic
6d
Re: smfGetTagContent standalone file by "Randy Harmelink" rharmelink

Messages

Mon Mar 18, 2013 2:24 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

As far as I know, the next earnings date is not available on Yahoo's CSV
file interface.

There are more data codes, but most are HTML-encoded formatting, for one
purpose or another within Yahoo. But not useful within EXCEL. For example,
this:

=RCHGetYahooQuotes("MMM","h2")

...returns:

</tr></table></td>

However, the next earnings date is available as one of the fields on the
FinViz CSV file. Check out the entry on FinViz extraction in the LINKS area
of the Yahoo group. For example, this:

=smfGetCSVFile("http://finviz.com/export.ashx?v=151&t=MMM,NFLX&c=1,3,4,5,68
")

...returns a few fields not available on the Yahoo CSV file:

Ticker Sector Industry Country Earnings Date MMM Conglomerates
Conglomerates USA 4/25/2013 8:30:00 AM NFLX Services Music & Video Stores
USA 1/23/2013 4:30:00 PM

Note that NFLX has the previous earnings date because a new one hasn't been
announced. Yahoo has "N/A" for the date on their quotes page.

On Mon, Mar 18, 2013 at 1:57 PM, friedman_steve <friedman_steve@yahoo.com>wrote:

> Randy,
> regarding the RCHGetYahooQuotes() function.
>
> The documentation that lays out all the codes mentions that these are
> "Here is a table listing the most commonly used data codes:"
>
> Are there more data codes for this? If so where?
> I'm specifically trying to find code to download the Upcoming Earnings
> Date.
>
> When i go directly the website: http://finance.yahoo.com/q?s=AAPL
> I see it given as April 23.
>
> The GetElementNumber 1285 code you have for upcoming earnings date
> references a different Yahoo site that doesn't always have the data (for
> example, with AAPL, it doesn't show up at (
> http://finance.yahoo.com/q/ae?s=aapl&ql=1) , while for IBM it does).
>
> Is there a GetYahooQuote code to grab it?
>

Mon Mar 18, 2013 5:29 pm (PDT) . Posted by:

"Pete A" option2z

Of course, it depends on what's holding things up. IF you are bound by slow Internet, CPU speed isn't much of a problem. IF you have large spreadsheets with lots of calculations...CPU is important. In my case, I do lots of both. Did some tests, and when I changed to an I7 from an older Intel laptop, my calc speed more than doubled; the I/O (Internet) didn't improve much.
Pete A

--- In smf_addin@yahoogroups.com, "andyha8" <andyha8@...> wrote:
>
> I have an Athlon II 620. I find it very slow when making my spreadsheet calculations. Is it my CPU or is the process just slow? I am thinking of getting a core i7. Do you think this would improve the excel calculation speed? What are people's experiences with this.
> Thanks everyone
>

Mon Mar 18, 2013 6:59 pm (PDT) . Posted by:

"freefaller6" freefaller6

Hi Randy, first, I am a huge fan of this add-in! It's amazing really. I am having trouble with opening the templates, however. For example, when I click on the template, SMF-Template-Barchart-Market-Momentum.xls, all of the boxes are populate by #NAME? What am I doing wrong? I guess that is part I of my question. Part II is that I am looking for stocks hitting their lows. Is that possible with this add-in?

Thanks again!

Mon Mar 18, 2013 7:40 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

For the #NAME? error, check out the location errors entry in the LINKS area
of the group.

If you look at this page on barchart:

http://www.barchart.com/stocks/marketoverview

...you'll see the navigation bar on the left has a lot of stock market
lists, including stocks hitting new lows. I think those tables can all be
retrieved. For example:

=RCHGetHTMLTable("http://www.barchart.com/stocks/low.php",">Change",-1,"",1)

You can also find a lot of such lists here:

http://stockcharts.com/def/servlet/SC.scan

Getting the new lows from there:

=RCHGetHTMLTable("
http://stockcharts.com/def/servlet/SC.scan?s=TSAL[t.t_eq_s]![as0,20,tv_gt_40000]![tl0_lt_an1,260,tl]&report=predefall
",">Sector",-1,"",1)

On Mon, Mar 18, 2013 at 6:59 PM, freefaller6 <freefaller6@yahoo.com> wrote:

> Hi Randy, first, I am a huge fan of this add-in! It's amazing really. I
> am having trouble with opening the templates, however. For example, when I
> click on the template, SMF-Template-Barchart-Market-Momentum.xls, all of
> the boxes are populate by #NAME? What am I doing wrong? I guess that is
> part I of my question. Part II is that I am looking for stocks hitting
> their lows. Is that possible with this add-in?
>

Mon Mar 18, 2013 8:48 pm (PDT) . Posted by:

"Lawrence" lawleesh

Hi Randy

Yahoo Finance gives four years of historical P&L and B/S. Is there a way (e.g. via addin) to download revenue, eps, etc into excel?

thanks

LL

Mon Mar 18, 2013 9:07 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Check out the template in the FILES area:

RCHGetTableCell-Template-Yahoo-Financial-Statements.xls

On Mon, Mar 18, 2013 at 8:48 PM, Lawrence <lawrence.leesh@gmail.com> wrote:

>
> Yahoo Finance gives four years of historical P&L and B/S. Is there a way
> (e.g. via addin) to download revenue, eps, etc into excel?
>

Mon Mar 18, 2013 9:05 pm (PDT) . Posted by:

"bobmikejohn1" bobmikejohn1

Just a newbie trying to get started with smf

How would I pull the yield from this site:
http://web.tmxmoney.com/quote.php?qm_symbol=RY

The yield reported by the above site of 4.188 is different than
than what yahoo.finance says, 3.80
http://ca.finance.yahoo.com/q/ks?s=RY.TO

does anyone know why the two are different.

Thank you.

Mon Mar 18, 2013 9:13 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

This should do the trick:

=RCHGetTableCell("http://web.tmxmoney.com/quote.php?qm_symbol=RY
",1,"Yield:")

The reason for the difference is Yahoo is showing a yield based on trailing
dividend amounts. The large amount is based on the assumption of the
upcoming $0.63 dividend continuing.

On Mon, Mar 18, 2013 at 8:38 PM, bobmikejohn1 <en905a@gmail.com> wrote:

> Just a newbie trying to get started with smf
>
> How would I pull the yield from this site:
> http://web.tmxmoney.com/quote.php?qm_symbol=RY
>
> The yield reported by the above site of 4.188 is different than
> than what yahoo.finance says, 3.80
> http://ca.finance.yahoo.com/q/ks?s=RY.TO
>
> does anyone know why the two are different.
>

Mon Mar 18, 2013 10:18 pm (PDT) . Posted by:

"Jovica Bozic" jovica.bozic

All libraries on your list were already checked. Now I am getting another compile error in smfGetWebPage function, line: "s2 = Replace(s2,"&amp;","&") --- "Compile error Wrong number of arguments or invalid property assignment".

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> While in the VBA environment for your worksheet, you need to use the >
> Tools > References menu option and tell it which external load libraries to
> use.
>
> Here is the list I use with the add-in:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/10140
>
> But I don't think you need all of them for the functions you're using. The
> compile error you're getting is because the XML library is missing.
>
> On Mon, Mar 18, 2013 at 12:39 PM, Jovica Bozic <jovica.bozic@...>wrote:
>
> > I did everything you told me except number 4."Added references for the
> > Visual Basic for Applications and Microsoft XML libraries" which I don't
> > understand. My knowledge here is insufficient.
> >
> > Without number 4. I get this error : compile error usern-defined type not
> > defined in RCHGetURLData1 function line : Dim oHTTP As New XMLHTTP.
> >
> > --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> > >
> > > Here's what I did:
> > >
> > > 1. Exported the modCovertData, modUtilities, and modGetTagContent
> > > modules from the add-in.
> > > 2. Open a new workbook
> > > 3. Imported those three exported modules into the VBA environment for
> > > the new workbook
> > > 4. Added references for the Visual Basic for Applications and
> > Microsoft
> > > XML libraries
> > >
> > > From there, it appeared to work...
> >
>

Mon Mar 18, 2013 10:35 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I don't see such a line in that function.

On Mon, Mar 18, 2013 at 10:18 PM, Jovica Bozic <jovica.bozic@yahoo.com>wrote:

> All libraries on your list were already checked. Now I am getting another
> compile error in smfGetWebPage function, line: "s2 = Replace(s2,"&","&")
> --- "Compile error Wrong number of arguments or invalid property
> assignment".
>

Mon Mar 18, 2013 11:04 pm (PDT) . Posted by:

"Jovica Bozic" jovica.bozic

Public Function smfGetWebPage(ByVal pURL As String, _
Optional ByVal pUseIE As Integer = 0, _
Optional ByVal pConvType As Integer = 0) As String
'----------------------------------------------------------*
' 2011.02.16 -- Add routine
' 2011.04.27 -- Add HTML codes &#48; thru &#57;
'----------------------------------------------------------*
For iData = 1 To kPages
Select Case True
Case aData(iData, 1) = ""
s2 = RCHGetURLData(pURL, pUseIE)
Select Case pConvType
Case 0
this line-----> s2 = Replace(s2, "&amp;", "&")
s2 = Replace(s2, "&nbsp;<b>", "<b> ")
s2 = Replace(s2, "&nbsp;", " ")
s2 = Replace(s2, Chr(9), " ")
s2 = Replace(s2, Chr(10), "")
s2 = Replace(s2, Chr(13), "")

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I don't see such a line in that function.
>
> On Mon, Mar 18, 2013 at 10:18 PM, Jovica Bozic <jovica.bozic@...>wrote:
>
> > All libraries on your list were already checked. Now I am getting another
> > compile error in smfGetWebPage function, line: "s2 = Replace(s2,"&","&")
> > --- "Compile error Wrong number of arguments or invalid property
> > assignment".
> >
>

Mon Mar 18, 2013 11:41 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Ahhh. My email client is resolving the text differently than what you
posted...see below.

Doing a Google search, it seems to imply this would happen if you had your
a duplicate REPLACE() function...? It should be coming from the Visual
Basic for Applications DLL.

On Mon, Mar 18, 2013 at 11:04 PM, Jovica Bozic <jovica.bozic@yahoo.com>wrote:

> Public Function smfGetWebPage(ByVal pURL As String, _
> Optional ByVal pUseIE As Integer = 0, _
> Optional ByVal pConvType As Integer = 0) As String
>
> '----------------------------------------------------------*
> ' 2011.02.16 -- Add routine
> ' 2011.04.27 -- Add HTML codes 0 thru 9
>
> '----------------------------------------------------------*
> For iData = 1 To kPages
> Select Case True
> Case aData(iData, 1) = ""
> s2 = RCHGetURLData(pURL, pUseIE)
> Select Case pConvType
> Case 0
> this line-----> s2 = Replace(s2, "&", "&")
> s2 = Replace(s2, " <b>", "<b> ")
> s2 = Replace(s2, " ", " ")
> s2 = Replace(s2, Chr(9), " ")
> s2 = Replace(s2, Chr(10), "")
> s2 = Replace(s2, Chr(13), "")
>
>

Tidak ada komentar:

Posting Komentar