Messages In This Digest (8 Messages)
- 1a.
- Re: RCHGetyYahooHistory delivers Data without Decimalpoints From: deng3
- 1b.
- Re: RCHGetyYahooHistory delivers Data without Decimalpoints From: deng3
- 2a.
- How to derive realtime google data From: sptrendtrading
- 2b.
- Re: How to derive realtime google data From: Randy Harmelink
- 2c.
- Re: How to derive realtime google data From: sptrendtrading
- 2d.
- Re: How to derive realtime google data From: Randy Harmelink
- 3a.
- WSJ Market Data From: carmine288
- 3b.
- Re: WSJ Market Data From: Randy Harmelink
Messages
- 1a.
-
Re: RCHGetyYahooHistory delivers Data without Decimalpoints
Posted by: "deng3" diengelke@live.com dieterengelke
Mon Aug 15, 2011 5:05 am (PDT)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...>
wrote:
>
> Example please -- what function parameters are you using?
>
> On Sun, Aug 14, 2011 at 5:19 AM, deng3 diengelke@... wrote:
>
> >
> > since a while R.CHGetyYahooHistory delivers Data without
Decimalpoints.
> >
> > e. g. it shows 123456 instead of 1234.56
> >
> > Do you know a way to fix this?
> >
>
Hi Randy,
I am using an array with this formula
"=RCHGetYahooHistory(P8,P9,P10, P11,P12,P13, P14,P15,P16, ,,P19)" Cells P8
Trough P19 are :
=RCHGetYahooHistory("spy",startyear ,startmonth, startday, endyear,endmonth \
,endday,period(D),items" DOHLCVA", ,,resort (2))
Regards
Dieter
- 1b.
-
Re: RCHGetyYahooHistory delivers Data without Decimalpoints
Posted by: "deng3" diengelke@live.com dieterengelke
Mon Aug 15, 2011 5:26 am (PDT)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Example please -- what function parameters are you using?
>
> On Sun, Aug 14, 2011 at 5:19 AM, deng3 <diengelke@...> wrote:
>
> >
> > since a while R.CHGetyYahooHistory delivers Data without Decimalpoints.
> >
> > e. g. it shows 123456 instead of 1234.56
> >
> > Do you know a way to fix this?
> >
>
Hi Randy,
I solved the problem via regional settings in windows 7.
Sorry (I transferred the ss to a new notebook).
Dieter
- 2a.
-
How to derive realtime google data
Posted by: "sptrendtrading" sptrendtrading@yahoo.com sptrendtrading
Mon Aug 15, 2011 10:29 am (PDT)
How to derive google realtime data? The template for google realtime data has invalid url
- 2b.
-
Re: How to derive realtime google data
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Aug 15, 2011 11:03 am (PDT)
I just tried the SMF-Template-Yahoo-Google- Pre-Market- Quotes.xls template
from the "Files" area of the group and it worked fine for me using SPY as a
ticker.
On Mon, Aug 15, 2011 at 10:22 AM, sptrendtrading
<sptrendtrading@yahoo.com >wrote:
> How to derive google realtime data? The template for google realtime data
> has invalid url
>
- 2c.
-
Re: How to derive realtime google data
Posted by: "sptrendtrading" sptrendtrading@yahoo.com sptrendtrading
Mon Aug 15, 2011 11:09 pm (PDT)
The error on opening the template is : the workbook contain one or more
links cannot be updated
Below the error has edit link or continue
Clicking on the edit link give the link to smf add on RCH stock market
functions
The status of the link is : source not found
Rebrowse to the xla file and the status is unknown
Reopen the template did not update the real time data
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...>
wrote:
>
> I just tried the SMF-Template-Yahoo-Google- Pre-Market- Quotes.xls
template
> from the "Files" area of the group and it worked fine for me using SPY
as a
> ticker.
>
> On Mon, Aug 15, 2011 at 10:22 AM, sptrendtrading
> sptrendtrading@...wrote:
>
> > How to derive google realtime data? The template for google realtime
data
> > has invalid url
> >
>
- 2d.
-
Re: How to derive realtime google data
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Aug 15, 2011 11:32 pm (PDT)
Aha. Those are NOT due to an invalid URL.
See item 0.2 in the "Links" area of the group...
On Mon, Aug 15, 2011 at 11:09 PM, sptrendtrading
<sptrendtrading@yahoo.com >wrote:
> The error on opening the template is : the workbook contain one or more
> links cannot be updated
>
> Below the error has edit link or continue
>
> Clicking on the edit link give the link to smf add on RCH stock market
> functions
>
> The status of the link is : source not found
>
> Rebrowse to the xla file and the status is unknown
>
> Reopen the template did not update the real time data
>
>
- 3a.
-
WSJ Market Data
Posted by: "carmine288" carmine.nicoletta@gmail.com carmine288
Mon Aug 15, 2011 9:31 pm (PDT)
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
Thanks
- 3b.
-
Re: WSJ Market Data
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Aug 15, 2011 9:43 pm (PDT)
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@gmail.com >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
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
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