Jumat, 24 Juni 2011

[smf_addin] Digest Number 1866

Messages In This Digest (19 Messages)

Messages

1a.

GetHTMLTable ?

Posted by: "back" backmehl@yahoo.de   backmehl

Thu Jun 23, 2011 5:37 am (PDT)



Hi Randy,

do you have any idea how can i get the table e.g. under the following link?

http://www.onvista.de/fonds/top-holdings.html?ID_INSTRUMENT=11265226

Thanks a lot & kind regrads

bm :)

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

Re: GetHTMLTable ?

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

Thu Jun 23, 2011 5:58 pm (PDT)



Try:

=RCHGetHTMLTable(URL,"Anteil",-1,"",1)

On Thu, Jun 23, 2011 at 5:37 AM, back <backmehl@yahoo.de> wrote:

>
> do you have any idea how can i get the table e.g. under the following link?
>
> http://www.onvista.de/fonds/top-holdings.html?ID_INSTRUMENT=11265226
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
1c.

Re: GetHTMLTable ?

Posted by: "back" backmehl@yahoo.de   backmehl

Fri Jun 24, 2011 12:55 am (PDT)





--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Try:
>
> =RCHGetHTMLTable(URL,"Anteil",-1,"",1)
>
> On Thu, Jun 23, 2011 at 5:37 AM, back <backmehl@...> wrote:
>
> >
> > do you have any idea how can i get the table e.g. under the following link?
> >
> > http://www.onvista.de/fonds/top-holdings.html?ID_INSTRUMENT=11265226
> >
>

Thank you !!!

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

smfGetOptionQuotes problem

Posted by: "sihlai" sihlai@yahoo.ca   sihlai

Thu Jun 23, 2011 8:47 am (PDT)



I am not sure if it's a problem with the function itself, or Yahoo's site. Some quotes are returned as "N/A", but when I check the site, the quotes are there. It happens to some stocks but not others, and even for a particular stock, it can happen to some expiration dates but not others. Any idea?

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

Re: smfGetOptionQuotes problem

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

Thu Jun 23, 2011 6:10 pm (PDT)



It could be you are extracting data from old web pages:

1. Use the smfForceRecalculation macro (see the "Links" area of the group
for more info) to purge saved web pages and have the add-in collect fresh
copies.

2. Make sure your Internet Options under IE are set to always get new
content when a web page is visited. Otherwise, Microsoft's Internet engine
could be returning cached web pages.

On Thu, Jun 23, 2011 at 8:46 AM, sihlai <sihlai@yahoo.ca> wrote:

> I am not sure if it's a problem with the function itself, or Yahoo's site.
> Some quotes are returned as "N/A", but when I check the site, the quotes are
> there. It happens to some stocks but not others, and even for a particular
> stock, it can happen to some expiration dates but not others. Any idea?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
2c.

Analyst Ratings

Posted by: "Au" uanant@ymail.com   uanant@ymail.com

Thu Jun 23, 2011 6:18 pm (PDT)



Hello Randy,
Can you please tell best place to get analyst ratings?

Regards
Aku

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, June 23, 2011 9:10 PM
Subject: Re: [smf_addin] smfGetOptionQuotes problem

 
It could be you are extracting data from old web pages:

1. Use the smfForceRecalculation macro (see the "Links" area of the group for more info) to purge saved web pages and have the add-in collect fresh copies.

2. Make sure your Internet Options under IE are set to always get new content when a web page is visited. Otherwise, Microsoft's Internet engine could be returning cached web pages.

On Thu, Jun 23, 2011 at 8:46 AM, sihlai <sihlai@yahoo.ca> wrote:

I am not sure if it's a problem with the function itself, or Yahoo's site. Some quotes are returned as "N/A", but when I check the site, the quotes are there. It happens to some stocks but not others, and even for a particular stock, it can happen to some expiration dates but not others. Any idea?
>

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

Re: Analyst Ratings

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

Thu Jun 23, 2011 6:31 pm (PDT)



No idea. Look at the templates and web pages to see which work best for you.
I don't follow them.

On Thu, Jun 23, 2011 at 6:18 PM, Au <uanant@ymail.com> wrote:

> Can you please tell best place to get analyst ratings?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3a.

can you add the now() parameter to the smfGetOptionQuotes

Posted by: "madispa" madispa@gmail.com   madispa

Thu Jun 23, 2011 5:44 pm (PDT)



Can you add the now() parameter to the smfGetOptionQuotes so that f9 forces new data!

Thanks and really appreciate all your hard work!!!!

Paul Madison

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

Re: can you add the now() parameter to the smfGetOptionQuotes

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

Thu Jun 23, 2011 6:06 pm (PDT)



NOW() will not help the smfGetOptionQuotes() functions, since it is grabbing
data from web pages and needs more than just the function to recalculate --
it also needs a new web page. You'll need to use the smfForceRecalculation
macro (see the "Links" area of the group for more info).

On Tue, Jun 21, 2011 at 7:49 PM, madispa <madispa@gmail.com> wrote:

> Can you add the now() parameter to the smfGetOptionQuotes so that f9 forces
> new data!
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4a.

RCHGetYahooQuotes t8 (Target Price) convert to SMF Element

Posted by: "ericcsams" subscription@thesamsfamily.org   ericcsams

Thu Jun 23, 2011 5:44 pm (PDT)



I'm having a problem with RCHGetYahooQuotes. It takes too long to calculate. Is it possible to create an SMF-Element number (RCHGetElementNumber) to grab the target price instead of using RCHGetYahooQuotes?

Any help would be awesome.

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

Re: RCHGetYahooQuotes t8 (Target Price) convert to SMF Element

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

Thu Jun 23, 2011 6:05 pm (PDT)



You'd need to use the RCHGetTableCell() function to get it from their
summary page. However, RCHGetYahooQuotes() should be much faster than either
RCHGetTableCell() or RCHGetElementNumber(), assuming you're using it as
intended by array-entering it and getting all of the data in only one (or a
few) Internet accesses.

On Wed, Jun 22, 2011 at 8:15 AM, ericcsams
<subscription@thesamsfamily.org>wrote:

> I'm having a problem with RCHGetYahooQuotes. It takes too long to
> calculate. Is it possible to create an SMF-Element number
> (RCHGetElementNumber) to grab the target price instead of using
> RCHGetYahooQuotes?
>
> Any help would be awesome.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
5.

Stochastic Software

Posted by: "Frank Hopkins" frank77477@yahoo.com   frank77477

Thu Jun 23, 2011 5:44 pm (PDT)



  Is there a program in Excel that allows one to adjust or slide
  the values of K% and D% to get the best curve fit for a specific stock?
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
6a.

Is there a GetElement Number for Barchart Support & Resistance?

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

Thu Jun 23, 2011 5:45 pm (PDT)



At the bottom of the Barchart.com Opinion web page (Example.... http://www.barchart.com/opinions/stocks/NKE), there are:
Price, Support, Pivot Point, and Resistance levels.

Do GetElement "Numbers" exist for those?

I can't seem to find them in the definitions.xls or .txt files.

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

Re: Is there a GetElement Number for Barchart Support & Resistance?

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

Thu Jun 23, 2011 6:02 pm (PDT)



No elements. Check out this template:

RCHGetTableCell-Template-BarChart-Technical-Signals.xls

On Thu, Jun 23, 2011 at 10:42 AM, sjagers <sjagers@yahoo.com> wrote:

> At the bottom of the Barchart.com Opinion web page (Example....
> http://www.barchart.com/opinions/stocks/NKE), there are:
> Price, Support, Pivot Point, and Resistance levels.
>
> Do GetElement "Numbers" exist for those?
>
> I can't seem to find them in the definitions.xls or .txt files.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
7a.

Re: Do these functions work with options?

Posted by: "ericlaughlincolorado" YahooMessenger@EricLaughlin.com   ericlaughlincolorado

Thu Jun 23, 2011 5:45 pm (PDT)



Hi Randy or anyone, are you aware of any "affordable" source of historical options prices (preferably queryable in excel)?

--- In smf_addin@yahoogroups.com, "Randy Harmelink" <rharmelink@...> wrote:
>
> Yahoo doesn't carry historical data on options. I'm not aware of a
> free source of them either.
>
> On 4/28/08, John French <john_french_profile01@...> wrote:
> > I have been trying with MDY and am not having much luck.
> > RCHGetYahooQuotes pulls back #'s but RCHGetYahooHistory does not.
> > Anyone had any experience with sourcing options historical data?
>

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

Re: Do these functions work with options?

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

Thu Jun 23, 2011 6:00 pm (PDT)



If you find one, let us know...

On Wed, Jun 22, 2011 at 5:00 PM, ericlaughlincolorado <
YahooMessenger@ericlaughlin.com> wrote:

> Hi Randy or anyone, are you aware of any "affordable" source of historical
> options prices (preferably queryable in excel)?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
8a.

Re: Cant get historical revenue for banks

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

Thu Jun 23, 2011 5:45 pm (PDT)



Where can I find historical consistent data of the financials of banks and insurance companies?. I cant use the GetElementNumber function (it doesnt work for banks) so Im trying to use the GetTableCell function getting data from advfn.com, but cant get consistency. For example, I want the data for cash from operations for Dic/2003 of the insurance co AGP, so I use

=RCHGetTableCell("http://www.advfn.com/p.php?pid=financials&btn=start_date&mode=annual_reports&symbol=AGP&start_date=2",1,"net cash from operating activities")

Note that at the end of the URL I have to put the number 2, so the table at the page starts with the financials of 2003/12. But if for example I want the data for Citigroup (C), in order to get the 2003/12 data I have to change the number to 10 at the end of the URL. So I cant use a single formula to get the data of a specific date.

Does anyone knows another page besides ADVFN where I can find historical data (at least 10 years) of banks and insurance companies with a consistent format?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Banks and financial companies have different line items than regular
> companies on their financial statements.
>
> On Sun, Mar 22, 2009 at 5:05 AM, hari aparajith <hariaparajith@...> wrote:
> > RCHGetelementnumber doesnt seem to work for the historical revenue for banks or any financial companies.
> > Anyone knows what the problem is? This should be in their balance sheet and should be a fairly download. It works
> > for any other company.
>

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

Re: Cant get historical revenue for banks

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

Thu Jun 23, 2011 6:01 pm (PDT)



Sorry. Just found out you have a smfGetAdvFNElement function.... Now I just feel dumb.

--- In smf_addin@yahoogroups.com, "steven_rourk" <steven_rourk@...> wrote:
>
> Where can I find historical consistent data of the financials of banks and insurance companies?. I cant use the GetElementNumber function (it doesnt work for banks) so Im trying to use the GetTableCell function getting data from advfn.com, but cant get consistency. For example, I want the data for cash from operations for Dic/2003 of the insurance co AGP, so I use
>
> =RCHGetTableCell("http://www.advfn.com/p.php?pid=financials&btn=start_date&mode=annual_reports&symbol=AGP&start_date=2",1,"net cash from operating activities")
>
> Note that at the end of the URL I have to put the number 2, so the table at the page starts with the financials of 2003/12. But if for example I want the data for Citigroup (C), in order to get the 2003/12 data I have to change the number to 10 at the end of the URL. So I cant use a single formula to get the data of a specific date.
>
> Does anyone knows another page besides ADVFN where I can find historical data (at least 10 years) of banks and insurance companies with a consistent format?
>
>
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > Banks and financial companies have different line items than regular
> > companies on their financial statements.
> >
> > On Sun, Mar 22, 2009 at 5:05 AM, hari aparajith <hariaparajith@> wrote:
> > > RCHGetelementnumber doesnt seem to work for the historical revenue for banks or any financial companies.
> > > Anyone knows what the problem is? This should be in their balance sheet and should be a fairly download. It works
> > > for any other company.
> >
>

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

Re: Retrieving CSV or xls file from http://www.hsi.com.hk/HSI-Net/HS

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

Thu Jun 23, 2011 7:02 pm (PDT)



Just use normal EXCEL processing for a workbook -- see this thread:

http://finance.groups.yahoo.com/group/smf_addin/messages/12755?threaded=1&m=e&var=1&tidx=1

The reason smfGetCSVFile() won't work on the ".csv" file is that the fields
are NOT delimited by commas.

On Thu, Jun 23, 2011 at 2:50 AM, boo1712 <boo1712@yahoo.co.uk> wrote:

>
> Is there any function from smf that can be used to download tables from the
> following urls?
> 1.
> http://www.hsi.com.hk/HSI-Net/static/revamp/contents/en/indexes/report/hsi/HSI_17Jun11.xls
>
> 2.
> http://www.hsi.com.hk/HSI-Net/static/revamp/contents/en/indexes/report/hsi/con_17Jun11.csv
>
> I tried using smfgetcsvfile but cannot display the table properly.
>
> I also tried using
>
> qurl = "
> http://www.hsi.com.hk/HSI-Net/static/revamp/contents/en/indexes/report/hsi/HSI_17Jun11.xls
> "
>
> QueryQuote:
> With ActiveSheet.QueryTables.Add(Connection:="URL;" & qurl,
> Destination:=DataSheet.Range("a1"))
> .BackgroundQuery = True
> .TablesOnlyFromHTML = False
> .Refresh BackgroundQuery:=False
> .SaveData = True
> End With
>
> but also return error.
>
> Please advise.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
Recent Activity
Visit Your Group
Yahoo! News

Odd News

You won't believe

it, but it's true

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Search Ads

Get new customers.

List your web site

in Yahoo! Search.

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

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Diposting oleh EXCEL FEED LEARNING di 03.40

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)