I just tried several dozen and they're working fine here. They did revamp
their website structure last year, which required elements to be redefined.
But nothing recently I'm aware of, unless you can give more details, like
example ticker symbols and element numbers.

On Thu, May 9, 2013 at 7:15 AM, Danny <danzig_36526@yahoo.com> wrote:

> Anyone else noticing lack of elements from MSN recently?
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2a

Excel freezes with Macros activated

Thu May 9, 2013 8:50 am (PDT) . Posted by:

"ssztaba" ssztaba

I added a worksheet with the RCHGETYahoo array formula, and then used the VLOOKUP function, as you suggested, to get the data I want to another worksheet.

When I set up the Array formula and the VLOOKUP formulas, everything seemed to work fine and I got yesterday's EOD prices and they were transferred correctly via the VLOOKUP function.

Yet when I then tried to do the smfForceRecalculation macro to get current prices everything in Excel froze. After force quitting out of Excel I am now unable to correctly open the workbook if I activate the Macros. I don't even get a movable cursor.

Any thoughts ??

Thanks

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2b

Re: Excel freezes with Macros activated

Thu May 9, 2013 1:56 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Why would you need to activate macros?

That's the only thing that sounds unusual to me in your description.

On Thu, May 9, 2013 at 8:50 AM, ssztaba <ssjurik@optonline.net> wrote:

> I added a worksheet with the RCHGETYahoo array formula, and then used the
> VLOOKUP function, as you suggested, to get the data I want to another
> worksheet.
>
> When I set up the Array formula and the VLOOKUP formulas, everything
> seemed to work fine and I got yesterday's EOD prices and they were
> transferred correctly via the VLOOKUP function.
>
> Yet when I then tried to do the smfForceRecalculation macro to get current
> prices everything in Excel froze. After force quitting out of Excel I am
> now unable to correctly open the workbook if I activate the Macros. I
> don't even get a movable cursor.
>
> Any thoughts ??
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2c

Re: Excel freezes with Macros activated

Thu May 9, 2013 2:25 pm (PDT) . Posted by:

"ssztaba" ssztaba

I have a macro activated by a button which does nothing except call the smfForceRecalculation routine (so that I don't have to do the F8 and then Run the smfForceRecalculation routine.)

In any case, I just re-opened my workbook, and activated the Macros, and used the button, and everything worked like it is supposed to. So, whatever I did before must have cleared when I force closed Excel and then restarted my computer. (but I had tried that before my first message -- oh well)

Thanks for your help, and for all you've done with the add-on

Stan

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Why would you need to activate macros?
>
> That's the only thing that sounds unusual to me in your description.
>
> On Thu, May 9, 2013 at 8:50 AM, ssztaba <ssjurik@...> wrote:
>
> > I added a worksheet with the RCHGETYahoo array formula, and then used the
> > VLOOKUP function, as you suggested, to get the data I want to another
> > worksheet.
> >
> > When I set up the Array formula and the VLOOKUP formulas, everything
> > seemed to work fine and I got yesterday's EOD prices and they were
> > transferred correctly via the VLOOKUP function.
> >
> > Yet when I then tried to do the smfForceRecalculation macro to get current
> > prices everything in Excel froze. After force quitting out of Excel I am
> > now unable to correctly open the workbook if I activate the Macros. I
> > don't even get a movable cursor.
> >
> > Any thoughts ??
> >
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

3a

Length of Company Name

Thu May 9, 2013 3:09 pm (PDT) . Posted by:

"ssztaba" ssztaba

Is there a user controllable way to affect the length of the Company Name returned with the 'n' code of the GetYahooQuotes function ??

For example currently US Steel comes back as 'United States Ste', and Akamai comes back as 'Akamai Technologi' The default setting seems to allow a maximum of 17 characters.

Thanks

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

3b

Re: Length of Company Name

Thu May 9, 2013 4:56 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Nope. Sorry. All of that is set by Yahoo...

On Thu, May 9, 2013 at 3:09 PM, ssztaba <ssjurik@optonline.net> wrote:

> Is there a user controllable way to affect the length of the Company Name
> returned with the 'n' code of the GetYahooQuotes function ??
>
> For example currently US Steel comes back as 'United States Ste', and
> Akamai comes back as 'Akamai Technologi' The default setting seems to
> allow a maximum of 17 characters.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

3c

Re: Length of Company Name

Thu May 9, 2013 4:57 pm (PDT) . Posted by:

"antonvanas1989" antonvanas1989

I have the same problem with GetYahooQuotes "n" function. Unfortunately i do not know how to change it.

--- In smf_addin@yahoogroups.com, "ssztaba" <ssjurik@...> wrote:
>
> Is there a user controllable way to affect the length of the Company Name returned with the 'n' code of the GetYahooQuotes function ??
>
> For example currently US Steel comes back as 'United States Ste', and Akamai comes back as 'Akamai Technologi' The default setting seems to allow a maximum of 17 characters.
>
> Thanks
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

3d

Re: Length of Company Name

Thu May 9, 2013 5:04 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The only way to change it is to get the data from another source. But most
other methods of retrieving it will be slower, since it would get the data
with one Internet access per company name request.

On Thu, May 9, 2013 at 4:57 PM, antonvanas1989 <antonvanas1989@yahoo.com>wrote:

> I have the same problem with GetYahooQuotes "n" function. Unfortunately i
> do not know how to change it.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

4a

Questions on RCHGetYahooHistory() & RCHGetYahooQuotes()

Thu May 9, 2013 3:27 pm (PDT) . Posted by:

"BEN HEATON" ben916770

Hi Randy

I've been using you excellent add-in for several years - thanks.

Currently doing some development with historical stock prices(excel 2010) which has resulted in the following questions:

1. When trying to get price history for UK stocks (for example "NXT.L"), I use RCHGetYahooHistory() to fetch the price history for the days prior to the current date. I use RCHGetYahooQuotes to fetch today's prices.
The date of prices fetched by RCHGetYahooQuotes() is 9th May (todays price). The first price fetched by RCHGetYahooHistory() is for 7th May. Where is the data for 8th May?

The problem is peculiar to UK stocks (I believe), because when I select a US stock, the most recent historical price fetched by RCHGetYahooHistory() is 8th May, which is as I would expect.

2. For NXT.L we've also noticed that each day there is a difference in Close value and
Adj.Close value, but there has not been a dividend or stock split in recent days

http://finance.yahoo.com/q/hp?s=NXT.L+Historical+Prices
seems there is no "dividend" applied daily, but how the
Adj.close value changing every day?

when compared with ARM.L
http://finance.yahoo.com/q/hp?s=ARM.L+Historical+Prices
ARM.L looks good with "Close value" and "Adj.Close" value ie. no
changes in "close value" and "Adj.close value" everyday.

3. Could you also clarify when the adjusted price isaccessible by your add ins? We currently use
RCHGetYahooHistory() to fetch historical adjusted prices, but i'm struggling with the idea if adjusted price for todays close. Is it possible to get that before hacing to wait till the following day and use
RCHGetYahooHistory().

I've looked in the supporting documentation for RCHGetYahooQuotes() and cannot see any mention of adjusted close.

Many thanks

Ben Heaton

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

4b

Questions on RCHGetYahooHistory() & RCHGetYahooQuotes()

Thu May 9, 2013 3:29 pm (PDT) . Posted by:

"ben916770" ben916770

Hi Randy

I've been using you excellent add-in for several years - thanks.

Currently doing some development with historical stock prices(excel 2010) which has resulted in the following questions:

1. When trying to get price history for UK stocks (for example "NXT.L"), I use RCHGetYahooHistory() to fetch the price history for the days prior to the current date. I use RCHGetYahooQuotes to fetch today's prices.
The date of prices fetched by RCHGetYahooQuotes() is 9th May (todays price). The first price fetched by RCHGetYahooHistory() is for 7th May. Where is the data for 8th May?

The problem is peculiar to UK stocks (I believe), because when I select a US stock, the most recent historical price fetched by RCHGetYahooHistory() is 8th May, which is as I would expect.

2. For NXT.L we've also noticed that each day there is a difference in Close value and Adj.Close value, but there has not been a dividend or stock split in recent days
http://finance.yahoo.com/q/hp?s=NXT.L+Historical+Prices
seems there is no "dividend"; applied daily, but how the Adj.close value changing every day?

when compared with ARM.L
http://finance.yahoo.com/q/hp?s=ARM.L+Historical+Prices
ARM.L looks good with "Close value" and "Adj.Close" value ie. no changes in "close value" and "Adj.close value" everyday.

3. Could you also clarify when the adjusted price is accessible by your add ins? We currently use
RCHGetYahooHistory() to fetch historical adjusted prices, but i'm struggling with the idea if adjusted price for todays close. Is it possible to get that before hacing to wait till the following day and use
RCHGetYahooHistory().

I've looked in the supporting documentation for RCHGetYahooQuotes() and cannot see any mention of adjusted close.

Many thanks

Ben Heaton

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

4c

Re: Questions on RCHGetYahooHistory() & RCHGetYahooQuotes()

Thu May 9, 2013 5:00 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

On Thu, May 9, 2013 at 3:27 PM, BEN HEATON <benjaminheaton@btinternet.com>wrote:

> Currently doing some development with historical stock prices(excel
> 2010) which has resulted in the following questions:
>
> 1. When trying to get price history for UK stocks (for example "NXT.L"), I
> use RCHGetYahooHistory() to fetch the price history for the days prior to
> the current date. I use RCHGetYahooQuotes to fetch today's prices.
> The date of prices fetched by RCHGetYahooQuotes() is 9th May (todays
> price). The first price fetched by RCHGetYahooHistory() is for 7th May.
> Where is the data for 8th May?
>
> The problem is peculiar to UK stocks (I believe), because when I select a
> US stock, the most recent historical price fetched by RCHGetYahooHistory()
> is 8th May, which is as I would expect.
>

Question for Yahoo, not me. Use the feedback link at the bottom of their
historical quotes page:

http://finance.yahoo.com/q/hp?s=NXT.L+Historical+Prices

> 2. For NXT.L we've also noticed that each day there is a difference in
> Close value and Adj.Close value, but there has not been a dividend or stock
> split in recent days
> http://finance.yahoo.com/q/hp?s=NXT.L+Historical+Prices
> seems there is no "dividend" applied daily, but how the Adj.close value
> changing every day?
>
> when compared with ARM.L
> http://finance.yahoo.com/q/hp?s=ARM.L+Historical+Prices
> ARM.L looks good with "Close value" and "Adj.Close" value ie. no changes
> in "close value" and "Adj.close value" everyday.
>

Also a question for Yahoo. Definitely looks hinky to me.

3. Could you also clarify when the adjusted price is accessible by your add
> ins? We currently use
> RCHGetYahooHistory() to fetch historical adjusted prices, but i'm
> struggling with the idea if adjusted price for todays close. Is it possible
> to get that before hacing to wait till the following day and use
> RCHGetYahooHistory().
>
> I've looked in the supporting documentation for RCHGetYahooQuotes() and
> cannot see any mention of adjusted close.
>

It's available whenever Yahoo posts it. All the add-in does is retrieve
what they are providing...

Otherwise, I'm not sure if you're asking a different question or not.

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

5a

data from Google

Thu May 9, 2013 4:22 pm (PDT) . Posted by:

"Lawrence" lawleesh

Hi

Is there a problem downloading data from Google? I find that the SMF addin could download from Yahoo etc but those from Google returned error messages.

regards

LL

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

5b

Re: data from Google

Thu May 9, 2013 5:03 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You're going to have to provide a more detailed description of your problem
if you expect an answer. I'm not a mind reader. I have no idea what kinds
of formulas you're having problems with.

On Thu, May 9, 2013 at 4:22 PM, Lawrence <lawrence.leesh@gmail.com> wrote:

>
> Is there a problem downloading data from Google? I find that the SMF addin
> could download from Yahoo etc but those from Google returned error messages.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

5c

Re: data from Google

Thu May 9, 2013 6:33 pm (PDT) . Posted by:

"Lawrence" lawleesh

Hi Randy

I thought that Google might have switched to dynamic web pages which caused info not to be downloaded.

One of the formulas I have difficulty with is =RCHGetElementNumber("aa",2742). It returned "Error".

thanks

LL

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You're going to have to provide a more detailed description of your problem
> if you expect an answer. I'm not a mind reader. I have no idea what kinds
> of formulas you're having problems with.
>
> On Thu, May 9, 2013 at 4:22 PM, Lawrence <lawrence.leesh@...> wrote:
>
> >
> > Is there a problem downloading data from Google? I find that the SMF addin
> > could download from Yahoo etc but those from Google returned error messages.
> >
>