Kamis, 18 Juli 2013

[smf_addin] Digest Number 2699

15 New Messages

Digest #2699
1a
Re: need indian market Addin by "Dhaval Shah" dashah1381
1b
Re: need indian market Addin by "Randy Harmelink" rharmelink
2a
Quotations from Yahoo by "h_dvir" h_dvir
2b
Re: Quotations from Yahoo by "Randy Harmelink" rharmelink
2c
Re: Quotations from Yahoo by "Dvir Harmelech" h_dvir
2d
Re: Quotations from Yahoo by "Randy Harmelink" rharmelink
3a
Re: Data from Finra by "gbullr" gbullr
3b
Re: Data from Finra by "Randy Harmelink" rharmelink
3c
Re: Data from Finra by "gbullr" gbullr
3d
Re: Data from Finra by "Randy Harmelink" rharmelink
4a
Earnings.com Data by "bablam" bablam
4b
Re: Earnings.com Data by "Randy Harmelink" rharmelink
4c
Re: Earnings.com Data by "Manish Babla" bablam
5a
Advfn quarterly reports not updating by "ajtalukdar" ajtalukdar
5b
Re: Advfn quarterly reports not updating by "Randy Harmelink" rharmelink

Messages

Thu Jul 18, 2013 1:13 am (PDT) . Posted by:

"Dhaval Shah" dashah1381

no attchment

On Thu, Jul 18, 2013 at 12:50 PM, Randy Harmelink <rharmelink@gmail.com>wrote:

> **
>
>
> Have you tried this one?
>
>
> On Wed, Jul 17, 2013 at 11:40 PM, Dhaval Shah <todhavalshah@gmail.com>wrote:
>
>>
>> i am looking for indian market Addin if any one have pls share
>>
>>
>
>

Thu Jul 18, 2013 1:16 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

There was no reason to attach anything. This whole group is FOR the SMF
add-in. The add-in is in the FILES area, along with documentation and
examples. Reread the front page of the group or your introductory email
from joining the group for more information.

On Thu, Jul 18, 2013 at 12:39 AM, Dhaval Shah <todhavalshah@gmail.com>wrote:

>
> no attchment
>

Thu Jul 18, 2013 8:12 am (PDT) . Posted by:

"h_dvir" h_dvir

I am a new user, so I will ask a question at the risk of being naive.

I assumed =smfPricesByDates is using Yahoo.

I can't get a correct reading for "Wells Fargo Warrants" which has a symbol WFC-WT in Yahoo

=smfPricesByDates("WFC-WT",TODAY()) returns #N/A

all other stocks work fine for me.

I will appreciate your help.
Dvir

Thu Jul 18, 2013 8:16 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

That's because Yahoo doesn't carry historical quotes on WFC-WT, which is
what smfPricesByDates() uses.

I'd suggest using RCHGetYahooQuotes() if you want current day quotes,
that's what smfPricesByDates() uses to get the current date quote if
historical quotes exist. By doing it your way, you have to access the
Internet twice to get a quote, and the TODAY() function as a parameter will
make the function volatile (i.e. recalculating any time something in the
workbook changes).

On Thu, Jul 18, 2013 at 4:30 AM, h_dvir <dvir.harmelech@gmail.com> wrote:

> I am a new user, so I will ask a question at the risk of being naive.
>
> I assumed =smfPricesByDates is using Yahoo.
>
> I can't get a correct reading for "Wells Fargo Warrants" which has a
> symbol WFC-WT in Yahoo
>
> =smfPricesByDates("WFC-WT",TODAY()) returns #N/A
>
> all other stocks work fine for me.
>
> I will appreciate your help.
>

Thu Jul 18, 2013 12:33 pm (PDT) . Posted by:

"Dvir Harmelech" h_dvir

Thank you for the fast response. I understand.

I actually was using smfPricesByDates ("WFC-WT",D1) where D1 is a date cell in a table, to create a table of prices-by-date (and use it to plot a time graph)

Is there a way around the problem of the WFC-WT historic values ?

I have found that http://www.investorpoint.com/stock/wfc.ws-Wells%20Fargo%20Co.%20Wt/price-history/ have this information, for example.

Is that a way I could extract the prices from there, of any other place that may have this information ?

Thank you in advance,

Dvir

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Thursday, July 18, 2013 6:17 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Quotations from Yahoo

That's because Yahoo doesn't carry historical quotes on WFC-WT, which is what smfPricesByDates() uses.

I'd suggest using RCHGetYahooQuotes() if you want current day quotes, that's what smfPricesByDates() uses to get the current date quote if historical quotes exist. By doing it your way, you have to access the Internet twice to get a quote, and the TODAY() function as a parameter will make the function volatile (i.e. recalculating any time something in the workbook changes).

On Thu, Jul 18, 2013 at 4:30 AM, h_dvir <dvir.harmelech@gmail.com <mailto:dvir.harmelech@gmail.com> > wrote:

I am a new user, so I will ask a question at the risk of being naive.

I assumed =smfPricesByDates is using Yahoo.

I can't get a correct reading for "Wells Fargo Warrants" which has a symbol WFC-WT in Yahoo

=smfPricesByDates("WFC-WT",TODAY()) returns #N/A

all other stocks work fine for me.

I will appreciate your help.

Thu Jul 18, 2013 2:12 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You should use multiple dates in a single smfPricesByDates() function,
because you need to go to the Internet for data with EACH function
invocation.

I don't know of a work-around without another data source.

The other site you mention can be used, but you would need to get the data
a page at a time:

=RCHGetHTMLTable("
http://www.investorpoint.com/stock/wfc.ws-Wells+Fargo+Co.+Wt/price-history/?page=1&startDay=18&startMonth=5&startYear=2012&endDay=18&endMonth=6&endYear=2013&perPage=100",">Trade
Val",-1,"",1)
=RCHGetHTMLTable("
http://www.investorpoint.com/stock/wfc.ws-Wells+Fargo+Co.+Wt/price-history/?page=2&startDay=18&startMonth=5&startYear=2012&endDay=18&endMonth=6&endYear=2013&perPage=100",">Trade
Val",-1,"",1)

Etc. Or, to get the data for a single day, such as July 1, 2013:

=RCHGetTableCell("
http://www.investorpoint.com/stock/wfc.ws-Wells+Fargo+Co.+Wt/price-history?startDay=1&startMonth=6&startYear=2013&endDay=1&endMonth=6&endYear=2013",4,">Trade
Val","07/01/13")

Note that "startMonth&quot; and "endMonth"; are offset values (i.e. actual month
less 1).

On Thu, Jul 18, 2013 at 12:33 PM, Dvir Harmelech
<dvir.harmelech@gmail.com>wrote:

>
>
> I actually was using smfPricesByDates ("WFC-WT",D1) where D1 is a date
> cell in a table, to create a table of prices-by-date (and use it to plot a
> time graph)****
>
> Is there a way around the problem of the WFC-WT historic values ?****
>
> ** **
>
> I have found that
> http://www.investorpoint.com/stock/wfc.ws-Wells%20Fargo%20Co.%20Wt/price-history/have this information, for example.
> ****
>
> ** **
>
> Is that a way I could extract the prices from there, of any other place
> that may have this information ?****
>
>
>

Thu Jul 18, 2013 9:16 am (PDT) . Posted by:

"gbullr" gbullr

Randy.

How do I attach a file so the next guy that wants FINRA data can start w/ my file and not waste as much time?

--- In smf_addin@yahoogroups.com, "gbullr" <gaston.bullrich@...> wrote:
>
> Thanks again. I will see what I can do w/ your guidance. I had some choice words for the FINRA team.
>
> Best.
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > I would use:
> >
> > =DATEVALUE(SUBSTITUTE(smfStrExtr(RCHGetWebData("
> > http://quotes.morningstar.com/bondquote/quote/c-banner?t=C515717","Last
> > Trade Date")," >","<"),"&#92;",""))
> >
> > The first ">" is much earlier than the date, immediately followed by the
> > "\", so your formula was extracting a null string. I found it easiest to
> > start from the basic extraction:
> >
> > =RCHGetWebData("
> > http://quotes.morningstar.com/bondquote/quote/c-banner?t=C515717","Last
> > Trade Date")
> >
> > ...and go from there.
> >
> > Like I said, it's not really a trivial task to go get all the individual
> > items. :(
> >
> > On Wed, Jul 17, 2013 at 12:06 PM, gbullr <gaston.bullrich@> wrote:
> >
> > > I have changed your function call to this":
> > >
> > > =smfConvertData(smfStrExtr(RCHGetWebData("
> > > http://quotes.morningstar.com/bondquote/quote/c-banner?t=C515717","Last
> > > Trade Date"),">","\"))
> > >
> >
>

Thu Jul 18, 2013 9:30 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Just upload it into the FILES area of the group, into the "Uploads by Forum
Members" folder.

I'm currently working on a file called:

SMF-Template-Morningstar-Dynamic-Workaround.xls

...where one worksheet will be for stocks, another for ETFs, and another
for Mutual Funds. Maybe I can incorporate yours into a Bond worksheet.

Ultimately, the question will be whether to take it a step further and
define them as elements.

Did you see the thread with all of the web pages for stocks and ETFs?
Yikes. It was so nice when everything could be found on a single web page
designed for printing, and then easily extracted...

On Thu, Jul 18, 2013 at 9:16 AM, gbullr <gaston.bullrich@gmail.com> wrote:

>
> How do I attach a file so the next guy that wants FINRA data can start w/
> my file and not waste as much time?
>
>
>
> --- In smf_addin@yahoogroups.com, "gbullr" <gaston.bullrich@...> wrote:
> >
> > Thanks again. I will see what I can do w/ your guidance. I had some
> choice words for the FINRA team.
> >
> > Best.
> >
> > --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> > >
> > > I would use:
> > >
> > > =DATEVALUE(SUBSTITUTE(smfStrExtr(RCHGetWebData("
> > > http://quotes.morningstar.com/bondquote/quote/c-banner?t=C515717
> ","Last
> > > Trade Date")," >","<"),"&#92;",""))
> > >
> > > The first ">" is much earlier than the date, immediately followed by
> the
> > > "\", so your formula was extracting a null string. I found it easiest
> to
> > > start from the basic extraction:
> > >
> > > =RCHGetWebData("
> > > http://quotes.morningstar.com/bondquote/quote/c-banner?t=C515717
> ","Last
> > > Trade Date")
> > >
> > > ...and go from there.
> > >
> > > Like I said, it's not really a trivial task to go get all the
> individual
> > > items. :(
> > >
> > > On Wed, Jul 17, 2013 at 12:06 PM, gbullr <gaston.bullrich@> wrote:
> > >
> > > > I have changed your function call to this":
> > > >
> > > > =smfConvertData(smfStrExtr(RCHGetWebData("
> > > > http://quotes.morningstar.com/bondquote/quote/c-banner?t=C515717
> ","Last
> > > > Trade Date"),">","\"))
> > > >
> > >
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>

Thu Jul 18, 2013 12:33 pm (PDT) . Posted by:

"gbullr" gbullr

How do you find the page that is serving the data ?
Like you did below.

I am looking for what is serving this page:

http://finra-markets.morningstar.com/BondCenter/BondTradeActivitySearchResult.jsp?ticker=C515717&startdate=07%2F18%2F2012&enddate=07%2F18%2F2013

Thank you.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Note that the page you cited actually has the data within a frame. You're
> actually seeing MorningStar data:
>
> http://quotes.morningstar.com/bondquote/quote.action?t=C515717
>
> But they are dynamically loading the data from sourced web pages, and
> extraction from them is not trivial. For example, to get the last traded
> price:
>
> =smfConvertData(smfStrExtr(RCHGetWebData("
> http://quotes.morningstar.com/bondquote/quote/c-banner?t=C515717","Last
> Trade Price"),"&#92;t\t","\"))
>
> The various source web pages:
>
> http://quotes.morningstar.com/bondquote/quote/c-banner?&t=C515717
> http://quotes.morningstar.com/bondquote/quote/c-bond?&t=C515717
> http://quotes.morningstar.com/bondquote/quote/c-classification?&t=C515717
> http://quotes.morningstar.com/bondquote/quote/c-credit?&t=C515717
> http://quotes.morningstar.com/bondquote/quote/c-issue?&t=C515717
> http://quotes.morningstar.com/bondquote/quote/c-redemption?&t=C515717
> http://quotes.morningstar.com/bondquote/quote/c-tax?&t=C515717
>
> Take a look at them and see what a mess they are.
>
> On Wed, Jul 17, 2013 at 10:33 AM, gbullr <gaston.bullrich@...> wrote:
>
> >
> > In advance thank you for this addin, it is a life saver.
> >
> > One of the few places that provides Bond price data is Finra.
> >
> >
> > http://finra-markets.morningstar.com/BondCenter/BondDetail.jsp?ticker=C515717&symbol=AV.GE
> >
> > That link is to a particular bond but I am trying to get price, yield and
> > other data. I have been able to get the data using googlespreadsheets but
> > finra has changed how they serve the data from HTML (I guess) to JSP. My
> > tech terminology may not be correct.
> >
> > Can your addin pull data from these tables if I feed it the right URL.
> >
>

Thu Jul 18, 2013 1:55 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

That one I can't help with, sorry.

On Thu, Jul 18, 2013 at 12:33 PM, gbullr <gaston.bullrich@gmail.com> wrote:

> How do you find the page that is serving the data ?
> Like you did below.
>
> I am looking for what is serving this page:
>
>
> http://finra-markets.morningstar.com/BondCenter/BondTradeActivitySearchResult.jsp?ticker=C515717&startdate=07%2F18%2F2012&enddate=07%2F18%2F2013
>
>

Thu Jul 18, 2013 9:38 am (PDT) . Posted by:

"bablam" bablam

Hi,

I noticed that the Earnings miss/ beat history from earnings.com, fields 1286 onwards upto 1512 in the rchgetelementnumber() function does not work; it returns an error. Has anybody figured out a workaround for that?

Thanks,

Manish

Thu Jul 18, 2013 9:54 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Their site doesn't exist any more.

On Thu, Jul 18, 2013 at 9:38 AM, bablam <mbabla@gmail.com> wrote:

>
> I noticed that the Earnings miss/ beat history from earnings.com, fields
> 1286 onwards upto 1512 in the rchgetelementnumber() function does not
> work; it returns an error. Has anybody figured out a workaround for that?
>

Thu Jul 18, 2013 11:18 am (PDT) . Posted by:

"Manish Babla" bablam

Thanks
On Jul 18, 2013 12:56 PM, "Randy Harmelink" <rharmelink@gmail.com> wrote:

> **
>
>
> Their site doesn't exist any more.
>
> On Thu, Jul 18, 2013 at 9:38 AM, bablam <mbabla@gmail.com> wrote:
>
>>
>> I noticed that the Earnings miss/ beat history from earnings.com, fields
>> 1286 onwards upto 1512 in the rchgetelementnumber() function does not
>> work; it returns an error. Has anybody figured out a workaround for that?
>>
>
>
>

Thu Jul 18, 2013 12:06 pm (PDT) . Posted by:

"ajtalukdar" ajtalukdar

Hello friends,

I have noticed that lately advfn quarterly data is not getting updated on their website. Intiially I thought it was a problem with the add-in, but found that the advfn site itself is where the problem is. For instance, the quarterly data for none of the companies that have declared results this quarter have beenn updated - e.g. Alcoa, Yum Brands, wells fargo etc..

The quarterly reports of some stock from the previous quarter are also pending - e.g. Oracle, Nike, Fedex, etc.

Is anyone else facing this problem?

Thu Jul 18, 2013 1:51 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I just looked at Alcoa -- it is up-to-date. The most recent 10-Q was
released on 4/18 for the quarter ending 3/31.

What are you expecting to see?

On Thu, Jul 18, 2013 at 12:06 PM, ajtalukdar <ajtalukdar@yahoo.com> wrote:

>
> I have noticed that lately advfn quarterly data is not getting updated on
> their website. Intiially I thought it was a problem with the add-in, but
> found that the advfn site itself is where the problem is. For instance, the
> quarterly data for none of the companies that have declared results this
> quarter have beenn updated - e.g. Alcoa, Yum Brands, wells fargo etc..
>
> The quarterly reports of some stock from the previous quarter are also
> pending - e.g. Oracle, Nike, Fedex, etc.
>
> Is anyone else facing this problem?
>

Tidak ada komentar:

Posting Komentar