Messages In This Digest (10 Messages)
- 1a.
- Re: WSJ Market Data From: bushpilote@yahoo.ca
- 1b.
- Re: WSJ Market Data From: Randy Harmelink
- 2a.
- Re: Problem with RCHGetYahooHistory From: romainrouphael
- 2b.
- Re: Problem with RCHGetYahooHistory From: Randy Harmelink
- 2c.
- Re: Problem with RCHGetYahooHistory From: romainrouphael
- 2d.
- Re: Problem with RCHGetYahooHistory From: Randy Harmelink
- 2e.
- Re: Problem with RCHGetYahooHistory From: romainrouphael
- 3a.
- Re: Recording each and every price stamp in a new row from a stream From: paul messerschmidt
- 4a.
- problems extracting data from google finance From: Lawrence
- 4b.
- Re: problems extracting data from google finance From: Randy Harmelink
Messages
- 1a.
-
Re: WSJ Market Data
Posted by: "bushpilote@yahoo.ca" bushpilote@yahoo.ca bushpilote
Wed Oct 5, 2011 4:59 am (PDT)
Hi Randy,
I have been unable to pull P/E ratios from ""http://online.wsj.com/mdc/ "public/page/ 2_3021-peyield. html?mod= mdc_h_usshl
with the function recommended below.
Any suggestion on getting this to work would be appreciated.
Thanks.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> About as straightforward as it gets:
>
> =RCHGetHTMLTable("
> http://online.wsj.com/mdc/ public/page/ 2_3023-keyrates- 20090309. html?mod= mdc_pastcalendar
> ",
> ">CdnDlr",-1,"",1)
>
> On Mon, Aug 15, 2011 at 9:31 PM, carmine288 <carmine.nicoletta@...>wrote:
>
> > Randy, any suggestions on how go grab the table contents from:
> > http://online.wsj.com/mdc/ public/page/ 2_3023-keyrates- 20090309. html?mod= mdc_pastcalendar
> >
>
- 1b.
-
Re: WSJ Market Data
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Oct 5, 2011 8:13 am (PDT)
Simple as pie:
=RCHGetHTMLTable("http://online. wsj.com/mdc/ ",">Dowpublic/page/ 2_3021-peyield. html
Industrial",-1,"",1)
On Wed, Oct 5, 2011 at 4:59 AM, <bushpilote@yahoo.ca > wrote:
>
> I have been unable to pull P/E ratios from ""
> http://online.wsj.com/mdc/ "public/page/ 2_3021-peyield. html?mod= mdc_h_usshl
> with the function recommended below.
>
> Any suggestion on getting this to work would be appreciated.
>
- 2a.
-
Re: Problem with RCHGetYahooHistory
Posted by: "romainrouphael" romainrouphael@yahoo.fr romainrouphael
Wed Oct 5, 2011 8:07 am (PDT)
Hi,
I have exactly the same issue.
Do you know why?
Best Regards,
Romain
--- In smf_addin@yahoogroups.com , "dolgachev_dv" <dolgachev_dv@...> wrote:
>
> Hi !! I use winows XP, Office 2003. Than i am trying to get historical
> quotes from Yahoo using RCHGetYahooHistory and doing as instructed in
> Documentation i ve got something like this:
> Date Open High Low Close Volume Adj Close
> 39745
> what could be the problem?
>
- 2b.
-
Re: Problem with RCHGetYahooHistory
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Oct 5, 2011 8:14 am (PDT)
Exact parameters, please.
On Wed, Oct 5, 2011 at 8:03 AM, romainrouphael <romainrouphael@yahoo.fr >wrote:
>
> I have exactly the same issue.
>
> Do you know why?
>
> --- In smf_addin@yahoogroups.com , "dolgachev_dv" <dolgachev_dv@...> wrote:
> >
> > Hi !! I use winows XP, Office 2003. Than i am trying to get historical
> > quotes from Yahoo using RCHGetYahooHistory and doing as instructed in
> > Documentation i ve got something like this:
> > Date Open High Low Close Volume Adj Close
> > 39745
> > what could be the problem?
>
- 2c.
-
Re: Problem with RCHGetYahooHistory
Posted by: "romainrouphael" romainrouphael@yahoo.fr romainrouphael
Wed Oct 5, 2011 8:37 am (PDT)
Yeah, sorry, i'm new on the forum.
I use Windows XP, French version of Excel 2007,
The other functions work properly but when i open files with examples of RCHGetYahooHistory or try it on my sheet, the same thing happens:
Date Open High Low Close Volume Adj Close on fist line and then only the last date.
Thanks for your support
(it's a great add-in)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Exact parameters, please.
>
> On Wed, Oct 5, 2011 at 8:03 AM, romainrouphael <romainrouphael@...>wrote:
>
> >
> > I have exactly the same issue.
> >
> > Do you know why?
> >
> > --- In smf_addin@yahoogroups.com , "dolgachev_dv" <dolgachev_dv@> wrote:
> > >
> > > Hi !! I use winows XP, Office 2003. Than i am trying to get historical
> > > quotes from Yahoo using RCHGetYahooHistory and doing as instructed in
> > > Documentation i ve got something like this:
> > > Date Open High Low Close Volume Adj Close
> > > 39745
> > > what could be the problem?
> >
>
- 2d.
-
Re: Problem with RCHGetYahooHistory
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Oct 5, 2011 8:49 am (PDT)
French could be an issue. VBA functions don't translate properly unless
regional settings are U.S. It's probably erroring out on the first
conversion of string to number for a U.S. dollar amount.
On Wed, Oct 5, 2011 at 8:37 AM, romainrouphael <romainrouphael@yahoo.fr >wrote:
> Yeah, sorry, i'm new on the forum.
> I use Windows XP, French version of Excel 2007,
> The other functions work properly but when i open files with examples of
> RCHGetYahooHistory or try it on my sheet, the same thing happens:
>
> Date Open High Low Close Volume Adj Close on fist line and
> then only the last date.
>
- 2e.
-
Re: Problem with RCHGetYahooHistory
Posted by: "romainrouphael" romainrouphael@yahoo.fr romainrouphael
Wed Oct 5, 2011 11:03 am (PDT)
Thanks for your help !
Indeed i had to change my local and language settings from France to US and it works!
Best regards,
Romain
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> French could be an issue. VBA functions don't translate properly unless
> regional settings are U.S. It's probably erroring out on the first
> conversion of string to number for a U.S. dollar amount.
>
> On Wed, Oct 5, 2011 at 8:37 AM, romainrouphael <romainrouphael@...>wrote:
>
> > Yeah, sorry, i'm new on the forum.
> > I use Windows XP, French version of Excel 2007,
> > The other functions work properly but when i open files with examples of
> > RCHGetYahooHistory or try it on my sheet, the same thing happens:
> >
> > Date Open High Low Close Volume Adj Close on fist line and
> > then only the last date.
> >
>
- 3a.
-
Re: Recording each and every price stamp in a new row from a stream
Posted by: "paul messerschmidt" financepaul@gmail.com fuelspotpaul
Wed Oct 5, 2011 2:48 pm (PDT)
now if you had a fidelity account, using their active trader pro platform,
you could download all the time/sale data directly into excel
it's very easy one-click functionality and you can select any window of time
-- and even sort by trade size, price, etc.
good trading...
On Tue, Oct 4, 2011 at 11:26 AM, Farhan Ansari <farhan86a@gmail.com > wrote:
> **
>
>
> Thanks Randy, so yes I am having the data service provider but the problem
> is that I am only able to get the real-time data updated in a particular
> cell. However, a silver lining for me "VBA timing routine" I will google
> that out.
>
> Thanks again!
>
>
> On Tue, Oct 4, 2011 at 8:40 PM, Randy Harmelink <rharmelink@gmail.com >wrote:
>
>> **
>>
>>
>> You'd need to write your own VBA timing routine to do the process.
>>
>> But, seriously, if you need that kind of data, get a proper data service
>> provider.
>>
>>
>> On Tue, Oct 4, 2011 at 3:01 AM, Farhan Ansari <farhan86a@gmail.com >wrote:
>>
>>>
>>> I had a query not related to the SMF Add-in (all praise to Randy and I
>>> apologize to the group to ask an off topic question). But does any body know
>>> how to record the data from a real-time steam. For e.g. the Google real-time
>>> display of a stock price can be imported to Excel and with the auto-refresh
>>> code the price can be made to appear updating on a real-time basis. However,
>>> can there be any code in excel to auto record each and every price stamp in
>>> a new row out of that stream?
>>>
>>>
>>
>
>
--
--------------------- --------- --------- --
Paul Messerschmidt
paul.messerschmidt (skype)
+1-813-334-8682 (mobile)
- 4a.
-
problems extracting data from google finance
Posted by: "Lawrence" lawrence.leesh@gmail.com lawleesh
Thu Oct 6, 2011 12:42 am (PDT)
Hi, I managed to extract data from yahoo finance but cells for google finance shows Error.
=RCHGetElementNumber("SIN:C6L" ,2742)
Can someone help?
thanks
LL
- 4b.
-
Re: problems extracting data from google finance
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Oct 6, 2011 12:44 am (PDT)
You're getting an error because Google doesn't have financial statements
data for SIN:C6L.
On Wed, Oct 5, 2011 at 11:51 PM, Lawrence <lawrence.leesh@gmail.com > wrote:
> Hi, I managed to extract data from yahoo finance but cells for google
> finance shows Error.
>
> =RCHGetElementNumber("SIN:C6L" ,2742)
>
> Can someone help?
>
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