Rabu, 10 Oktober 2012

[smf_addin] Digest Number 2369

15 New Messages

Digest #2369
1a
Dow Index price quote by "ntknow" ntknow
1b
Re: Dow Index price quote by "Randy Harmelink" rharmelink
1c
Re: Dow Index price quote by "ntknow" ntknow
1d
Re: Dow Index price quote by "Randy Harmelink" rharmelink
1e
Re: Dow Index price quote by "Stephan Moebius" spikemgm
1f
Re: Dow Index price quote by "ntknow" ntknow
2a
3b
4a
RCHGetElementNumber for volume data by "bagzigingahouse" bagzigingahouse
4b
Re: RCHGetElementNumber for volume data by "Randy Harmelink" rharmelink
6a
Re: SMF Add In Formula Errors by "Chris Ball" peggysue281
6b
Re: SMF Add In Formula Errors by "Chris Ball" peggysue281
6c
Re: SMF Add In Formula Errors by "Chris Ball" peggysue281

Messages

Tue Oct 9, 2012 4:47 am (PDT) . Posted by:

"ntknow" ntknow

Will someone please tell me the exact rch formula to use to get the quote for the Dow Jones Industrial Average, either in real time or at close? Begin with = :)

Tue Oct 9, 2012 8:03 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Can you just use DIA instead?

On Tue, Oct 9, 2012 at 4:47 AM, ntknow <livinsfun@hotmail.com> wrote:

> Will someone please tell me the exact rch formula to use to get the quote
> for the Dow Jones Industrial Average, either in real time or at close?
> Begin with = :)
>

Tue Oct 9, 2012 2:44 pm (PDT) . Posted by:

"ntknow" ntknow

DIA only gives the DIA price, not that of the Dow Industrial Average itself (yahoo's ^DIA). They are not the same.

-- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Can you just use DIA instead?
>
> On Tue, Oct 9, 2012 at 4:47 AM, ntknow <livinsfun@...> wrote:
>
> > Will someone please tell me the exact rch formula to use to get the quote
> > for the Dow Jones Industrial Average, either in real time or at close?
> > Begin with = :)
> >
>

Tue Oct 9, 2012 3:04 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The problem is that the formulas to extract ^DJI prices change during the
day, and have frequently changed over the last year.

You can try:

=RCHGetTableCell("http://finance.yahoo.com/marketupdate/overview",1,">Dow")
=0+smfGetTagContent("https://www.google.com/finance","span",1,">Dow Jones")

On Tue, Oct 9, 2012 at 2:44 PM, ntknow <livinsfun@hotmail.com> wrote:

> DIA only gives the DIA price, not that of the Dow Industrial Average
> itself (yahoo's ^DIA). They are not the same.
>
> -- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > Can you just use DIA instead?
> >
> > On Tue, Oct 9, 2012 at 4:47 AM, ntknow <livinsfun@...> wrote:
> >
> > > Will someone please tell me the exact rch formula to use to get the
> quote
> > > for the Dow Jones Industrial Average, either in real time or at close?
> > > Begin with = :)
>

Tue Oct 9, 2012 9:12 pm (PDT) . Posted by:

"Stephan Moebius" spikemgm

Dow Jones 13,473.53 -110.12
â–¼0.81%

=rchgettablecell("http://www.barchart.com/stocks/indices.php",2,">$DOWI")

=rchgettablecell("http://www.barchart.com/stocks/indices.php",3,">$DOWI")

=rchgettablecell("http://www.barchart.com/stocks/indices.php",4,">$DOWI")

On Tue, Oct 9, 2012 at 3:04 PM, Randy Harmelink <rharmelink@gmail.com>wrote:

> **
>
>
> The problem is that the formulas to extract ^DJI prices change during the
> day, and have frequently changed over the last year.
>
> You can try:
>
> =RCHGetTableCell("http://finance.yahoo.com/marketupdate/overview
> ",1,">Dow")
> =0+smfGetTagContent("https://www.google.com/finance","span",1,">Dow
> Jones")
>
>
> On Tue, Oct 9, 2012 at 2:44 PM, ntknow <livinsfun@hotmail.com> wrote:
>
>> DIA only gives the DIA price, not that of the Dow Industrial Average
>> itself (yahoo's ^DIA). They are not the same.
>>
>> -- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>> >
>> > Can you just use DIA instead?
>> >
>> > On Tue, Oct 9, 2012 at 4:47 AM, ntknow <livinsfun@...> wrote:
>> >
>> > > Will someone please tell me the exact rch formula to use to get the
>> quote
>> > > for the Dow Jones Industrial Average, either in real time or at close?
>> > > Begin with = :)
>>
>
>
>

Wed Oct 10, 2012 4:20 am (PDT) . Posted by:

"ntknow" ntknow

Your first one worked -- at least today :) Thanks!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The problem is that the formulas to extract ^DJI prices change during the
> day, and have frequently changed over the last year.
>
> You can try:
>
> =RCHGetTableCell("http://finance.yahoo.com/marketupdate/overview",1,">Dow")
> =0+smfGetTagContent("https://www.google.com/finance","span",1,">Dow Jones")
>
> On Tue, Oct 9, 2012 at 2:44 PM, ntknow <livinsfun@...> wrote:
>
> > DIA only gives the DIA price, not that of the Dow Industrial Average
> > itself (yahoo's ^DIA). They are not the same.
> >
> > -- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> > >
> > > Can you just use DIA instead?
> > >
> > > On Tue, Oct 9, 2012 at 4:47 AM, ntknow <livinsfun@> wrote:
> > >
> > > > Will someone please tell me the exact rch formula to use to get the
> > quote
> > > > for the Dow Jones Industrial Average, either in real time or at close?
> > > > Begin with = :)
> >
>

Tue Oct 9, 2012 4:57 am (PDT) . Posted by:

"bushpilote@yahoo.ca" bushpilote


Thank you Randy.
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Because the "1" is a particular parameter. the empty positions are
> place-holders for parameters I'm not using.
>
> [...">Change",1] says to search for ">Change" and then search for 1.
>
> [...">Change",,,,1] says to search for ">Change" and then skip to the next
> table row.
>
> On Mon, Oct 8, 2012 at 6:16 AM, <bushpilote@...> wrote:
>
> >
> > Can you help me understand how you came up with the number of non-blank
> > positions in the formula (ie why [...">Change",1] returns an error and
> > [...">Change",,,,1] gets you the data)?
> >
>

Tue Oct 9, 2012 3:30 pm (PDT) . Posted by:

"Ray Hitt" urracaplace

This is not an issue with the smf_addin. It's an issue with the retrieved data, specifically with adjusted price quotes, quotes that are adjusted to reflect splits and distributions, retrieved from Yahoo! The issue is now serious enough that I feel I must seek an alternative to all Yahoo! data in my spreadsheets.

The issue is that Yahoo! is not currently updating its databases for splits, distributions, etc., for some or all the investments it tracks. The result is incorrect adjusted prices and incorrect values for any parameter derived from them.

For example, Vanguard European Stock Index Adm (VEUSX) distributed $1.34/share on 9/21. Google Finance reported this distribution and shows a YTD return of +14.41% (as of 10/8) for this mutual fund. Yahoo! on the other hand is reporting a YTD return of 11.84% for the same time period. The difference is entirely accounted for by the distribution on 9/21 which Yahoo! has yet to acknowledge. The discrepancies become greater for shorter time periods.

In the past I've notified Yahoo! about this issue and usually they fix the problem in a day or two. Unfortunately, until I notice the issue it doesn't get fixed and does distort my analyses. To be honest, I'm also getting a tired of this reoccurring issue, and I have to wonder, what else is broken that I'm not catching.

As a replacement, Google Finance data looks pretty solid in comparison. Can I use the smf_addin to retrieve historical data, price quotes, splits, and distributions, from Google? Adjusted quotes would be nice as well, but I can calculate that from the other data as long as it's timely. If not, is there another alternative to Yahoo! that will meet my needs?

Tue Oct 9, 2012 9:51 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I've had numerous issues with Google, but mostly on option quotes.

They do have limited historical quotes, but retrieval would not be trivial
for equities where they don't offer a CSV file.

If you really want the cleanest data, you'll probably need to go to one of
the pay services.

On Tue, Oct 9, 2012 at 3:30 PM, Ray Hitt <urracaplace@yahoo.com> wrote:

> As a replacement, Google Finance data looks pretty solid in comparison.
> Can I use the smf_addin to retrieve historical data, price quotes, splits,
> and distributions, from Google? Adjusted quotes would be nice as well, but
> I can calculate that from the other data as long as it's timely. If not, is
> there another alternative to Yahoo! that will meet my needs?
>

Wed Oct 10, 2012 1:26 am (PDT) . Posted by:

"bagzigingahouse" bagzigingahouse

Hello,

i am trying to get volume data to excel by using this function, but i cant seem to get the element code right. Everything i tried resulted in error. Can you suggest how the formula goes for volume, or average volume for past couple days?

Thanks

Wed Oct 10, 2012 1:31 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I would use the RCHGetYahooQuotes() function to get current and average
volume:

=RCHGetYahooQuotes("MMM","va2")

On Wed, Oct 10, 2012 at 1:26 AM, bagzigingahouse
<bagzigingahouse@gmail.com>wrote:

>
> i am trying to get volume data to excel by using this function, but i cant
> seem to get the element code right. Everything i tried resulted in error.
> Can you suggest how the formula goes for volume, or average volume for past
> couple days?
>

Wed Oct 10, 2012 2:41 am (PDT) . Posted by:

"p²n" dlx_0lb

everything works fine after adding QueryTables Connection to the target web page. Thx Randy

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You need to set up the add-in as a reference library in the VBA project in
> order to use its functions...

Wed Oct 10, 2012 7:10 am (PDT) . Posted by:

"Chris Ball" peggysue281

Thanks for the help, that solved the issue.

On Mon, Oct 8, 2012 at 11:35 AM, Randy Harmelink <rharmelink@gmail.com>wrote:

> **
>
>
> See: http://finance.groups.yahoo.com/group/smf_addin/message/19858
>
>
> On Mon, Oct 8, 2012 at 8:54 AM, Chris Ball <crball02@gmail.com> wrote:
>
>>
>> I am trying to use the add in and keep recieving the errors for some
>> formulas, here are a couple of examples:
>>
>> =RCHGetElementNumber(Ticker,25)
>> =RCHGetElementNumber(Ticker,48)
>> =RCHGetElementNumber(Ticker,84)
>> =RCHGetElementNumber(Ticker,AN12)
>>
>> I am using version 2.1.2012.04.07
>>
>> Any help is greatly appreciated.
>>
>
>
>

Wed Oct 10, 2012 7:26 am (PDT) . Posted by:

"Chris Ball" peggysue281

Ok I downloaded the new element definition the Add-In seemed to be running
correctly, but now excel keeps asking me to edit links and the Add-In wont
run. Any ideas?

On Wed, Oct 10, 2012 at 9:10 AM, Chris Ball <crball02@gmail.com> wrote:

> Thanks for the help, that solved the issue.
>
>
> On Mon, Oct 8, 2012 at 11:35 AM, Randy Harmelink <rharmelink@gmail.com>wrote:
>
>> **
>>
>>
>> See: http://finance.groups.yahoo.com/group/smf_addin/message/19858
>>
>>
>> On Mon, Oct 8, 2012 at 8:54 AM, Chris Ball <crball02@gmail.com> wrote:
>>
>>>
>>> I am trying to use the add in and keep recieving the errors for some
>>> formulas, here are a couple of examples:
>>>
>>> =RCHGetElementNumber(Ticker,25)
>>> =RCHGetElementNumber(Ticker,48)
>>> =RCHGetElementNumber(Ticker,84)
>>> =RCHGetElementNumber(Ticker,AN12)
>>>
>>> I am using version 2.1.2012.04.07
>>>
>>> Any help is greatly appreciated.
>>>
>>
>>
>>
>
>

--
Thanks,
Chris Ball

Wed Oct 10, 2012 7:37 am (PDT) . Posted by:

"Chris Ball" peggysue281

And now I am recieving the same formula errors as before.

On Wed, Oct 10, 2012 at 9:26 AM, Chris Ball <crball02@gmail.com> wrote:

> Ok I downloaded the new element definition the Add-In seemed to be running
> correctly, but now excel keeps asking me to edit links and the Add-In wont
> run. Any ideas?
>
>
> On Wed, Oct 10, 2012 at 9:10 AM, Chris Ball <crball02@gmail.com> wrote:
>
>> Thanks for the help, that solved the issue.
>>
>>
>> On Mon, Oct 8, 2012 at 11:35 AM, Randy Harmelink <rharmelink@gmail.com>wrote:
>>
>>> **
>>>
>>>
>>> See: http://finance.groups.yahoo.com/group/smf_addin/message/19858
>>>
>>>
>>> On Mon, Oct 8, 2012 at 8:54 AM, Chris Ball <crball02@gmail.com> wrote:
>>>
>>>>
>>>> I am trying to use the add in and keep recieving the errors for some
>>>> formulas, here are a couple of examples:
>>>>
>>>> =RCHGetElementNumber(Ticker,25)
>>>> =RCHGetElementNumber(Ticker,48)
>>>> =RCHGetElementNumber(Ticker,84)
>>>> =RCHGetElementNumber(Ticker,AN12)
>>>>
>>>> I am using version 2.1.2012.04.07
>>>>
>>>> Any help is greatly appreciated.
>>>>
>>>
>>>
>>>
>>
>>
>
>
> --
> Thanks,
> Chris Ball
>
>

--
Thanks,
Chris Ball

Tidak ada komentar:

Posting Komentar