Selasa, 01 April 2014

[smf_addin] Digest Number 3028

14 Messages

Digest #3028
3b
Re: rchcreatecomment chart question by "Randy Harmelink" rharmelink
4b
5a

Messages

Mon Mar 31, 2014 8:07 am (PDT) . Posted by:

leobueno

I am new to the SMF Add-in, so please excuse my sounding dumb.
I looked through the documentation and templates for the elements of market indices, but did not find them.
Will appreciate your pointing me in the right direction.
Thanks.
Leo

Mon Mar 31, 2014 8:10 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Current quotes should be retrieved using RCHGetYahooQuotes(). Although
Yahoo can no longer provide data on Dow Jones indices in their CSV files,
because Dow Jones tightened up on their licensing of quotes.

On Mon, Mar 31, 2014 at 8:03 AM, <Leo@buenolaw.com> wrote:

> I am new to the SMF Add-in, so please excuse my sounding dumb.
>
> I looked through the documentation and templates for the elements of
> market indices, but did not find them.
>
> Will appreciate your pointing me in the right direction.
>

Mon Mar 31, 2014 9:25 am (PDT) . Posted by:

northern1012001

I manually checked a number of the securities that I download from Yahoo and there seems to be chunks of data missing for certain securities and in some cases the numbers don't seem to line up with other data sources for a given date. Will work on the assumption that it is a Yahoo Finance data glitch and hopefully they resolve it soon. Thanks for your help.

Mon Mar 31, 2014 9:56 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yes, it is a Yahoo glitch. Hopefully temporary.

On Mon, Mar 31, 2014 at 9:25 AM, <craig.mckay@sympatico.ca> wrote:

>
> I manually checked a number of the securities that I download from Yahoo
> and there seems to be chunks of data missing for certain securities and in
> some cases the numbers don't seem to line up with other data sources for a
> given date. Will work on the assumption that it is a Yahoo Finance data
> glitch and hopefully they resolve it soon. Thanks for your help.
>

Mon Mar 31, 2014 8:35 pm (PDT) . Posted by:

tenenbaum88

I'm also having this problem at the moment. Is there a way we can get our historical data from Google using the smf addin?

Mon Mar 31, 2014 9:17 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

See:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/20792

On Mon, Mar 31, 2014 at 8:35 PM, <kenneth.dooley@gmail.com> wrote:

>
> I'm also having this problem at the moment. Is there a way we can get our
> historical data from Google using the smf addin?
>

Mon Mar 31, 2014 12:24 pm (PDT) . Posted by:

craze501510

Hi,
Really enjoy the add-in. Thanks.
The rchcreatecomment works great. When you hover the cell, a stock chart appears.
My question is the following:
Is there a way to click the cell where the function/comment is, and have the chart appear on a pop up dialog box, or some other pop up box? Just starting to learn VBA in Excel. Thanks.
Rob

Mon Mar 31, 2014 12:27 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You could probably code an event for it. I haven't done much of that.

A question better suit for a Yahoo group that focuses on EXCEL.

https://groups.yahoo.com/neo/groups/ms_excel/info

On Mon, Mar 31, 2014 at 12:15 PM, <robls@roadrunner.com> wrote:

>
> The rchcreatecomment works great. When you hover the cell, a stock chart
> appears.
>
> My question is the following:
>
> Is there a way to click the cell where the function/comment is, and have
> the chart appear on a pop up dialog box, or some other pop up box? Just
> starting to learn VBA in Excel. Thanks.
>
>

Mon Mar 31, 2014 1:19 pm (PDT) . Posted by:

craze501510

Thanks, Randy. I'll head on over to that other group.

Mon Mar 31, 2014 2:44 pm (PDT) . Posted by:

vijay_polina

Excel 2013 is very slow when using the Add-In.


Any one experiencing the issue. Most of the calls are smfPriceByDates and in 2010 it used to be very fast.


Thanks
VJ

Mon Mar 31, 2014 2:47 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Because Yahoo has been flaky lately, I'd guess the speed problem is a
(hopefully temporary) Yahoo issue and not the version of EXCEL.

On Mon, Mar 31, 2014 at 1:03 PM, <john.harold@gmail.com> wrote:

>
> Excel 2013 is very slow when using the Add-In.
>
> Any one experiencing the issue. Most of the calls are smfPriceByDates and
> in 2010 it used to be very fast.
>
>

Mon Mar 31, 2014 6:35 pm (PDT) . Posted by:

"V. Shankar" tarakayan

I don't see any problem.  I just migrated to core i5 and Excel 2013.  It's working great and better than xp/2010.
On Tuesday, April 1, 2014 3:17 AM, Randy Harmelink <rharmelink@gmail.com> wrote:

 
Because Yahoo has been flaky lately, I'd guess the speed problem is a (hopefully temporary) Yahoo issue and not the version of EXCEL.

On Mon, Mar 31, 2014 at 1:03 PM, <john.harold@gmail.com> wrote:

>Excel 2013 is very slow when using the Add-In.
>
>
>
>Any one experiencing the issue. Most of the calls are smfPriceByDates and in 2010 it used to be very fast.
>

Mon Mar 31, 2014 6:47 pm (PDT) . Posted by:

"Nikola Ganev" ganevniko

Thank you for your helpRandy, this is probably going to fix the problem. I will reinstall the add in on the machine that doesnt work tomorrow and I will let you know.

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, March 27, 2014 12:26 PM
Subject: Re: [smf_addin] Issue with smfGetAdvFNElement formula

 
The problem is you have an older version of the add-in on that computer -- 2.1.2012.12.29.

I had to make a change to the smfGetAdvFNElement() function in 2013 to because of AdvFN website changes. From the change log:

Date Routine Description
2013-10-16 smfGetAdvFNElement Changed this routine to use the new AdvFN web site structure
2013-10-17 smfGetAdvFNElement Additional fix of above change

I did note that as a possible issue earlier:

"Are both machines running the same version of the add-in? I did have to make changes to the add-in last year to allow AdvFN data retrievals to continue working."

On Thu, Mar 27, 2014 at 8:53 AM, Nikola Ganev <ganevniko@yahoo.com> wrote:

>
>Here is what I get :
> 
>Error
>Stock Market Functions add-in, Version 2.1.2012.12.29 (C:\Program Files\SMF Add-In; 1)
>/exchanges/NYSE/MMM/financials?mode=quarterly_repo
>/exchanges/NYSE/MMM/financials"><link rel='stylesh
>2004/12
>Error
>Error
>

Diposting oleh EXCEL FEED LEARNING di 01.05

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)