Rabu, 26 Juni 2013

[smf_addin] Digest Number 2672

15 New Messages

Digest #2672
1b
1d
1e
1f
2a
2b
Re: MSN moved the goal posts by "Randy Harmelink" rharmelink
3a
how to get RCHGetHTMLTable to update? by "jimexstock" jimexstock
3b
Re: how to get RCHGetHTMLTable to update? by "Randy Harmelink" rharmelink
3c
5a
Re: earnings.com data issue? by "sjagers" sjagers

Messages

Wed Jun 26, 2013 6:11 am (PDT) . Posted by:

"ben916770" ben916770

Hi Randy

Similar to the question above. I am getting "undefined" from, for example "=RCHGetElementNumber("IBM", 941)"

I have checked, all the smf-elements-*.txt files are in the "C:/programs/SMF Add-In" folder.

The other functions (getYahooQuotes etc..) are working perfectly.

I'm running Excel2010.

Any suggestions greatly appreciated.

Ben

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Typically, "undefined&quot; means you don't have the element definition files in
> the same folder as the add-in file. Those are the smf-elements-*.txt files.
>
> BTW, your formulas below are invalid, as KO is a cell reference and not a
> ticker symbol literal.
>
> On Tue, May 14, 2013 at 6:45 AM, njouellette83 <nouellette83@...>wrote:
>
> >
> > I used to run these formulas however now they only show up as "undefined&quot;
> > any assistance. It is for the BVPS, and the DPS from years 1 through 6. I
> > didn't add all the elements but they are all not functioning.
> >
> > =RCHGetElementNumber(KO,5901)
> > =RCHGetElementNumber(KO,969)
> > =RCHGetElementNumber(KO,7691)
> >
>

Wed Jun 26, 2013 6:42 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

What do you get with:

=RCHGetElementNumber("Version&quot;)

On Wed, Jun 26, 2013 at 6:11 AM, ben916770 <benjaminheaton@btinternet.com>wrote:

>
> Similar to the question above. I am getting "undefined&quot; from, for example
> "=RCHGetElementNumber("IBM", 941)"
>
> I have checked, all the smf-elements-*.txt files are in the
> "C:/programs/SMF Add-In" folder.
>
> The other functions (getYahooQuotes etc..) are working perfectly.
>
> I'm running Excel2010.
>
> Any suggestions greatly appreciated.
>
> Ben
>

Wed Jun 26, 2013 8:09 am (PDT) . Posted by:

"westslope" ew_poole

Hello Randy and fellow number crunchers,

Busy here shopping a replacement for =MSNStockQuote() since it stopped reliably working on 19 June 2013.

=RCHGetElementNumber("Version&quot;) in Excel 2007/Win 7 32-bit produces:

Stock Market Functions add-in, Version 2.1.2013.06.03 (C:\Program Files\SMF Add-in; 2)

What does the 2 argument represent?

regards -Erik

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> What do you get with:
>
> =RCHGetElementNumber("Version&quot;)
>
> On Wed, Jun 26, 2013 at 6:11 AM, ben916770 <benjaminheaton@...>wrote:
>
> >
> > Similar to the question above. I am getting "undefined&quot; from, for example
> > "=RCHGetElementNumber("IBM", 941)"
> >
> > I have checked, all the smf-elements-*.txt files are in the
> > "C:/programs/SMF Add-In" folder.
> >
> > The other functions (getYahooQuotes etc..) are working perfectly.
> >
> > I'm running Excel2010.
> >
> > Any suggestions greatly appreciated.
> >
> > Ben
> >
>

Wed Jun 26, 2013 8:51 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The "2" is your country code. I added that so I could see if someone has a
non-US setting.

I don't know if this will help on MSNStockQuote() or not:

http://www.excelforum.com/excel-formulas-and-functions/932893-msn-stock-quotes-plugin-stopped-working-june-2013-a.html

On Wed, Jun 26, 2013 at 7:52 AM, westslope <ew_poole@yahoo.ca> wrote:

> Hello Randy and fellow number crunchers,
>
> Busy here shopping a replacement for =MSNStockQuote() since it stopped
> reliably working on 19 June 2013.
>
> =RCHGetElementNumber("Version&quot;) in Excel 2007/Win 7 32-bit produces:
>
> Stock Market Functions add-in, Version 2.1.2013.06.03 (C:\Program
> Files\SMF Add-in; 2)
>
> What does the 2 argument represent?
>
> regards -Erik
>

Wed Jun 26, 2013 9:38 am (PDT) . Posted by:

"woodburydance" woodburydance

The MSN plugin works but it is spotty. I changed all of my "US" to "" and it works mot of the time. When it doesn't about 15 of 85 stocks don't work. I just change the "" to "UK" and they work. That is why I am looking at Stock Market Functions add-in. I have not switched yet. I just want to get the current price and current yield added to my existing spreadsheet not touching any of the cells around them. It seems that your product is the only one on the internet that may do that. I just have to sit down and try it.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The "2" is your country code. I added that so I could see if someone has a
> non-US setting.
>
> I don't know if this will help on MSNStockQuote() or not:
>
> http://www.excelforum.com/excel-formulas-and-functions/932893-msn-stock-quotes-plugin-stopped-working-june-2013-a.html
>
> On Wed, Jun 26, 2013 at 7:52 AM, westslope <ew_poole@...> wrote:
>
> > Hello Randy and fellow number crunchers,
> >
> > Busy here shopping a replacement for =MSNStockQuote() since it stopped
> > reliably working on 19 June 2013.
> >
> > =RCHGetElementNumber("Version&quot;) in Excel 2007/Win 7 32-bit produces:
> >
> > Stock Market Functions add-in, Version 2.1.2013.06.03 (C:\Program
> > Files\SMF Add-in; 2)
> >
> > What does the 2 argument represent?
> >
> > regards -Erik
> >
>

Wed Jun 26, 2013 9:41 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The RCHGetYahooQuotes() function can easily get you current price and
trailing yield. If you want forward yield, you would need to go to the
RCHGetElementNumber() function.

On Wed, Jun 26, 2013 at 9:06 AM, woodburydance <bameyer@optonline.net>wrote:

> The MSN plugin works but it is spotty. I changed all of my "US" to "" and
> it works mot of the time. When it doesn't about 15 of 85 stocks don't
> work. I just change the "" to "UK" and they work. That is why I am
> looking at Stock Market Functions add-in. I have not switched yet. I just
> want to get the current price and current yield added to my existing
> spreadsheet not touching any of the cells around them. It seems that your
> product is the only one on the internet that may do that. I just have to
> sit down and try it.
>

Wed Jun 26, 2013 4:47 pm (PDT) . Posted by:

"westslope" ew_poole

Thanks. Actually what helped understanding the MSNStockQuote() issues were posts on this forum pointing to the n=50 size limit.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The "2" is your country code. I added that so I could see if someone has a
> non-US setting.
>
> I don't know if this will help on MSNStockQuote() or not:
>
> http://www.excelforum.com/excel-formulas-and-functions/932893-msn-stock-quotes-plugin-stopped-working-june-2013-a.html
>
> On Wed, Jun 26, 2013 at 7:52 AM, westslope <ew_poole@...> wrote:
>
> > Hello Randy and fellow number crunchers,
> >
> > Busy here shopping a replacement for =MSNStockQuote() since it stopped
> > reliably working on 19 June 2013.
> >
> > =RCHGetElementNumber("Version&quot;) in Excel 2007/Win 7 32-bit produces:
> >
> > Stock Market Functions add-in, Version 2.1.2013.06.03 (C:\Program
> > Files\SMF Add-in; 2)
> >
> > What does the 2 argument represent?
> >
> > regards -Erik
> >
>

Wed Jun 26, 2013 4:53 pm (PDT) . Posted by:

"westslope" ew_poole

The MSN plug-in will only retrieve a maximum of 50 titles in one workbook.

I changed "US" to "U" and that worked well. Canadian warrants no longer work; income trusts and ETFs show unit prices but nothing else.

Randy has gone on in the past about limiting download sizes. If I understood correctly, the issue was one of minimizing the resource costs of private firms providing free information. Good ethics, good manners.

Perhaps we should look at it differently. If many folks scraping financial information off the web get 'greedy&#39;, the publicly available data might one day disappear.

--- In smf_addin@yahoogroups.com, "woodburydance" <bameyer@...> wrote:
>
> The MSN plugin works but it is spotty. I changed all of my "US" to "" and it works mot of the time. When it doesn't about 15 of 85 stocks don't work. I just change the "" to "UK" and they work. That is why I am looking at Stock Market Functions add-in. I have not switched yet. I just want to get the current price and current yield added to my existing spreadsheet not touching any of the cells around them. It seems that your product is the only one on the internet that may do that. I just have to sit down and try it.
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > The "2" is your country code. I added that so I could see if someone has a
> > non-US setting.
> >
> > I don't know if this will help on MSNStockQuote() or not:
> >
> > http://www.excelforum.com/excel-formulas-and-functions/932893-msn-stock-quotes-plugin-stopped-working-june-2013-a.html
> >
> > On Wed, Jun 26, 2013 at 7:52 AM, westslope <ew_poole@> wrote:
> >
> > > Hello Randy and fellow number crunchers,
> > >
> > > Busy here shopping a replacement for =MSNStockQuote() since it stopped
> > > reliably working on 19 June 2013.
> > >
> > > =RCHGetElementNumber("Version&quot;) in Excel 2007/Win 7 32-bit produces:
> > >
> > > Stock Market Functions add-in, Version 2.1.2013.06.03 (C:\Program
> > > Files\SMF Add-in; 2)
> > >
> > > What does the 2 argument represent?
> > >
> > > regards -Erik
> > >
> >
>

Wed Jun 26, 2013 7:40 am (PDT) . Posted by:

"ron125" ron125

Entering =RCHGetElementNumber("Version&quot;)
Results in #NAME?

Glad to find out that it would not show up on the add-in tab.

I want to make sure I got the correct compressed file.
The add-in file I downloaded is RCH_Stock_Market_Functions-2.1.2012.12.29.zip

When expanding them into the correct directory (C:\Program Files\SMF Add-in)I notice the add-in "RCH_Stock_Market_Functions"looks like an excel spread sheet with a red dot.

There is another Excel doc: RCHGetElementNumber-Element-Definitions

The following following two word documents are there:
. A better method. Use the RCHGetYahooQuotes( ) function.
RCHGetYahooQuotes+Procedure

The rest of the files are text
smf-elements from 0-9, and one info.

There is one other thought.
I also have programs in (C:\Program Files (x86.
Not sure if this makes a difference since it when adding the add-in I point to the correct location.

I am at a loss as to why the add-in seems not to be installed.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> There's no reason it would show up on the add-in tab.
>
> The SMF add-in is primarily a collection of user-defined functions.
>
> An easy check to see if the add-in has been installed:
>
> =RCHGetElementNumber("Version&quot;)
>
> If this returns #NAME?, it's not installed. Otherwise, it should tell you
> what version of the add-in you have installed.
>
> On Tue, Jun 25, 2013 at 8:09 PM, ron125 <ron125@...> wrote:
>
> >
> > I went to File>Options>Add-ins> I had to browse "Ad-ins" and did not see
> > it. I browsed the location and added it. The add-in showed up in the
> > dialogue along with one other from Microsoft. . However, the add-in does
> > not show up on the top of the add-in tab.
> >
> > I tried the process again, and when trying to install the add-in I get a
> > message saying the add-in exists in this location. Do you want to replace
> > it? If I say yes, I get a message saying, cannot find the add in.
> >
>

Wed Jun 26, 2013 8:35 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

On Wed, Jun 26, 2013 at 7:40 AM, ron125 <ron125@yahoo.com> wrote:

> Entering =RCHGetElementNumber("Version&quot;)
> Results in #NAME?
>

That means it can't find the function, so it can't be installed properly.

>
> I want to make sure I got the correct compressed file.
> The add-in file I downloaded is
> RCH_Stock_Market_Functions-2.1.2012.12.29.zip
>

That is the latest official version...

> When expanding them into the correct directory (C:\Program Files\SMF
> Add-in)I notice the add-in "RCH_Stock_Market_Functions"looks like an excel
> spread sheet with a red dot.
>

Could be. It should be an XLA file.

> There is another Excel doc: RCHGetElementNumber-Element-Definitions
>

That's a workbook with a list of element definitions for the
RCHGetElementNumber() function.

> The following following two word documents are there:
> . A better method. Use the RCHGetYahooQuotes( ) function.
> RCHGetYahooQuotes+Procedure
>

I have no idea what those are.

> The rest of the files are text
> smf-elements from 0-9, and one info.
>

Those contain the actual element definitions.

> There is one other thought.
> I also have programs in (C:\Program Files (x86.
> Not sure if this makes a difference since it when adding the add-in I
> point to the correct location.
>

Shouldn't matter.

I am at a loss as to why the add-in seems not to be installed.
>

Is it checked when you go to the list of add-ins in the add-in manager?

Wed Jun 26, 2013 8:09 am (PDT) . Posted by:

"jimexstock" jimexstock

Hi,
I am using RCHGetHTMLTable to get a bulk load of current option prices from Yahoo.

=RCHGetHTMLTable("http://finance.yahoo.com/quotes/" & NQL!$R$1, "TIME & PRICE",-1, "",1 )

Works great except it only seems to update when I first load the spreadsheet. I have tried using the following to force updates but it does not seem to get the table to update:

Application.Run "smfUpdateDownloadTable "
Application.Run "smfForceRecalculation"

Any help would be appreciated.

Wed Jun 26, 2013 8:55 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Do you have something set up for smfUpdateDownloadTable? If you do, you
should run smfForceRecalculation first. Otherwise, its updates will process
from the add-in's previously saved web pages, and not new ones.

If smfForceRecalculation is not doing the updates, it could be you need to
update your Internet Explorer options. See the 2nd item on
smfForceRecalculation in the LINKS area of the group.

I just have smfForceRecalculation assigned to a button on my toolbar, so I
don't need special VBA code in a worksheet. I assume your VBA project has
the add-in set up as a reference library? Otherwise, it wouldn't compile.

On Wed, Jun 26, 2013 at 7:36 AM, jimexstock <jim_w_baker@hotmail.com> wrote:

> I am using RCHGetHTMLTable to get a bulk load of current option prices
> from Yahoo.
>
> =RCHGetHTMLTable("http://finance.yahoo.com/quotes/" & NQL!$R$1, "TIME &
> PRICE",-1, "",1 )
>
> Works great except it only seems to update when I first load the
> spreadsheet. I have tried using the following to force updates but it does
> not seem to get the table to update:
>
> Application.Run "smfUpdateDownloadTable "
> Application.Run "smfForceRecalculation"
>
> Any help would be appreciated.
>

Wed Jun 26, 2013 12:38 pm (PDT) . Posted by:

"jimexstock" jimexstock


Randy,
it was the IE options. Once I set it to check each time all I needed was the smfForceRecalculation and it worked great.

Thanks for the help..

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Do you have something set up for smfUpdateDownloadTable? If you do, you
> should run smfForceRecalculation first. Otherwise, its updates will process
> from the add-in's previously saved web pages, and not new ones.
>
> If smfForceRecalculation is not doing the updates, it could be you need to
> update your Internet Explorer options. See the 2nd item on
> smfForceRecalculation in the LINKS area of the group.
>
> I just have smfForceRecalculation assigned to a button on my toolbar, so I
> don't need special VBA code in a worksheet. I assume your VBA project has
> the add-in set up as a reference library? Otherwise, it wouldn't compile.
>
> On Wed, Jun 26, 2013 at 7:36 AM, jimexstock <jim_w_baker@...> wrote:
>
> > I am using RCHGetHTMLTable to get a bulk load of current option prices
> > from Yahoo.
> >
> > =RCHGetHTMLTable("http://finance.yahoo.com/quotes/" & NQL!$R$1, "TIME &
> > PRICE",-1, "",1 )
> >
> > Works great except it only seems to update when I first load the
> > spreadsheet. I have tried using the following to force updates but it does
> > not seem to get the table to update:
> >
> > Application.Run "smfUpdateDownloadTable "
> > Application.Run "smfForceRecalculation"
> >
> > Any help would be appreciated.
> >
>

Wed Jun 26, 2013 4:46 pm (PDT) . Posted by:

"westslope" ew_poole

50 at the outside. One workbook seems to conk out at well under 40 titles, not sure why.

--- In smf_addin@yahoogroups.com, "V. Shankar" <tarakayan@...> wrote:
>
> When you download daily stock market info in Excel using MSN Money Central, using Data Query, it used to accept 100 stock symbols at a time for  various data.
>
> Now it looks like it can accept 50 symbols only...Anyone experienced this?
>
> thanks,
> Shankar
>

Wed Jun 26, 2013 7:07 pm (PDT) . Posted by:

"sjagers" sjagers

Randy.... Could this be the new URL for earnings.com data?

http://www.fulldisclosure.com/company.asp?ticker=PAYX&coid=87087&client=cb

The URL, abovve, is for Paychex earnings history.

I just did an internet search and it popped up. Looks just like the previous website.

Can I modify your GetElementNumber macro or text file to see if we can pull data from the website?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> It looks like the website no longer exists. If I type the URL into my
> browser, I get redirected to:
>
> http://www.reuters.com/finance/markets/earnings
>
> ...so Reuters must have acquired them, or merged them into their website.
>
> The dividend and split history can be retrieved from Yahoo, but I don't
> know of another source of the earnings announcements history...
>
> On Mon, Jun 17, 2013 at 7:33 AM, mahluwa <mahluwa@...> wrote:
>
> >
> > Is there a problem with earnings.com, elements: 1286 onwards? I'm using
> > latest version (released dec 12) but all fore-mentioned elements using
> > RCHGetElementNumber() come back with error. If indeed there is a problem,
> > are there alternative elements available providing same information? Do I
> > need to patch a file?
> >
>

Diposting oleh EXCEL FEED LEARNING di 19.07

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)