Rabu, 21 Maret 2012

[smf_addin] Digest Number 2152[1 Attachment]

Messages In This Digest (15 Messages)

Messages

1a.

Re: RCHGetHTMLTable or smfGetTagContent help

Posted by: "digsupply" picsound@gmail.com   digsupply

Tue Mar 20, 2012 7:30 am (PDT)




Thank you very much!!! I feel like a fool, I never thought of searching " Business Summary", which was logical.
MAy I ask you something else? I don't really understand the criteria. Why a "p" in =smfGetTagContent("http://finance.yahoo.com/q/pr?s=A","p",1,">Business Summary"). I tried with "body" "span" "table" "div", never tried with "p". I would like to know in case it happens again.
Thank you for your patience
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> When I search the archives for "Business Summary", the message immediately
> prior to yours in the search has a working solution. See:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/17501
>
> On Mon, Mar 19, 2012 at 9:44 AM, digsupply <picsound@...> wrote:
>
> >
> > Hi Randy. Thank you for your answer, I have already done that. I've spent
> > several hours following the instructions and examples in the messages. I
> > have successfully been able to extract data from other sources,like Stock
> > Scouter rating Summary from MSN,using smfGetTagContent. I will post that
> > file here, in case someone finds it useful. However I haven't been able to
> > use it to extract data from the Yahoo Profile page, that's why I am asking
> > for help.
> >
>

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

Re: RCHGetHTMLTable or smfGetTagContent help

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

Tue Mar 20, 2012 8:58 am (PDT)



Ummm -- because the <p></p> paired tag is what the "Business Summary" was
contained by. You really do need to look at the source code for such things.

On Tue, Mar 20, 2012 at 7:30 AM, digsupply <picsound@gmail.com> wrote:

>
> Thank you very much!!! I feel like a fool, I never thought of searching "
> Business Summary", which was logical.
> MAy I ask you something else? I don't really understand the criteria. Why
> a "p" in =smfGetTagContent("http://finance.yahoo.com/q/pr?s=A","p",1,">Business
> Summary"). I tried with "body" "span" "table" "div", never tried with "p".
> I would like to know in case it happens again.
> Thank you for your patience
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2a.

reuters data

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

Tue Mar 20, 2012 11:02 am (PDT)



how can i receive data from reuters for stock with the symbol as it is at reuters ? lets say a want to make an excel with a formula which gives me price capitallisation pe p/bv ... i currently use the getyahooquotes formula , the reason am asking this is because i cannot find symbol of stock lets saay at the athens stock exchange at yahoo but i can find them at reuters , can anybody help me?

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

Re: reuters data

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

Tue Mar 20, 2012 11:05 am (PDT)



You'd need to create your own extractions, using the other add-in functions
-- RCHGetTableCell(), smfGetTagContent(), etc.

There are several Reuters templates in the files area with examples.

On Tue, Mar 20, 2012 at 10:46 AM, nikosv1972 <nikosv1972@yahoo.com> wrote:

> how can i receive data from reuters for stock with the symbol as it is at
> reuters ? lets say a want to make an excel with a formula which gives me
> price capitallisation pe p/bv ... i currently use the getyahooquotes
> formula , the reason am asking this is because i cannot find symbol of
> stock lets saay at the athens stock exchange at yahoo but i can find them
> at reuters , can anybody help me?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3a.

RCHGetYahooQuotes return Date?

Posted by: "mutantcar" mutant.car@virgin.net   mutantcar

Tue Mar 20, 2012 4:02 pm (PDT)



Hi,

I'm using RCHGetYahooQuotes to get EOD data from Yahoo. I want to automate downloading it daily & import it into SQL server DB.

I have a list of tickers to retrieve (800 or so at the moment, more to add), some of these will have data returned as 'N/A' for whatever reason, or the date will be for a prior day. I'm trying to filter any invalid rows with advanced filter to get a clean list of valid data for importing.

Problem I have is that Date (d1) appears to be returned as text eg. '3/20/2012'. I can filter this using criteria for todays date & <>N/A's for the price fields. It works manually using Advanced filter, but apparently, there's an anomaly using VBA, in that you need to use US format date (I'm in UK) 'MM/dd/yyyy'. This was working until day went beyond '12' I believe, but I now have a problem again & don't seem to be able to get the right date format for my filter to work using VBA.

I've tried using DATEVALUE & TEXT around the RCHGetYahooQuotes formula, but without success.

Is there any way to return a date for d1, instead of text. I think this may help, but not sure?

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

Re: RCHGetYahooQuotes return Date?

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

Tue Mar 20, 2012 4:23 pm (PDT)



Just do a DATE() function, using substrings of the "d1" string. For
example, if the "d1" value is in cell E5, I could use this function to
return a U.S. date:

=DATE(smfWord(E5,3,"/"),smfWord(E5,1,"/"),smfWord(E5,2,"/"))

On Tue, Mar 20, 2012 at 4:02 PM, mutantcar <mutant.car@virgin.net> wrote:

>
> I'm using RCHGetYahooQuotes to get EOD data from Yahoo. I want to automate
> downloading it daily & import it into SQL server DB.
>
> I have a list of tickers to retrieve (800 or so at the moment, more to
> add), some of these will have data returned as 'N/A' for whatever reason,
> or the date will be for a prior day. I'm trying to filter any invalid rows
> with advanced filter to get a clean list of valid data for importing.
>
> Problem I have is that Date (d1) appears to be returned as text eg.
> '3/20/2012'. I can filter this using criteria for todays date & <>N/A's for
> the price fields. It works manually using Advanced filter, but apparently,
> there's an anomaly using VBA, in that you need to use US format date (I'm
> in UK) 'MM/dd/yyyy'. This was working until day went beyond '12' I believe,
> but I now have a problem again & don't seem to be able to get the right
> date format for my filter to work using VBA.
>
> I've tried using DATEVALUE & TEXT around the RCHGetYahooQuotes formula,
> but without success.
>
> Is there any way to return a date for d1, instead of text. I think this
> may help, but not sure?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3c.

Re: RCHGetYahooQuotes return Date?

Posted by: "mutantcar" mutant.car@virgin.net   mutantcar

Tue Mar 20, 2012 4:25 pm (PDT)



Actually, I think I've found a solution, at least for me.

As Randy is generous enough to provide the source, I've added the line "s1=Datevalue(pData)" into smfConvertData function, after the line "If InStr(s1, "/") > 0 Then".

It's working for my particular situation, but I'm not sure it won't adversely affect other uses.

Anyone got a better option?

Regards,

Huw

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

Re: RCHGetYahooQuotes return Date?

Posted by: "mutantcar" mutant.car@virgin.net   mutantcar

Tue Mar 20, 2012 4:27 pm (PDT)



Oh, hi Randy, our posts crossed. I'll try that, better than tampering with your code.

Thanks,

Huw.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Just do a DATE() function, using substrings of the "d1" string. For
> example, if the "d1" value is in cell E5, I could use this function to
> return a U.S. date:
>
> =DATE(smfWord(E5,3,"/"),smfWord(E5,1,"/"),smfWord(E5,2,"/"))
>
> On Tue, Mar 20, 2012 at 4:02 PM, mutantcar <mutant.car@...> wrote:
>
> >
> > I'm using RCHGetYahooQuotes to get EOD data from Yahoo. I want to automate
> > downloading it daily & import it into SQL server DB.
> >
> > I have a list of tickers to retrieve (800 or so at the moment, more to
> > add), some of these will have data returned as 'N/A' for whatever reason,
> > or the date will be for a prior day. I'm trying to filter any invalid rows
> > with advanced filter to get a clean list of valid data for importing.
> >
> > Problem I have is that Date (d1) appears to be returned as text eg.
> > '3/20/2012'. I can filter this using criteria for todays date & <>N/A's for
> > the price fields. It works manually using Advanced filter, but apparently,
> > there's an anomaly using VBA, in that you need to use US format date (I'm
> > in UK) 'MM/dd/yyyy'. This was working until day went beyond '12' I believe,
> > but I now have a problem again & don't seem to be able to get the right
> > date format for my filter to work using VBA.
> >
> > I've tried using DATEVALUE & TEXT around the RCHGetYahooQuotes formula,
> > but without success.
> >
> > Is there any way to return a date for d1, instead of text. I think this
> > may help, but not sure?
> >
>

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

Automatic Refresh of Stock Prices

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

Tue Mar 20, 2012 4:53 pm (PDT)



Have downloaded current stock prices but would now like to have the workbook automatically update the stock prices every 2 minutes throughout the day. Don't want to have to keep hitting ForceRecalc every 2 minutes in order to see how the prices are performing. Is there a VBA routine or some other method that can activate a periodic refresh function for prices?

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

Re: Automatic Refresh of Stock Prices

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

Tue Mar 20, 2012 7:06 pm (PDT)



You would need to write your own VBA routine to do that...

On Tue, Mar 20, 2012 at 4:53 PM, thomas91112 <thomas91112@yahoo.com> wrote:

> Have downloaded current stock prices but would now like to have the
> workbook automatically update the stock prices every 2 minutes throughout
> the day. Don't want to have to keep hitting ForceRecalc every 2 minutes in
> order to see how the prices are performing. Is there a VBA routine or some
> other method that can activate a periodic refresh function for prices?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
4c.

Re: Automatic Refresh of Stock Prices

Posted by: "sudhir agarwal" Agarwal.sudhir@gmail.com   sudhir_agarwal1

Tue Mar 20, 2012 9:11 pm (PDT)

[Attachment(s) from sudhir agarwal included below]

Attached is the doc that you can use. You can set the refresh frequency as
per your wish.
I hope this helps..
SUdhir

On Tue, Mar 20, 2012 at 7:53 PM, thomas91112 <thomas91112@yahoo.com> wrote:

> **
>
>
> Have downloaded current stock prices but would now like to have the
> workbook automatically update the stock prices every 2 minutes throughout
> the day. Don't want to have to keep hitting ForceRecalc every 2 minutes in
> order to see how the prices are performing. Is there a VBA routine or some
> other method that can activate a periodic refresh function for prices?
>
>
>

Attachment(s) from sudhir agarwal

1 of 1 File(s)

STock Quote in Excel .xlsx
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
5a.

Retrieving Yahoo Option Data

Posted by: "Bob Farkaly" rfarkaly@san.rr.com   rfarkaly

Tue Mar 20, 2012 7:05 pm (PDT)



I have developed a little routine that generates/synthesizes option ticker
symbols based on criteria I set. For example, AGQ120421C00054000 is the
generated ticker symbol for the AGQ Apr 2012 54.000 Call option. What I'd
like to do, but can't figure out how to, is automate the retrieval of the
"Bid: $xxx" field from that Yahoo Finance option page. I've done a lot of
trial and error (all error, so far). ;-)

Can someone lend me a hand?

Thanks,

Bob

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

Re: Retrieving Yahoo Option Data

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

Tue Mar 20, 2012 7:09 pm (PDT)



Why not just use the smfGetOptionQuotes() function?

In any case, this would get your desired bid price:

=RCHGetTableCell("http://finance.yahoo.com/q?s=AGQ120421C00054000",1,">Bid")

This would retrieve the same price:

=smfGetOptionQuotes("AGQ Apr 2012 54.000 Call","b")

On Tue, Mar 20, 2012 at 4:50 PM, Bob Farkaly <rfarkaly@san.rr.com> wrote:

> I have developed a little routine that generates/synthesizes option ticker
> symbols based on criteria I set. For example, AGQ120421C00054000 is the
> generated ticker symbol for the AGQ Apr 2012 54.000 Call option. What I'd
> like to do, but can't figure out how to, is automate the retrieval of the
> "Bid: $xxx" field from that Yahoo Finance option page. I've done a lot of
> trial and error (all error, so far). ;-)
>
> Can someone lend me a hand?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
6a.

Re: getting data from IBD stock checkup page

Posted by: "Larry" lulsh@sbcglobal.net   lulsh@sbcglobal.net

Tue Mar 20, 2012 9:31 pm (PDT)



='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfStrExtr('C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!RCHGetWebData("http://www.investors.com/search/searchresults.aspx?Ntt="&B2,"/quotes/"),"/quotes/","'")

having trouble cleaning up this string so that it works....Help! :)

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I threw together a template, because I had an idea of how I might be able
> to drive data retrieval using just the ticker symbol, creating the
> necessary URL with exchange and company name:
>
> RCHGetTableCell-Template-IBD-Stock-Checkup.xls
>
> On Fri, Mar 9, 2012 at 3:27 AM, mff2805 <mff3429@...> wrote:
>
> >
> > got a sample spreadsheet for ibd data?
> >
>

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

Re: getting data from IBD stock checkup page

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

Tue Mar 20, 2012 10:16 pm (PDT)



Check out the location errors item from the "Links" area of the group...

Basically, you need to do a "Find and Replace All" to remove the path
prefixes from all the functions.

On Tue, Mar 20, 2012 at 9:31 PM, Larry <lulsh@sbcglobal.net> wrote:

> ='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfStrExtr('C:\SMF
> Add-in\RCH_Stock_Market_Functions.xla'!RCHGetWebData("
> http://www.investors.com/search/searchresults.aspx?Ntt=
> "&B2,"/quotes/"),"/quotes/","'")
>
> having trouble cleaning up this string so that it works....Help! :)
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Ads on Yahoo!

Learn more now.

Reach customers

searching for you.

Yahoo! News

Get it all here

Breaking news to

entertainment news

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.54

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)