Messages In This Digest (10 Messages)
- 1a.
- Re: Preventing RCHGetQuote From: John Zman
- 1b.
- Re: Preventing RCHGetQuote From: Randy Harmelink
- 2a.
- Bellway PLC vs. The Berkeley Group PLC From: fhinnenkamp
- 2b.
- Re: Bellway PLC vs. The Berkeley Group PLC From: Randy Harmelink
- 2c.
- Re: Bellway PLC vs. The Berkeley Group PLC From: Frederic Hinnenkamp
- 2d.
- Re: Bellway PLC vs. The Berkeley Group PLC From: Randy Harmelink
- 3a.
- Looking for specific Yahoo Financial Code..... From: cocoaacc
- 3b.
- Re: Looking for specific Yahoo Financial Code..... From: Randy Harmelink
- 4.1.
- New file uploaded to smf_addin From: smf_addin@yahoogroups.com
- 5a.
- Re: Open Order Book Data From: Randy Harmelink
Messages
- 1a.
-
Re: Preventing RCHGetQuote
Posted by: "John Zman" john.zman@yahoo.com john.zman
Mon Nov 14, 2011 2:39 am (PST)
Hi Randy:
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?
John
--- On Sun, 11/13/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: Sunday, November 13, 2011, 5:04 PM
In what context?
The RCHGetYahooQuotes() formula is non-volatile unless you make it volatile.
I use the smfForceRecalculation macro to control when my updates occur.
On Sun, Nov 13, 2011 at 10:01 AM, John Zman <john.zman@yahoo.com > wrote:
I tried to use appllication.enableevents = False to prevent execution, but it doesn't seem to work. Is there a way to control when execution occurs?
- 1b.
-
Re: Preventing RCHGetQuote
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Nov 14, 2011 8:03 am (PST)
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?
>
- 2a.
-
Bellway PLC vs. The Berkeley Group PLC
Posted by: "fhinnenkamp" fhinnenkamp@gmail.com fhinnenkamp
Mon Nov 14, 2011 5:30 am (PST)
To whom it may concern,
I would like to do a comparative analysis of Bellway PLC (Ticker: BWY) and The Berkeley Group PLC (Ticker, BKG). As I own a mac and am using Office 2011 I haven't been able to get the add-in and 'Detailed Financial Statement' workbook to work for me.
I really like consolidation and set up of spreadsheet and would love to have one for each of these companies. Do you have any suggestions as to how I could get this to work on my computer?
Maybe someone could assist me by quickly creating spreadsheets for each and then posting them in a format that will work on my computer, or where they can be viewed online?
I'd really appreciate any help I could get with this.
Sincere Regards,
FHinnenkamp
- 2b.
-
Re: Bellway PLC vs. The Berkeley Group PLC
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Nov 14, 2011 8:05 am (PST)
As the front page of the group notes, the add-in won't work on a Mac. Some
Mac users do use it, but in a Windows emulation mode of some type.
You should use normal EXCEL Web Query processing to bring in your data. Or
cut and paste. It's not as flexible, but should do the trick.
On Mon, Nov 14, 2011 at 5:09 AM, fhinnenkamp <fhinnenkamp@gmail.com > wrote:
> To whom it may concern,
>
> I would like to do a comparative analysis of Bellway PLC (Ticker: BWY) and
> The Berkeley Group PLC (Ticker, BKG). As I own a mac and am using Office
> 2011 I haven't been able to get the add-in and 'Detailed Financial
> Statement' workbook to work for me.
>
> I really like consolidation and set up of spreadsheet and would love to
> have one for each of these companies. Do you have any suggestions as to how
> I could get this to work on my computer?
>
> Maybe someone could assist me by quickly creating spreadsheets for each
> and then posting them in a format that will work on my computer, or where
> they can be viewed online?
>
- 2c.
-
Re: Bellway PLC vs. The Berkeley Group PLC
Posted by: "Frederic Hinnenkamp" fhinnenkamp@gmail.com fhinnenkamp
Mon Nov 14, 2011 9:59 am (PST)
Pardon my ignorance but how do I use a 'normal Excel Web Query'?
Do you believe that if I get it working correctly, I would be able to
import the data for the two companies?
Thank you for the quick response.
On Mon, Nov 14, 2011 at 4:05 PM, Randy Harmelink <rharmelink@gmail.com >wrote:
> **
>
>
> As the front page of the group notes, the add-in won't work on a Mac. Some
> Mac users do use it, but in a Windows emulation mode of some type.
>
> You should use normal EXCEL Web Query processing to bring in your data. Or
> cut and paste. It's not as flexible, but should do the trick.
>
>
> On Mon, Nov 14, 2011 at 5:09 AM, fhinnenkamp <fhinnenkamp@gmail.com >wrote:
>
>> To whom it may concern,
>>
>> I would like to do a comparative analysis of Bellway PLC (Ticker: BWY)
>> and The Berkeley Group PLC (Ticker, BKG). As I own a mac and am using
>> Office 2011 I haven't been able to get the add-in and 'Detailed Financial
>> Statement' workbook to work for me.
>>
>> I really like consolidation and set up of spreadsheet and would love to
>> have one for each of these companies. Do you have any suggestions as to how
>> I could get this to work on my computer?
>>
>> Maybe someone could assist me by quickly creating spreadsheets for each
>> and then posting them in a format that will work on my computer, or where
>> they can be viewed online?
>>
>
>
>
- 2d.
-
Re: Bellway PLC vs. The Berkeley Group PLC
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Nov 14, 2011 10:18 am (PST)
I can only tell you how to do it on a PC, as I have never used a Mac. I
just use the keyboard shortcut alt+d+d+w, enter in the web address, and
tell it which table(s) to import.
http://office.microsoft. com/en-us/ excel-help/ get-and-analyze- data-from- the-web-in- excel-HA00105484 8.aspx
http://www.exceluser.com/explore/ webqueries_ 1.htm
Web Queries were what I used to use before I wrote the add-in. I just
wanted a more exact way to import data, and a more reliable way. But web
queries on the PC have improved a lot since EXCEL 2002.
On Mon, Nov 14, 2011 at 10:59 AM, Frederic Hinnenkamp <fhinnenkamp@gmail.com
> wrote:
>
> Pardon my ignorance but how do I use a 'normal Excel Web Query'?
>
> Do you believe that if I get it working correctly, I would be able to
> import the data for the two companies?
>
- 3a.
-
Looking for specific Yahoo Financial Code.....
Posted by: "cocoaacc" cocoaacc@yahoo.com.hk cocoaacc
Mon Nov 14, 2011 8:10 am (PST)
Dear Randy,
I am using the RCHGetYahooQuotes.html file from your documentation. There have many yahoo codes for financial data.
I am wondering if you have a code for below financial information.
- Qtrly Revenue Growth (yoy)
- Qtrly Earnings Growth (yoy)
These information is located in the below link under income statement.
http://finance.yahoo.com/ q/ks?s=TWIN+ Key+Statistics
Many thanks!
Will
- 3b.
-
Re: Looking for specific Yahoo Financial Code.....
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Nov 14, 2011 8:22 am (PST)
Yahoo doesn't provide that data through its CSV interface, so there are no
Yahoo codes for them.
You'd need to retrieve them on a ticker-by-ticker basis with one of the
other add-in functions. Which can be much slower. For an example, check out
this template in the files area:
SMF-Template-Yahoo-Key- Statistics. xls
On Mon, Nov 14, 2011 at 9:09 AM, cocoaacc <cocoaacc@yahoo.com.hk > wrote:
> Dear Randy,
>
> I am using the RCHGetYahooQuotes.html file from your documentation. There
> have many yahoo codes for financial data.
>
> I am wondering if you have a code for below financial information.
> - Qtrly Revenue Growth (yoy)
> - Qtrly Earnings Growth (yoy)
>
> These information is located in the below link under income statement.
>
> http://finance.yahoo.com/ q/ks?s=TWIN+ Key+Statistics
>
> Many thanks!
>
- 4.1.
-
New file uploaded to smf_addin
Posted by: "smf_addin@yahoogroups.com" smf_addin@yahoogroups.com
Mon Nov 14, 2011 12:52 pm (PST)
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@gmail.com >
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@gmail.com >
- 5a.
-
Re: Open Order Book Data
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Nov 14, 2011 12:53 pm (PST)
I just uploaded a revised version of
RCHGetTableCell-Template- BATS-Real- Time-Quotes. xls...
On Sun, Nov 13, 2011 at 11:11 AM, ronmac17 <ronmac17@yahoo.com > wrote:
> Good article on "Analyzing an Electronic Limit Order Book" using R.
> http://journal.r-project. would like to find a (free) source for Open Order Book Data that I canorg/archive/ 2011-1/RJournal_ 2011-1_Kane~ et~al.pdfI
> retrieve with RCH. Historical data is ok until l can get the code
> functioning properly. I don't think the BATS file still works, have to try
> it tomorrow.
>
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