Sabtu, 16 Juni 2012

[smf_addin] Digest Number 2248

Messages In This Digest (7 Messages)

Messages

1a.

RCHGetElemnentNumber Problems

Posted by: "tomasi1957" tomasi1957@yahoo.com   tomasi1957

Fri Jun 15, 2012 6:22 am (PDT)



Good Morning Randy:
I have been having problems with my spreadsheet I made to help me track furture dividend payouts from my portfolio. I rely on only two element numbers. One which bring in dividend pay date is working fine. It is 991. But element number 46 for dividend rate returns a "#VALUE!".

I have read some messages from this site that tells me there has been some change with the MSN info. I have downloaded from the works in progress folder the new Zip File 2.1 2012.04.07. but it still will not work for element number 46. Can you guide me through this please?

Thank you

Tom Irwin

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
1b.

Re: RCHGetElemnentNumber Problems

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Jun 15, 2012 6:31 am (PDT)



If you get #VALUE! returned from an RCHGetElementNumber() function, it
typically means your parameters are of the wrong type. I suspect #VALUE! is
actually the result of a calculation with what the function is returning.
For example, dividing by 100.

In any case, you probably just need:

http://finance.groups.yahoo.com/group/smf_addin/message/18529

On Fri, Jun 15, 2012 at 5:44 AM, tomasi1957 <tomasi1957@yahoo.com> wrote:

>
> I have been having problems with my spreadsheet I made to help me track
> furture dividend payouts from my portfolio. I rely on only two element
> numbers. One which bring in dividend pay date is working fine. It is 991.
> But element number 46 for dividend rate returns a "#VALUE!".
>
> I have read some messages from this site that tells me there has been some
> change with the MSN info. I have downloaded from the works in progress
> folder the new Zip File 2.1 2012.04.07. but it still will not work for
> element number 46. Can you guide me through this please?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2a.

Same RCHGetTableCell formula works in one Excel instance but not ano

Posted by: "dwstelsel" dwstelsel@yahoo.com   dwstelsel

Fri Jun 15, 2012 11:51 am (PDT)



I am using RCHGetTableCell to extract the Maturity Date: from bonds on the FINRA website

Example

=RCHGetTableCell("http://cxa.marketwatch.com/finra/BondCenter/BondDetail.aspx?ID=Njc3NTZCUks4",1,"Maturity Date:")

I get "Error" for this bond in the workbook in which I have 20 bonds I am looking up. It works for the 19 others.

I opened a second instance of Excel (while the other instance is still open) and pasted this formula in a new workbook and it returns the correct Maturity Date: of 04/01/2014

Why would the exact same formula work in one Excel book and not another separate instance of Excel?

I added smForceRecalculation in the VBA for the tab but it did not help(if that matters at all)

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2b.

Re: Same RCHGetTableCell formula works in one Excel instance but not

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Jun 15, 2012 12:12 pm (PDT)



Do you know if the FINRA website has any kind of mechanism to limit access?
I had one person get errors from The Motley Fool after 13 or so accesses.
When I tried it, it was because they started returning a web page that said
"You appear to be an automated process instead of a person." instead of
returning the normal data.

I found that by visiting the URL of one of the errored out pages using the
EXCEL Web Query dialog.

The second instance could somehow look like a different person, so it
returned the data?

Otherwise, I would have suggested maybe you just got a bad web page, or
timed out. That could be fixed with the smfForceRecalculation, but since
you already did that...

On Fri, Jun 15, 2012 at 11:05 AM, dwstelsel <dwstelsel@yahoo.com> wrote:

> I am using RCHGetTableCell to extract the Maturity Date: from bonds on the
> FINRA website
>
> Example
>
> =RCHGetTableCell("
> http://cxa.marketwatch.com/finra/BondCenter/BondDetail.aspx?ID=Njc3NTZCUks4",1,"Maturity
> Date:")
>
> I get "Error" for this bond in the workbook in which I have 20 bonds I am
> looking up. It works for the 19 others.
>
> I opened a second instance of Excel (while the other instance is still
> open) and pasted this formula in a new workbook and it returns the correct
> Maturity Date: of 04/01/2014
>
> Why would the exact same formula work in one Excel book and not another
> separate instance of Excel?
>
> I added smForceRecalculation in the VBA for the tab but it did not help(if
> that matters at all)
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3a.

Bloomberg stock last trade price

Posted by: "Kevin Miole" kevinleijh@yahoo.com   kevinleijh

Sat Jun 16, 2012 12:57 am (PDT)



hi I'm new here can you help me get bloomberg stock qoutes for a company for example BPI:PM I can't figure out how to get the price thank you

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3b.

Re: Bloomberg stock last trade price

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat Jun 16, 2012 1:01 am (PDT)



Not a simple extraction:

=smfConvertData(smfStrExtr("|"&smfGetTagContent("
http://www.bloomberg.com/quote/BPI:PM","span",-1,"class="" price"""),"|","
"))

That works now, but I don't know if their web page format will be
consistent.

On Sat, Jun 16, 2012 at 12:14 AM, Kevin Miole <kevinleijh@yahoo.com> wrote:

> hi I'm new here can you help me get bloomberg stock qoutes for a company
> for example BPI:PM I can't figure out how to get the price thank you
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3c.

Re: Bloomberg stock last trade price

Posted by: "Kevin Miole" kevinleijh@yahoo.com   kevinleijh

Sat Jun 16, 2012 1:05 am (PDT)



Thank you very much

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Not a simple extraction:
>
> =smfConvertData(smfStrExtr("|"&smfGetTagContent("
> http://www.bloomberg.com/quote/BPI:PM","span",-1,"class="" price"""),"|","
> "))
>
> That works now, but I don't know if their web page format will be
> consistent.
>
> On Sat, Jun 16, 2012 at 12:14 AM, Kevin Miole <kevinleijh@...> wrote:
>
> > hi I'm new here can you help me get bloomberg stock qoutes for a company
> > for example BPI:PM I can't figure out how to get the price thank you
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
Recent Activity
Visit Your Group
Need traffic?

Drive customers

With search ads

on Yahoo!

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Odd News

You won't believe

it, but it's true

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
Diposting oleh EXCEL FEED LEARNING di 01.13

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)