Kamis, 18 Agustus 2011

[smf_addin] Digest Number 1927

Messages In This Digest (17 Messages)

Messages

1a.

Question to smfGetADVFNElement function - Formatting of returned num

Posted by: "zenodk_2" madsdsl@gmail.com   zenodk_2

Wed Aug 17, 2011 8:31 am (PDT)



Hi everyone,

I started using this Excel Add-in just yesterday, so my question might be a bit blond:

My problem concerns the data that i get back from using the smfGetADVFNElement function.

Here is my example:

=smfGetADVFNElement("AAPL";"A";16;">EBITDA<") should return 788,0 but returns 7880 instead.

=smfGetADVFNElement("AAPL";"A";15;">EBITDA<") should return -1048,0 but returns -1,0480 instead.

The problem is obviously something about the formatting used at the webpage. But how to overcome it, so that Excel loads the right numbers?

Thanks in advance,

ZenoDK

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

Re: Question to smfGetADVFNElement function - Formatting of returned

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

Wed Aug 17, 2011 8:46 am (PDT)



The add-in requires the use of U.S. regional settings for numeric
conversions. Check out the "Links" area of the group for several related
items.

On Wed, Aug 17, 2011 at 2:44 AM, zenodk_2 <madsdsl@gmail.com> wrote:

>
> I started using this Excel Add-in just yesterday, so my question might be a
> bit blond:
>
> My problem concerns the data that i get back from using the
> smfGetADVFNElement function.
>
> Here is my example:
>
> =smfGetADVFNElement("AAPL";"A";16;">EBITDA<") should return 788,0 but
> returns 7880 instead.
>
> =smfGetADVFNElement("AAPL";"A";15;">EBITDA<") should return -1048,0 but
> returns -1,0480 instead.
>
> The problem is obviously something about the formatting used at the
> webpage. But how to overcome it, so that Excel loads the right numbers?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
1c.

Re: Question to smfGetADVFNElement function - Formatting of returned

Posted by: "zenodk_2" madsdsl@gmail.com   zenodk_2

Wed Aug 17, 2011 3:10 pm (PDT)



Thanks. I found the solution in the Links section. Just needed to know where to look, I guess.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The add-in requires the use of U.S. regional settings for numeric
> conversions. Check out the "Links" area of the group for several related
> items.
>
> On Wed, Aug 17, 2011 at 2:44 AM, zenodk_2 <madsdsl@...> wrote:
>
> >
> > I started using this Excel Add-in just yesterday, so my question might be a
> > bit blond:
> >
> > My problem concerns the data that i get back from using the
> > smfGetADVFNElement function.
> >
> > Here is my example:
> >
> > =smfGetADVFNElement("AAPL";"A";16;">EBITDA<") should return 788,0 but
> > returns 7880 instead.
> >
> > =smfGetADVFNElement("AAPL";"A";15;">EBITDA<") should return -1048,0 but
> > returns -1,0480 instead.
> >
> > The problem is obviously something about the formatting used at the
> > webpage. But how to overcome it, so that Excel loads the right numbers?
> >
>

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

Re: able to get chart off website using the plugin?

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

Wed Aug 17, 2011 8:45 am (PDT)



Those aren't images. They are shaded HTML tagged areas.

So, yes, you could do it, but you'd need to manually parse and interpret the
HTML tags to recreate the "bar chart" in EXCEL.

On Wed, Aug 17, 2011 at 3:19 AM, Hong Chong NG <nghongchong@hotmail.com>wrote:

>
> how about the small bar chart here?
>
>
> http://investing.businessweek.com/businessweek/research/stocks/financials/ratios.asp?ticker=NTES:US
>
> how can we do it?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3a.

Problems with RCHGetElementNumber()

Posted by: "lancester" martin.vass1@gmail.com   lancester

Wed Aug 17, 2011 9:06 am (PDT)



Hi,

I'm a new user and I like it very much!!

But I have some Problems with the RCHGetElementNumber()- function. A lot of numbers doesn't worked right! What did I wrong? The Ticker symbol is right! The numbers for google doesn't workes and a lot of the others too!! There came the message "Error"!

Please- can you help me!!

Thanks a lot!!

Martin

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

Re: Problems with RCHGetElementNumber()

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

Wed Aug 17, 2011 9:09 am (PDT)



You may just need the updated element definitions from the "Works in
Progress" folder. Best practice:

1. Exit EXCEL
2. Download new file, replacing the old one
3. Restart EXCEL

Otherwise, you'll need to give me examples of tickers and element numbers
that aren't working.

Also, check out the AdvFN note from the "Links" area of the group. You may
need to change a Windows setting to get AdvFN elements.

On Wed, Aug 17, 2011 at 9:01 AM, lancester <martin.vass1@gmail.com> wrote:

>
> But I have some Problems with the RCHGetElementNumber()- function. A lot
> of numbers doesn't worked right! What did I wrong? The Ticker symbol is
> right! The numbers for google doesn't workes and a lot of the others too!!
> There came the message "Error"!
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4a.

Re: Quotes on Stock Options including Greeks

Posted by: "swiftyjpowell" telework@live.com   swiftyjpowell

Wed Aug 17, 2011 10:44 am (PDT)



You're right. OX2 worked for the Put Delta data so now I've got it all set up. I can upload the template... it's a very handy position sizing calculator for stocks and options.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (17)
5a.

Re: Yahoo Quote failures - work-around?

Posted by: "dguillett1" dguillett1@gmail.com   donaldb36

Wed Aug 17, 2011 11:12 am (PDT)



I just got this from Yahoo based on several emails back and forth. I replied asking for the cause. ???
=========
Thank you for your reply.

I see from your inquiry that the CSV download issue happens for any
symbol, intermittently, and the problem data is always a closing price
for August 2nd. Please accept our apologies for the ongoing
difficulties, and frustration, this issue has been causing.

I have looked into this matter, and found that our engineering team
recently identified the cause of this problem, and fixed it. You should
no longer encounter this problem with August 2nd closing price downloads
for symbols on Yahoo! Finance.

Please let us know if the issue persists, or if you have any other
questions or concerns, and we will gladly assist you further.

Thank you for choosing Yahoo! Finance. We appreciate having you as a
customer.

Kind regards,

Quinn

Yahoo! Finance Customer Care
==========
From: Randy Harmelink
Sent: Wednesday, August 10, 2011 5:39 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Yahoo Quote failures - work-around?

I suspect they have one server that hasn't been updated since Aug 2nd, since prices from that date seem to be a consistent symptom among different people having the issue.

It could be you can't mimic the problem manually because that server is only used if most of the other servers are busy -- as it might be if you are updating a large number of RCHGetYahooQuotes() functions at one time. Each request may be rotated to a different server to level out the load. That server might be the one of "last resort" -- or just a random occurrence.

On Wed, Aug 10, 2011 at 3:00 PM, MikeM <mikemcq802@yahoo.com> wrote:

I have also been experiencing Yahoo Quote accuracy problems over the past couple weeks. I have a couple spreadsheets I've used for more than a year which retrieve array-entered quotes. These have worked flawlessly until recently.

I get a quote, it's just not always today's quote. It's not unusual to get one from a week ago - or a week ending quote rather than the current.

Once I realized the quotes weren't random but valid quotes just for the wrong day I now retrieve the date in the quote request to ensure its the day I expect. E.G., today, on Aug 10 it's not unusual to get quotes returned with an Aug 2 date. The quote is right for Aug 2, it's just not supposed to be returned on the 10th.

I use Randy's "refresh" macro and have that as a button in the spreadsheet to speed re-tries. It usually only takes a couple clicks to get all the quotes correct. Annoying but fairly quick.

In one spreadsheet I have 4 separate array-entered quote retrieval blocks. Interestingly, an array of quotes is either all-right or all-wrong. But, it's not unusual to have 1 array of quotes be from a different date than another array of quotes in the same spreadsheet.

I have IE's cache set to "Every time I visit page" per Randy's documentation.

I cannot mimic this failure using IE and downloading CSV quotes. If I could, I'd submit it to Yahoo!

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

Re: Yahoo Quote failures - work-around?

Posted by: "smortonm" smmarder@yahoo.com   smortonm

Wed Aug 17, 2011 4:40 pm (PDT)



YUP! They got it fixed -- goog response on their part. Now how about all
of us sending YAHOO! a request to try to fix the option quote issue.
Sid
--- In smf_addin@yahoogroups.com, "dguillett1" <dguillett1@...> wrote:
>
> I just got this from Yahoo based on several emails back and forth. I
replied asking for the cause. ???
> =========
> Thank you for your reply.
>
> I see from your inquiry that the CSV download issue happens for any
> symbol, intermittently, and the problem data is always a closing price
> for August 2nd. Please accept our apologies for the ongoing
> difficulties, and frustration, this issue has been causing.
>
> I have looked into this matter, and found that our engineering team
> recently identified the cause of this problem, and fixed it. You
should
> no longer encounter this problem with August 2nd closing price
downloads
> for symbols on Yahoo! Finance.
>
> Please let us know if the issue persists, or if you have any other
> questions or concerns, and we will gladly assist you further.
>
> Thank you for choosing Yahoo! Finance. We appreciate having you as a
> customer.
>
> Kind regards,
>
> Quinn
>
> Yahoo! Finance Customer Care
> ==========
> From: Randy Harmelink
> Sent: Wednesday, August 10, 2011 5:39 PM
> To: smf_addin@yahoogroups.com
> Subject: Re: [smf_addin] Yahoo Quote failures - work-around?
>
>
> I suspect they have one server that hasn't been updated since Aug 2nd,
since prices from that date seem to be a consistent symptom among
different people having the issue.
>
> It could be you can't mimic the problem manually because that server
is only used if most of the other servers are busy -- as it might be if
you are updating a large number of RCHGetYahooQuotes() functions at one
time. Each request may be rotated to a different server to level out the
load. That server might be the one of "last resort" -- or just a random
occurrence.
>
>
>
> On Wed, Aug 10, 2011 at 3:00 PM, MikeM mikemcq802@... wrote:
>
> I have also been experiencing Yahoo Quote accuracy problems over the
past couple weeks. I have a couple spreadsheets I've used for more than
a year which retrieve array-entered quotes. These have worked
flawlessly until recently.
>
> I get a quote, it's just not always today's quote. It's not unusual
to get one from a week ago - or a week ending quote rather than the
current.
>
> Once I realized the quotes weren't random but valid quotes just for
the wrong day I now retrieve the date in the quote request to ensure its
the day I expect. E.G., today, on Aug 10 it's not unusual to get quotes
returned with an Aug 2 date. The quote is right for Aug 2, it's just
not supposed to be returned on the 10th.
>
> I use Randy's "refresh" macro and have that as a button in the
spreadsheet to speed re-tries. It usually only takes a couple clicks to
get all the quotes correct. Annoying but fairly quick.
>
> In one spreadsheet I have 4 separate array-entered quote retrieval
blocks. Interestingly, an array of quotes is either all-right or
all-wrong. But, it's not unusual to have 1 array of quotes be from a
different date than another array of quotes in the same spreadsheet.
>
> I have IE's cache set to "Every time I visit page" per Randy's
documentation.
>
> I cannot mimic this failure using IE and downloading CSV quotes. If
I could, I'd submit it to Yahoo!
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (21)
5c.

Re: Yahoo Quote failures - work-around?

Posted by: "Steven Rourk" steven_rourk@hotmail.com   steven_rourk

Wed Aug 17, 2011 5:32 pm (PDT)



These guys at yahoo don't even try to fix their problems.... I reported 6 months ago a problem with incorrect info they are displaying in their industry page and till this date they have not fixed it...The only thing they do is respond "Thank you for reporting this error.... We are currently looking into it...bla,bla, bla"

Mensaje enviado desde mi terminal BlackBerry® de Porta

-----Original Message-----
From: smortonm <smmarder@yahoo.com>
Date: Wed, 17 Aug 2011 23:40:25
To: <smf_addin@yahoogroups.com>
Subject: [smf_addin] Re: Yahoo Quote failures - work-around?

 



YUP! They got it fixed -- goog response on their part. Now how about all
of us sending YAHOO! a request to try to fix the option quote issue.
Sid
--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> , "dguillett1" <dguillett1@...> wrote:
>
> I just got this from Yahoo based on several emails back and forth. I
replied asking for the cause. ???
> =========
> Thank you for your reply.
>
> I see from your inquiry that the CSV download issue happens for any
> symbol, intermittently, and the problem data is always a closing price
> for August 2nd. Please accept our apologies for the ongoing
> difficulties, and frustration, this issue has been causing.
>
> I have looked into this matter, and found that our engineering team
> recently identified the cause of this problem, and fixed it. You
should
> no longer encounter this problem with August 2nd closing price
downloads
> for symbols on Yahoo! Finance.
>
> Please let us know if the issue persists, or if you have any other
> questions or concerns, and we will gladly assist you further.
>
> Thank you for choosing Yahoo! Finance. We appreciate having you as a
> customer.
>
> Kind regards,
>
> Quinn
>
> Yahoo! Finance Customer Care
> ==========
> From: Randy Harmelink
> Sent: Wednesday, August 10, 2011 5:39 PM
> To: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> Subject: Re: [smf_addin] Yahoo Quote failures - work-around?
>
>
> I suspect they have one server that hasn't been updated since Aug 2nd,
since prices from that date seem to be a consistent symptom among
different people having the issue.
>
> It could be you can't mimic the problem manually because that server
is only used if most of the other servers are busy -- as it might be if
you are updating a large number of RCHGetYahooQuotes() functions at one
time. Each request may be rotated to a different server to level out the
load. That server might be the one of "last resort" -- or just a random
occurrence.
>
>
>
> On Wed, Aug 10, 2011 at 3:00 PM, MikeM mikemcq802@... wrote:
>
> I have also been experiencing Yahoo Quote accuracy problems over the
past couple weeks. I have a couple spreadsheets I've used for more than
a year which retrieve array-entered quotes. These have worked
flawlessly until recently.
>
> I get a quote, it's just not always today's quote. It's not unusual
to get one from a week ago - or a week ending quote rather than the
current.
>
> Once I realized the quotes weren't random but valid quotes just for
the wrong day I now retrieve the date in the quote request to ensure its
the day I expect. E.G., today, on Aug 10 it's not unusual to get quotes
returned with an Aug 2 date. The quote is right for Aug 2, it's just
not supposed to be returned on the 10th.
>
> I use Randy's "refresh" macro and have that as a button in the
spreadsheet to speed re-tries. It usually only takes a couple clicks to
get all the quotes correct. Annoying but fairly quick.
>
> In one spreadsheet I have 4 separate array-entered quote retrieval
blocks. Interestingly, an array of quotes is either all-right or
all-wrong. But, it's not unusual to have 1 array of quotes be from a
different date than another array of quotes in the same spreadsheet.
>
> I have IE's cache set to "Every time I visit page" per Randy's
documentation.
>
> I cannot mimic this failure using IE and downloading CSV quotes. If
I could, I'd submit it to Yahoo!
>

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

question....

Posted by: "Mike" mikesadd@hotmail.com   morpheusca8

Wed Aug 17, 2011 1:03 pm (PDT)



Has anyone else noticed that different browers return different info...
eg ie doesnt return 52 high and low for some stocks but fire fox does.
anyone else run in to this....and know ways around it??

Thanks
mike

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

Problem with RCHGetElementNumber()

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

Wed Aug 17, 2011 9:51 pm (PDT)



Hi,

I'm having an issue with the RCHGetElementNumber() command. I'm trying to get YTD data from morningstar and it keeps giving me errors. An example of the command im using is =RCHGetElementNumber(C2,4892) and then im dragging the formula down across all tickers that are listed in the C column. I'm pretty sure I'm using the most up-to-date definitions and add-on. Any ideas on how to fix this?

Thanks

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

Re: Problem with RCHGetElementNumber()

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

Wed Aug 17, 2011 9:56 pm (PDT)



I suspect you're trying to use a stock ticker? The web page that data comes
from is for Mutual Funds. That element works for me when I use ticker symbol
VFINX.

On Wed, Aug 17, 2011 at 9:50 PM, igorkravetsky <igorkravetsky@yahoo.com>wrote:

>
> I'm having an issue with the RCHGetElementNumber() command. I'm trying to
> get YTD data from morningstar and it keeps giving me errors. An example of
> the command im using is =RCHGetElementNumber(C2,4892) and then im dragging
> the formula down across all tickers that are listed in the C column. I'm
> pretty sure I'm using the most up-to-date definitions and add-on. Any ideas
> on how to fix this?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
7c.

Re: Problem with RCHGetElementNumber()

Posted by: "Martin Vass" martin.vass1@gmail.com   lancester

Thu Aug 18, 2011 12:05 am (PDT)



I couldn't find a solution for my problem. I have all updates and it is
installed correctly.

But for the google- numbers it doesn't worked:
=RCHGetElementNumber("ETR:ADS";2897) -only "error"
If I try other ticker symbols like ADS or so(It's Adidas) but it doesn't
work. Can you tell my why??

Thanks a lot!!!
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
7d.

Re: Problem with RCHGetElementNumber()

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

Thu Aug 18, 2011 12:33 am (PDT)



Google doesn't have any Financial Statements data for ETR:ADS...

On Thu, Aug 18, 2011 at 12:05 AM, Martin Vass <martin.vass1@gmail.com>wrote:

>
> I couldn't find a solution for my problem. I have all updates and it is
> installed correctly.
>
> But for the google- numbers it doesn't worked:
> =RCHGetElementNumber("ETR:ADS";2897) -only "error"
> If I try other ticker symbols like ADS or so(It's Adidas) but it doesn't
> work. Can you tell my why??
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
7e.

Re: Problem with RCHGetElementNumber()

Posted by: "Martin Vass" martin.vass1@gmail.com   lancester

Thu Aug 18, 2011 12:39 am (PDT)



Why not? Where can I see if they have such statements? On the webpage I can
find information abut adidas!!

2011/8/18 Randy Harmelink <rharmelink@gmail.com>

> **
>
>
> Google doesn't have any Financial Statements data for ETR:ADS...
>
> On Thu, Aug 18, 2011 at 12:05 AM, Martin Vass <martin.vass1@gmail.com>wrote:
>
>>
>> I couldn't find a solution for my problem. I have all updates and it is
>> installed correctly.
>>
>> But for the google- numbers it doesn't worked:
>> =RCHGetElementNumber("ETR:ADS";2897) -only "error"
>> If I try other ticker symbols like ADS or so(It's Adidas) but it doesn't
>> work. Can you tell my why??
>>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
7f.

Re: Problem with RCHGetElementNumber()

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

Thu Aug 18, 2011 1:00 am (PDT)



Ask Google why, not me. I have no idea. But if you go to their main page:

http://www.google.com/finance?q=ETR:ADS

...you'll see there is no "Financials" link to go to.

On Thu, Aug 18, 2011 at 12:39 AM, Martin Vass <martin.vass1@gmail.com>wrote:

>
> Why not? Where can I see if they have such statements? On the webpage I can
> find information abut adidas!!
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
Recent Activity
Visit Your Group
New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Fashion News

What's the word on

fashion and style?

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
MARKETPLACE
A bad score is 598. A good idea is checking yours, at freecreditscore.com.
Diposting oleh EXCEL FEED LEARNING di 03.58

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)