Kamis, 07 Maret 2013

[smf_addin] Digest Number 2534

11 New Messages

Digest #2534
1a
earnings date + before or after close information by "christine.vankuik" christine.vankuik
2a
4
3/7/2013 2:45:15 AM by "Gareth Green" greenaces555
5a
Re: What does the "s" stand for? by "bikeflagaz" bikeflagaz

Messages

Wed Mar 6, 2013 7:09 am (PST) . Posted by:

"christine.vankuik" christine.vankuik

Hi Randy,

first of all thanks for all your work to come with this great tool - I use zacks now for the earnings but like to use earnings whisper because they also have the before or after close information so that I know precise the release.

I use the following command to get the date (which works) but I can not get the after or before data (because of the string before is empty, so I can not refer to, any thoughts how to get the after/before info)

RCHGetTableCell("http://www.earningswhispers.com/stocks.asp?symbol=~~~~~",1,"Release Date:")

here an example of stock NQ weblink to take a look:

http://www.earningswhispers.com/stocks.asp?symbol=nq

thanks again would be very helpful, maybe also for others!

Christine

Wed Mar 6, 2013 7:11 am (PST) . Posted by:

"Randy Harmelink" rharmelink

You just need to tell it to go to the next row of the table to pick it up.
For example:

=RCHGetTableCell("http://www.earningswhispers.com/stocks.asp?symbol=nq",1,"Release
Date:",,,,1)

On Wed, Mar 6, 2013 at 6:52 AM, christine.vankuik <
christine.vankuik@yahoo.com> wrote:

>
> I use the following command to get the date (which works) but I can not
> get the after or before data (because of the string before is empty, so I
> can not refer to, any thoughts how to get the after/before info)
>
> RCHGetTableCell("http://www.earningswhispers.com/stocks.asp?symbol=~~~~~",1,"Release
> Date:")
>
> here an example of stock NQ weblink to take a look:
>
> http://www.earningswhispers.com/stocks.asp?symbol=nq
>
>

Wed Mar 6, 2013 7:35 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

In using the Stockscores spreadsheet I am getting an error on SIRI but
looking at the web page I see no difference between SIRI and WMC both shown
below.

Can you shed any light on why I am getting the error in the 3 cells?



WMC
6
6
0
Bearish
Bullish
Bearish
Bearish
Bearish
Bearish
Bullish
Bullish
Bullish
Bearish
Bullish
Bullish
Dec 27, 2012
Jan 28, 2013
1.45
6.7%


Element number
812
813
811


SIRI
2
7
0
Bullish
Bullish
Bearish
Bearish
Bullish
Bullish
Bullish
Bullish
Bullish
Error
Error
Error
Dec 14, 2012
Dec 27, 2012
0.05
1.6%

This is the content of the cells shown in yellow



RCHGetElementNumber(A108, 812)
RCHGetElementNumber(A108, 813)
RCHGetElementNumber(A108, 811)

812
813
811

RCHGetElementNumber(A110, 812)
RCHGetElementNumber(A110, 813)
RCHGetElementNumber(A110, 811)


Below is the content of the webpage for the area that is being retrieved in
the first error cell

_____

SIRI
<tr>
<td class=table-content1>10 Day Trend </td>
<td class=table-content1><img
src="images/bullish_small.gif" border=0 alt="Bullish&quot;> bullish</td>
</tr>
_____

WMC

<tr>
<td class=table-content1>10 Day Trend </td>
<td class=table-content1><img
src="images/bullish_small.gif" border=0 alt="Bullish&quot;> bullish</td>
</tr>
_____

Wed Mar 6, 2013 8:23 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Those thee elements work fine for me with SIRI. I suspect you got a bad
copy of the web page -- timed out, being updated, corrupted, whatever.

If you're still getting the Error, you can try the
smfGetTagContent-Quick-Webpage-Examination.xls template with this URL:

http://www.stockscores.com/quickreport.asp?ticker=SIRI

That should allow you to examine the saved copy you have of the web page to
see what might be an issue.

On Wed, Mar 6, 2013 at 8:35 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:

>
> In using the Stockscores spreadsheet I am getting an error on SIRI but
> looking at the web page I see no difference between SIRI and WMC both shown
> below.****
>
> ** **
>
> Can you shed any light on why I am getting the error in the 3 cells? ****
>
> ** **
>
> ** **
>
> WMC****
>
> *6*
>
> *6*
>
> *0*
>
> Bearish****
>
> Bullish****
>
> Bearish****
>
> Bearish****
>
> Bearish****
>
> Bearish****
>
> Bullish****
>
> Bullish****
>
> Bullish****
>
> Bearish****
>
> Bullish****
>
> Bullish****
>
> Dec 27, 2012****
>
> Jan 28, 2013****
>
> 1.45****
>
> 6.7%****
>
> Element number****
>
> 812****
>
> 813****
>
> 811****
>
> SIRI****
>
> *2*
>
> *7*
>
> *0*
>
> Bullish****
>
> Bullish****
>
> Bearish****
>
> Bearish****
>
> Bullish****
>
> Bullish****
>
> Bullish****
>
> Bullish****
>
> Bullish****
>
> Error****
>
> Error****
>
> Error****
>
> Dec 14, 2012****
>
> Dec 27, 2012****
>
> 0.05****
>
> 1.6%****
>
> ** **
>
> This is the content of the cells shown in yellow****
>
> ** **
>
> ** **
>
> RCHGetElementNumber(A108, 812)****
>
> RCHGetElementNumber(A108, 813)****
>
> RCHGetElementNumber(A108, 811)****
>
> 812****
>
> 813****
>
> 811****
>
> RCHGetElementNumber(A110, 812)****
>
> RCHGetElementNumber(A110, 813)****
>
> RCHGetElementNumber(A110, 811)****
>
> ** **
>
> ** **
>
> Below is the content of the webpage for the area that is being retrieved
> in the first error cell****
>
> ** **
> ------------------------------
>
> SIRI****
>
> <tr>****
>
> <td class=table-content1>10 Day Trend </td>****
>
> <td class=table-content1><img src
> ="images/bullish_small.gif" border=0 alt="Bullish&quot;> bullish</td>****
>
> </tr>****
> ------------------------------
>
> WMC****
>
> ** **
>
> <tr>****
>
> <td class=table-content1>10 Day Trend </td>****
>
> <td class=table-content1><img src
> ="images/bullish_small.gif" border=0 alt="Bullish&quot;> bullish</td>****
>
> </tr>****
> ------------------------------
>
> ** **
>
>
>

Wed Mar 6, 2013 4:47 pm (PST) . Posted by:

"njouellette83" njouellette83

Below I put a chart of the information I am looking for I am needing the stock price for the annual high and annual low. I have attempted to use the formula below but this will only provide me with a targeted date for information I am looking for. I am not sure how to build the formula, any help would be greatly appreciated. In fact just a simple formula on the historical stock price annual high and low would be awesome assistance.

=RCHGetYahooHistory(C6,YEAR(TODAY()-365),MONTH(TODAY()),DAY(TODAY()),YEAR(TODAY()-365),MONTH(TODAY()),DAY(TODAY()),"d","c",0)

Price
Year High Low
Year 6 16.33 6.87
Year 5 23.50 13.53
Year 4 28.67 17.42
Year 3 36.57 26.74
Year 2 46.23 31.54
Year 1 116.17 92.50

Wed Mar 6, 2013 4:50 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I'd recommend just retrieving the entire array of history, and extracting
what you need from that array. Otherwise, to fill out that table would
require 12 Internet accesses.

The retrieved array of historical quotes could even be on a monthly basis.

On Wed, Mar 6, 2013 at 3:17 PM, njouellette83 <nouellette83@gmail.com>wrote:

> Below I put a chart of the information I am looking for I am needing the
> stock price for the annual high and annual low. I have attempted to use the
> formula below but this will only provide me with a targeted date for
> information I am looking for. I am not sure how to build the formula, any
> help would be greatly appreciated. In fact just a simple formula on the
> historical stock price annual high and low would be awesome assistance.
>
>
> =RCHGetYahooHistory(C6,YEAR(TODAY()-365),MONTH(TODAY()),DAY(TODAY()),YEAR(TODAY()-365),MONTH(TODAY()),DAY(TODAY()),"d","c",0)
>
> Price
> Year High Low
> Year 6 16.33 6.87
> Year 5 23.50 13.53
> Year 4 28.67 17.42
> Year 3 36.57 26.74
> Year 2 46.23 31.54
> Year 1 116.17 92.50
>

Wed Mar 6, 2013 6:11 pm (PST) . Posted by:

"njouellette83" njouellette83

Do you know a formula to pull the entire array for 6 years of high low pricing?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I'd recommend just retrieving the entire array of history, and extracting
> what you need from that array. Otherwise, to fill out that table would
> require 12 Internet accesses.
>
> The retrieved array of historical quotes could even be on a monthly basis.
>
> On Wed, Mar 6, 2013 at 3:17 PM, njouellette83 <nouellette83@...>wrote:
>
> > Below I put a chart of the information I am looking for I am needing the
> > stock price for the annual high and annual low. I have attempted to use the
> > formula below but this will only provide me with a targeted date for
> > information I am looking for. I am not sure how to build the formula, any
> > help would be greatly appreciated. In fact just a simple formula on the
> > historical stock price annual high and low would be awesome assistance.
> >
> >
> > =RCHGetYahooHistory(C6,YEAR(TODAY()-365),MONTH(TODAY()),DAY(TODAY()),YEAR(TODAY()-365),MONTH(TODAY()),DAY(TODAY()),"d","c",0)
> >
> > Price
> > Year High Low
> > Year 6 16.33 6.87
> > Year 5 23.50 13.53
> > Year 4 28.67 17.42
> > Year 3 36.57 26.74
> > Year 2 46.23 31.54
> > Year 1 116.17 92.50
> >
>

Wed Mar 6, 2013 6:19 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I would just array-enter this over a large enough range to contain the data
you need:

=RCHGetYahooHistory(C6,,,,,,,,,,1)

On Wed, Mar 6, 2013 at 7:11 PM, njouellette83 <nouellette83@gmail.com>wrote:

> Do you know a formula to pull the entire array for 6 years of high low
> pricing?
>

Wed Mar 6, 2013 6:35 pm (PST) . Posted by:

"bikeflagaz" bikeflagaz

The number before the "s" is the coupon rate of the bond.

So, "7s" is the same as "sevens" indicated a 7% coupon rate.

--- In smf_addin@yahoogroups.com, "tranlehung2008" <tranlehung2008@...> wrote:
>
> I saw something like 7s Note or 15s Bond somewhere in a book. May you explain to me what the 's' stands for?
> Thank you.
>

Thu Mar 7, 2013 2:13 am (PST) . Posted by:

"aronnisch" aronnisch

Hi,

the down function does not work with ecimals in strike price. Example 15 works, 200 works but noz 17.5 or 17,5. In the same cell.
The options exists.

smfGetOptionQuotes&quot;gntx Jun 2013 17,5 Put";"a";0;"Y"
smfGetOptionQuotes&quot;gntx Jun 2013 17.5 Put";"a";0;"Y"

What do i am wrong?

best wishes
Axel

Diposting oleh EXCEL FEED LEARNING di 02.16

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)