Messages In This Digest (10 Messages)
- 1.1.
- Re: New file uploaded to smf_addin From: ronmac17
- 2a.
- Re: Preventing RCHGetQuote From: John Zman
- 3a.
- New user question... From: denap
- 3b.
- Re: New user question... From: Randy Harmelink
- 4a.
- Stale Dates from Yahoo From: joe_mo37
- 4b.
- Re: Stale Dates from Yahoo From: Randy Harmelink
- 5a.
- How to get Income Statement from yahoo into exel From: sondaica
- 5b.
- Re: How to get Income Statement from yahoo into exel From: Randy Harmelink
- 6a.
- Need Help with RCHCreateCOmment From: GaryFera
- 6b.
- Re: Need Help with RCHCreateCOmment From: Randy Harmelink
Messages
- 1.1.
-
Re: New file uploaded to smf_addin
Posted by: "ronmac17" ronmac17@yahoo.com ronmac17
Tue Nov 15, 2011 6:43 am (PST)
Looks good Randy, thanks
--- In smf_addin@yahoogroups.com , smf_addin@yahoogroups.com wrote:
>
>
> Hello,
>
> This email message is a notification to let you know that
> a file has been uploaded to the Files area of the smf_addin
> group.
>
> File : /Templates and Examples/RCHGetTableCell/RCHGetTabl eCell-Template- BATS-Real- Time-Quotes. xls
> Uploaded by : rharmelink <rharmelink@...>
> Description : An example of capturing the real time quotes from the Yahoo "Order Book" (i.e. BATS) web page. It uses the NOW() function to generate the URL so that a recalculation (i.e. F9 key) will update the quotes display.
>
> You can access this file at the URL:
> http://groups.yahoo.com/ group/smf_ addin/files/ Templates% 20and%20Examples /RCHGetTableCell /RCHGetTableCell -Template- BATS-Real- Time-Quotes. xls
>
> To learn more about file sharing for your group, please visit:
> http://help.yahoo.com/ l/us/yahoo/ groups/original/ members/web/ index.html
> Regards,
>
> rharmelink <rharmelink@...>
>
- 2a.
-
Re: Preventing RCHGetQuote
Posted by: "John Zman" john.zman@yahoo.com john.zman
Tue Nov 15, 2011 7:19 am (PST)
Well my bad here, I didn't know there was a "refresh parameter" in the add-in. OTH, I do have a "Refresh" range, which, when it changes to "Y" updates, ala:=IF(Refresh="Y",RCHGetQuote( cellref,type) ,0). I can disable that and see what happens.
John
--- On Mon, 11/14/11, Randy Harmelink <rharmelink@gmail.com > wrote:
From: Randy Harmelink <rharmelink@gmail.com >
Subject: Re: [smf_addin] Preventing RCHGetQuote
To: smf_addin@yahoogroups.com
Date: Monday, November 14, 2011, 4:03 PM
In general, I wouldn't think it would do that unless you've made the function volatile with the refresh parameter.
I don't think enableevents would have any affect on that. I'm not sure recalculation is considered an "event" in EXCEL. Not sure though...
On Mon, Nov 14, 2011 at 3:39 AM, John Zman <john.zman@yahoo.com > wrote:
Thanks for the reply. It seems to me, that while in the debugger, and after completion of filling an array, then assigning the array to a range, I find the debugger taking me to the addin module code. So I assumed this was because the range with the symbols changed. Or would it be due to something else?
- 3a.
-
New user question...
Posted by: "denap" denap@yahoo.com denap
Tue Nov 15, 2011 8:51 am (PST)
I'm looking for the top % holders of a particular stock, similar to the Bloomberg HDS function. Is there such an element(s)?
thanks
- 3b.
-
Re: New user question...
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Nov 15, 2011 9:01 am (PST)
No elements, but take a look at these templates:
RCHGetTableCell-Template- Morningstar- Top-20-Stock- Holders.xls
RCHGetTableCell-Template- Morningstar- Top-Stock- Holders.xls
On Tue, Nov 15, 2011 at 9:45 AM, denap <denap@yahoo.com > wrote:
> I'm looking for the top % holders of a particular stock, similar to the
> Bloomberg HDS function. Is there such an element(s)?
>
- 4a.
-
Stale Dates from Yahoo
Posted by: "joe_mo37" joe_mo37@yahoo.com joe_mo37
Tue Nov 15, 2011 10:31 am (PST)
I'm using RCHGetYahooQuotes to update a sheet with 19 ticker symbols on it - all for mutual funds. 17 of the funds return their NAVs for 11/14/2011 while 2 of them (VIMAX and VTIAX) have the NAVs for 11/11/2011. When I go directly to Yahoo! Finance both of these funds have NAVs for 11/14/2011 listed. Why am I getting stale dates and NAVs for these two funds via RCHGetYahooQuotes?
- 4b.
-
Re: Stale Dates from Yahoo
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Nov 15, 2011 10:36 am (PST)
Because that is what Yahoo is returning via their CSV interface. You can
confirm this yourself by clicking on the "Download Data" link on the web
page. You should let Yahoo know. A week or so ago, others mentioned similar
issues with a number of the indexes.
On Tue, Nov 15, 2011 at 11:31 AM, joe_mo37 <joe_mo37@yahoo.com > wrote:
> I'm using RCHGetYahooQuotes to update a sheet with 19 ticker symbols on it
> - all for mutual funds. 17 of the funds return their NAVs for 11/14/2011
> while 2 of them (VIMAX and VTIAX) have the NAVs for 11/11/2011. When I go
> directly to Yahoo! Finance both of these funds have NAVs for 11/14/2011
> listed. Why am I getting stale dates and NAVs for these two funds via
> RCHGetYahooQuotes?
>
- 5a.
-
How to get Income Statement from yahoo into exel
Posted by: "sondaica" ih3m_u@yahoo.com ih3m_u
Tue Nov 15, 2011 12:41 pm (PST)
Help please
How to get Income Statement from yahoo into exel
- 5b.
-
Re: How to get Income Statement from yahoo into exel
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Nov 15, 2011 12:43 pm (PST)
Check out this template from the files area:
RCHGetTableCell-Template- Yahoo-Financial- Statements. xls
On Tue, Nov 15, 2011 at 1:08 PM, sondaica <ih3m_u@yahoo.com > wrote:
> Help please
> How to get Income Statement from yahoo into exel
>
- 6a.
-
Need Help with RCHCreateCOmment
Posted by: "GaryFera" gfera@shaw.ca GaryFera
Tue Nov 15, 2011 1:58 pm (PST)
Randy, I use the RCHCreateComment command to bring in stock charts from My.Yahoo.com and it works. I am trying to duplicate the chart extraction approach with the MarketWatch web site because they have charts on options which seem to almost impossible to find. But I am unable to get the command (shown below) to work. I have signed up to the MarketWatch web site and am properly logged in as far as I can tell.
Any guidance would be appreciated.
Gary
=RCHCreateComment("http://www.marketwa tch.com/investin ",99)g/stock/IBM/ option/IBMA21123 200000
- 6b.
-
Re: Need Help with RCHCreateCOmment
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Nov 15, 2011 2:18 pm (PST)
You need the URL of the image itself, not the web page the image is on. The
chart image is dynamically created via a script, so there is no URL for the
image. I don't see any way for the add-in to copy the image into EXCEL.
On Tue, Nov 15, 2011 at 2:58 PM, GaryFera <gfera@shaw.ca> wrote:
> Randy, I use the RCHCreateComment command to bring in stock charts from
> My.Yahoo.com and it works. I am trying to duplicate the chart extraction
> approach with the MarketWatch web site because they have charts on options
> which seem to almost impossible to find. But I am unable to get the command
> (shown below) to work. I have signed up to the MarketWatch web site and am
> properly logged in as far as I can tell.
>
> Any guidance would be appreciated.
>
> Gary
>
> =RCHCreateComment("
> http://www.marketwatch.com/investin ",99)g/stock/IBM/ option/IBMA21123 200000
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar