Messages In This Digest (25 Messages)

1a.: Forward earnings estimates help From: tenenbaum88
1b.: Re: Forward earnings estimates help From: Randy Harmelink
1c.: Re: Forward earnings estimates help From: tenenbaum88

2a.: Great stuff From: bob_cutillo
2b.: Re: Great stuff From: Randy Harmelink

3a.: Error after upgrading to the latest version in the work in progress From: Kermit W. Prather
3b.: Re: Error after upgrading to the latest version in the work in progr From: Mike McQuaid
3c.: Re: Error after upgrading to the latest version in the work in progr From: Randy Harmelink
3d.: Re: Error after upgrading to the latest version in the work in progr From: Kermit W. Prather
3e.: Re: Error after upgrading to the latest version in the work in progr From: Randy Harmelink

4a.: Removing temporary or cache files From: thomas91112
4b.: Re: Removing temporary or cache files From: Randy Harmelink

5a.: Re: Instructions for fixing the elements problem.... From: Patrick Van Beesen
5b.: Re: Instructions for fixing the elements problem.... From: Randy Harmelink
5c.: Re: Instructions for fixing the elements problem.... From: Pete A
5d.: Re: Instructions for fixing the elements problem.... From: Randy Harmelink
5e.: Re: Instructions for fixing the elements problem.... From: Mike McQuaid
5f.: Re: Instructions for fixing the elements problem.... From: Pete A

6a.: smfGetOptionQuotes don't works anymore From: dstange1978
6b.: Re: smfGetOptionQuotes don't works anymore From: Randy Harmelink

7a.: Old spreadsheets dont work after re instalation From: steven_rourk
7b.: Re: Old spreadsheets dont work after re instalation From: Randy Harmelink
7c.: Re: Old spreadsheets dont work after re instalation From: Mike McQuaid
7d.: Re: Old spreadsheets dont work after re instalation From: wschuplak@comcast.net
7e.: Re: Old spreadsheets dont work after re instalation From: steven_rourk

View All Topics | Create New Topic

Messages

1a.: Forward earnings estimates help

Posted by: "tenenbaum88" kenneth.dooley@gmail.com tenenbaum88

Thu May 3, 2012 5:18 am (PDT)

Hi Randy,

Is it possible to use either the RCHGetYahooData or RCHGetYahooHistory functions to return historical forward-looking earnings estimates from Yahoo Finance? I'm running a study and can't seem to figure out how to pull the historical data.

Thanks a lot for the great addon!

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
1b.: Re: Forward earnings estimates help

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Thu May 3, 2012 5:39 am (PDT)

Yahoo wouldn't have such historical data, other than a quarter or two.

Best place I know of to get the historical estimates of earnings for
multiple years would be earnings.com:

http://www.earnings.com/company.asp?client=cb&ticker=MMM

But not a straightforward extraction as the data can be a mix of the parent
corporation and its subsidiaries.

Another source would be StockScreen123.com, as they do have "point in time"
data back to 2001. However, they are not free (and just recently raised the
price). But getting the data out would be a chore. And one the add-in
wouldn't be able to help with.

On Thu, May 3, 2012 at 5:18 AM, tenenbaum88 <kenneth.dooley@gmail.com>wrote:

>
> Is it possible to use either the RCHGetYahooData or RCHGetYahooHistory
> functions to return historical forward-looking earnings estimates from
> Yahoo Finance? I'm running a study and can't seem to figure out how to
> pull the historical data.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
1c.: Re: Forward earnings estimates help

Posted by: "tenenbaum88" kenneth.dooley@gmail.com tenenbaum88

Thu May 3, 2012 6:57 am (PDT)

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Yahoo wouldn't have such historical data, other than a quarter or two.
>
> Best place I know of to get the historical estimates of earnings for
> multiple years would be earnings.com:
>
> http://www.earnings.com/company.asp?client=cb&ticker=MMM
>
> But not a straightforward extraction as the data can be a mix of the parent
> corporation and its subsidiaries.
>
> Another source would be StockScreen123.com, as they do have "point in time"
> data back to 2001. However, they are not free (and just recently raised the
> price). But getting the data out would be a chore. And one the add-in
> wouldn't be able to help with.
>
> On Thu, May 3, 2012 at 5:18 AM, tenenbaum88 <kenneth.dooley@...>wrote:
>
> >
> > Is it possible to use either the RCHGetYahooData or RCHGetYahooHistory
> > functions to return historical forward-looking earnings estimates from
> > Yahoo Finance? I'm running a study and can't seem to figure out how to
> > pull the historical data.
> >
>

Thanks a lot, Randy.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

2a.: Great stuff

Posted by: "bob_cutillo" bob.cutillo@yahoo.com bob_cutillo

Thu May 3, 2012 6:16 am (PDT)

You usually hear about problems. I wanted to tell you how great your tool is. It just keeps getting better and better.

Also, some of the things in making Files > Uploads by forum members > Money making worksheets are great uses of your tool. Is there any documentation for these available as I absolutely blown away by the speed of 1000 input tickers yahoo.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2b.: Re: Great stuff

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Thu May 3, 2012 7:02 am (PDT)

They aren't my workbooks, so I have no documentation available...

The speed is a result of only doing five RCHGetYahooQuotes() functions.
Each invocation of the function can return multiple data items for up to
200 ticker symbols with a single Internet access. The functions need to be
array-entered over a range instead of as individual cells in order to get
the speed, because otherwise each individual cell would require a new
access to the Internet for the data.

On Thu, May 3, 2012 at 6:16 AM, bob_cutillo <bob.cutillo@yahoo.com> wrote:

>
> Also, some of the things in making Files > Uploads by forum members >
> Money making worksheets are great uses of your tool. Is there any
> documentation for these available as I absolutely blown away by the speed
> of 1000 input tickers yahoo.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

3a.: Error after upgrading to the latest version in the work in progress

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com kermitpra

Thu May 3, 2012 6:29 am (PDT)

I just downloaded and replaced my previous SMF addin version with the work
in progress version. Is there another version I should be using?

http://finance.groups.yahoo.com/group/smf_addin/files/Works-In-Progress/

http://f1.grp.yahoofs.com/v1/UIGiT4E-BmDtVZ5MIGyhHVl8sY7Xx01u47nldgfm4UTgF8_
0PKuwAMJi7CmvQulSYVUOf3BFJPMvAwnRC8PrY_3aSBQamj9i/Works-In-Progress/RCH_Stoc
k_Market_Functions-2.1.2012.04.07.zip

\and the latest smf-elements-1.txt file

http://f1.grp.yahoofs.com/v1/UIGiT5XgpJztVZ5MQBrRteb4kWTWiFvEJDK8VZJg1F-XW13
WHBXDmnQYBkt0GEvjeaQbVa8z-zvkh7GnpyHCWTvkgmiyksi3/Works-In-Progress/smf-elem
ents-1.txt

I now get an error in this worksheet that I se to test SMF addin after every
download. First column shows the element call and the third column shows the
result.

Can you explain why I am getting these 2 errors? When I click on the last
RCHGetTablecel call it loads the page just find.

Test new addin version

=RCHGetElementNumber("IBM", 1541)

Error

=RCHGetElementNumber("IBM", 941)

239990000

=RCHGetElementNumber("Version")

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

=RCHGetElementNumber("P-URL",4715)

http://portfolios.morningstar.com/fund/summary?t=~~~~~

=RCHGetElementNumber("VFINX",4715)

99.71

<http://portfolios.morningstar.com/fund/summary?t=VFINX>
=RCHGetTableCell("http://portfolios.morningstar.com/fund/summary?t=VFINX",3,
">As\set Allocation",">US Stock")

<http://portfolios.morningstar.com/fund/summary?t=VFINX> Error

Thanks,

Kermit

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3b.: Re: Error after upgrading to the latest version in the work in progr

Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802

Thu May 3, 2012 6:44 am (PDT)

Element 1541 is from MSN. Maybe it's just me but after MSN's recent website
changes I must go to money.msn.com using Internet Explorer before using SMF.
Once I use IE to look at the website I can use SMF the rest of the day just
fine. The next day I must repeat. I am moving away from using MSN elements
as a result.

I don't get an error with your morningstar element. I am using the
2012.04.07 version with the updated -1.txt file same as you. Did you just
try rerunning it? It could have been a one-off retrieval problem.

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Kermit W. Prather
Sent: Thursday, May 03, 2012 9:29 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Error after upgrading to the latest version in the work
in progress folder.

I just downloaded and replaced my previous SMF addin version with the work
in progress version. Is there another version I should be using?

http://finance.groups.yahoo.com/group/smf_addin/files/Works-In-Progress/

http://f1.grp.yahoofs.com/v1/UIGiT4E-BmDtVZ5MIGyhHVl8sY7Xx01u47nldgfm4UTgF8_
0PKuwAMJi7CmvQulSYVUOf3BFJPMvAwnRC8PrY_3aSBQamj9i/Works-In-Progress/RCH_Stoc
k_Market_Functions-2.1.2012.04.07.zip

\and the latest smf-elements-1.txt file

http://f1.grp.yahoofs.com/v1/UIGiT5XgpJztVZ5MQBrRteb4kWTWiFvEJDK8VZJg1F-XW13
WHBXDmnQYBkt0GEvjeaQbVa8z-zvkh7GnpyHCWTvkgmiyksi3/Works-In-Progress/smf-elem
ents-1.txt

I now get an error in this worksheet that I se to test SMF addin after every
download. First column shows the element call and the third column shows the
result.

Can you explain why I am getting these 2 errors? When I click on the last
RCHGetTablecel call it loads the page just find.

Test new addin version

=RCHGetElementNumber("IBM", 1541)

Error

=RCHGetElementNumber("IBM", 941)

239990000

=RCHGetElementNumber("Version")

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

=RCHGetElementNumber("P-URL",4715)

http://portfolios.morningstar.com/fund/summary?t=~~~~~

=RCHGetElementNumber("VFINX",4715)

99.71

<http://portfolios.morningstar.com/fund/summary?t=VFINX>
=RCHGetTableCell("http://portfolios.morningstar.com/fund/summary?t=VFINX",3,
">As\set Allocation",">US Stock")

<http://portfolios.morningstar.com/fund/summary?t=VFINX> Error

Thanks,

Kermit

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3c.: Re: Error after upgrading to the latest version in the work in progr

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Thu May 3, 2012 7:10 am (PDT)

Element 1541 is working fine here. I would suggest exiting and restarting
EXCEL to make sure all files are being loaded properly. If you replace the
smf-elements-1.txt file while you are in EXCEL, it doesn't load the new
definitions until you run smfForceRecalculation or exit and restart EXCEL.

The RCHGetTableCell() function isn't working probably because of your
search string:

">As\set Allocation"

Take out the backslash and it will work fine.

By the way, the "f1.grp..." URLs are just temporary ones generated by Yahoo
and usually don't work for long. The permanent link for the txt file would
be:

http://finance.groups.yahoo.com/group/smf_addin/files/Works-In-Progress/smf-elements-1.txt

On Thu, May 3, 2012 at 6:29 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:

>
> I just downloaded and replaced my previous SMF addin version with the
> work in progress version. Is there another version I should be using? ****
>
> ** **
>
> http://finance.groups.yahoo.com/group/smf_addin/files/Works-In-Progress/**
> **
>
> ** **
>
>
> http://f1.grp.yahoofs.com/v1/UIGiT4E-BmDtVZ5MIGyhHVl8sY7Xx01u47nldgfm4UTgF8_0PKuwAMJi7CmvQulSYVUOf3BFJPMvAwnRC8PrY_3aSBQamj9i/Works-In-Progress/RCH_Stock_Market_Functions-2.1.2012.04.07.zip
> ****
>
> ** **
>
> \and the latest smf-elements-1.txt file****
>
> ** **
>
>
> http://f1.grp.yahoofs.com/v1/UIGiT5XgpJztVZ5MQBrRteb4kWTWiFvEJDK8VZJg1F-XW13WHBXDmnQYBkt0GEvjeaQbVa8z-zvkh7GnpyHCWTvkgmiyksi3/Works-In-Progress/smf-elements-1.txt
> ****
>
> ** **
>
> I now get an error in this worksheet that I se to test SMF addin after
> every download. First column shows the element call and the third column
> shows the result. ****
>
> ** **
>
> Can you explain why I am getting these 2 errors? When I click on the last
> RCHGetTablecel call it loads the page just find. ****
>
> ** **
>
> *Test new addin version*
>
> =RCHGetElementNumber("IBM", 1541)****
>
> ****
>
> Error****
>
> =RCHGetElementNumber("IBM", 941)****
>
> ****
>
> 239990000****
>
> =RCHGetElementNumber("Version")****
>
> ****
>
> Stock Market Functions add-in, Version 2.1.2012.04.07 (C:\Program
> Files\SMF Add-in; 1)****
>
> =RCHGetElementNumber("P-URL",4715)****
>
> ****
>
> http://portfolios.morningstar.com/fund/summary?t=~~~~~****
>
> =RCHGetElementNumber("VFINX",4715)****
>
> ****
>
> 99.71****
>
> *=RCHGetTableCell("http://portfolios.morningstar.com/fund/summary?t=VFINX",3,">As\set
> Allocation",">US Stock")<http://portfolios.morningstar.com/fund/summary?t=VFINX>
> *
>
> * *
>
> *Error <http://portfolios.morningstar.com/fund/summary?t=VFINX>*
>
> ****
>
> ****
>
> ****
>
> ** **
>
>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3d.: Re: Error after upgrading to the latest version in the work in progr

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com kermitpra

Thu May 3, 2012 9:12 am (PDT)

Thanks for the quick response. No clue how the \ got in the string. Corrected and now works.

I rebooted my Vista 64-bit machine with Excel2007 after submitting the email, reboot was not related to this issue. My Dell V305 color printer keeps getting lost. I know more info than you need.

The 1541 element still does not work FOR IBM. It works for CLS , DAR, EA, GAME, HEK, HWD, KWK, PBI, SIGM, UPL, XLS, GE, AAPL and many more but not IBM.

Any ideas why IBM is not working.

Thanks,
Kermit

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Thursday, May 03, 2012 10:10 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Error after upgrading to the latest version in the work in progress folder.

Element 1541 is working fine here. I would suggest exiting and restarting EXCEL to make sure all files are being loaded properly. If you replace the smf-elements-1.txt file while you are in EXCEL, it doesn't load the new definitions until you run smfForceRecalculation or exit and restart EXCEL.

The RCHGetTableCell() function isn't working probably because of your search string:

">As\set Allocation"

Take out the backslash and it will work fine.

By the way, the "f1.grp..." URLs are just temporary ones generated by Yahoo and usually don't work for long. The permanent link for the txt file would be:

http://finance.groups.yahoo.com/group/smf_addin/files/Works-In-Progress/smf-elements-1.txt
On Thu, May 3, 2012 at 6:29 AM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:

I just downloaded and replaced my previous SMF addin version with the work in progress version. Is there another version I should be using?

http://finance.groups.yahoo.com/group/smf_addin/files/Works-In-Progress/

http://f1.grp.yahoofs.com/v1/UIGiT4E-BmDtVZ5MIGyhHVl8sY7Xx01u47nldgfm4UTgF8_0PKuwAMJi7CmvQulSYVUOf3BFJPMvAwnRC8PrY_3aSBQamj9i/Works-In-Progress/RCH_Stock_Market_Functions-2.1.2012.04.07.zip

\and the latest smf-elements-1.txt file

http://f1.grp.yahoofs.com/v1/UIGiT5XgpJztVZ5MQBrRteb4kWTWiFvEJDK8VZJg1F-XW13WHBXDmnQYBkt0GEvjeaQbVa8z-zvkh7GnpyHCWTvkgmiyksi3/Works-In-Progress/smf-elements-1.txt

I now get an error in this worksheet that I se to test SMF addin after every download. First column shows the element call and the third column shows the result.

Can you explain why I am getting these 2 errors? When I click on the last RCHGetTablecel call it loads the page just find.

Test new addin version

=RCHGetElementNumber("IBM", 1541)

Error

=RCHGetElementNumber("IBM", 941)

239990000

=RCHGetElementNumber("Version")

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

=RCHGetElementNumber("P-URL",4715)

http://portfolios.morningstar.com/fund/summary?t=~~~~~ <http://portfolios.morningstar.com/fund/summary?t=%7E%7E%7E%7E%7E>

=RCHGetElementNumber("VFINX",4715)

99.71

=RCHGetTableCell( <http://portfolios.morningstar.com/fund/summary?t=VFINX> "http://portfolios.morningstar.com/fund/summary?t=VFINX",3,">As\set Allocation",">US Stock")

Error <http://portfolios.morningstar.com/fund/summary?t=VFINX>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3e.: Re: Error after upgrading to the latest version in the work in progr

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Thu May 3, 2012 9:43 am (PDT)

No idea. IBM works fine here.

Could you have a bad cached page in the IE Temporary Internet Files area?
Do you have your Internet Options set to always get a fresh copy of a web
page?

On Thu, May 3, 2012 at 9:12 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:

>
>
> The 1541 element still does not work FOR IBM. It works for CLS , DAR,
> EA, GAME, HEK, HWD, KWK, PBI, SIGM, UPL, XLS, GE, AAPL and many more but
> not IBM. ****
>
> ** **
>
> Any ideas why IBM is not working.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

4a.: Removing temporary or cache files

Posted by: "thomas91112" thomas91112@yahoo.com thomas91112

Thu May 3, 2012 8:52 am (PDT)

Does SMF or RCH functions create any temporary or cache files that may accumulate over time, consuming resources and which should be deleted periodically?

Regards,
Mike

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4b.: Re: Removing temporary or cache files

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Thu May 3, 2012 9:46 am (PDT)

Yes and no. It does save copies of web pages, from which it extracts the
data. So they will certainly take up memory. However, purging them is an
all or nothing deal, using the smfForceRecalculation macro. I usually only
have one workbook open at a time, and run that macro when I close a
workbook (because all the pages I retrieved for it are no longer needed).

But running smfForceRecalculation when you have an open workbook with all
the same formulas won't reduce resources, as it would just get a fresh copy
of the web page to store.

On Thu, May 3, 2012 at 8:52 AM, thomas91112 <thomas91112@yahoo.com> wrote:

> Does SMF or RCH functions create any temporary or cache files that may
> accumulate over time, consuming resources and which should be deleted
> periodically?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

5a.: Re: Instructions for fixing the elements problem....

Posted by: "Patrick Van Beesen" patrick.van.beesen@perso.be patrickvb

Thu May 3, 2012 8:58 am (PDT)

I've the same problem with Excel 2003 on windows XP and it works
perfectly with Excel 2010 on Windows 7

On 03/05/2012 00:34, steven_rourk wrote:
>
> The old file is in the SMF Add-In folder in your computer. You have to
> replace that old file with the new file (smf-elements-1.txt) from the
> "Work in Progress" folder.
>
> Anyway Randy, that is what I did (exiting Excel previously) but I´m
> still having problems with elements 1, 2, 3 etc through 252, and 353
> through 539. It keeps returning "Error".
>
> I´ve got the latest version as of 2012-02-02
>
> --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>,
> "talgg" <talsharon@...> wrote:
> >
> > thanks...but where do i put the file smf-elements-1.txt once i
> download it? i did a search on my computer and i don't think i have
> that file on my computer already in order to replace it...
> >
> > --- In smf_addin@yahoogroups.com
> <mailto:smf_addin%40yahoogroups.com>, Randy Harmelink <rharmelink@> wrote:
> > >
> > > Best practice when updating add-in files:
> > >
> > > 1. Exit EXCEL
> > > 2. Download new file(s), replacing the old one(s)
> > > 3. Restart EXCEL
> > >
> > > In this case, you want the smf-elements-1.txt file from the "Works in
> > > Progress" folder of the files area of the group.
> > >
> > > On Wed, May 2, 2012 at 8:00 AM, talgg <talsharon@> wrote:
> > >
> > > > Randy, thanks for taking the time to fix problems with MSN.
> Would you
> > > > mind please writing specific directions as to what we are
> supposed to do,
> > > > which files to download or copy and what to do with them. i am
> not sure
> > > > what to do.
> > > >
> > >
> >
>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (18)
5b.: Re: Instructions for fixing the elements problem....

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Thu May 3, 2012 9:39 am (PDT)

What do you get with:

=smfGetAParms(1)

On Thu, May 3, 2012 at 8:58 AM, Patrick Van Beesen <
patrick.van.beesen@perso.be> wrote:

>
> I've the same problem with Excel 2003 on windows XP and it works perfectly
> with Excel 2010 on Windows 7
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (18)
5c.: Re: Instructions for fixing the elements problem....

Posted by: "Pete A" optionzz@gmail.com option2z

Thu May 3, 2012 2:41 pm (PDT)

13862 (company name) doesn't work at all when using the utility "GetData" It's been down for several days now; I haven't delved into it because it isn't critical. Is there something differenct about how GetData does it? Thanks Randy!
Pete A

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> All of those element numbers are working fine for me right now:
>
> Element #
> MMM NFLX Element Description
> 13862 3M Co Netflix Inc Company Name 55 15.1 23.8 % Growth Rate --
<snip> 13862.... When do you think the errors of those elements are

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (18)
5d.: Re: Instructions for fixing the elements problem....

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Thu May 3, 2012 2:48 pm (PDT)

I have no idea what GetData is -- it's not part of the add-in.

On Thu, May 3, 2012 at 2:40 PM, Pete A <optionzz@gmail.com> wrote:

> 13862 (company name) doesn't work at all when using the utility "GetData"
> It's been down for several days now; I haven't delved into it because it
> isn't critical. Is there something differenct about how GetData does it?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (18)
5e.: Re: Instructions for fixing the elements problem....

Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802

Thu May 3, 2012 2:50 pm (PDT)

Pete, 13862 comes from MSN. See all the messages recently about the changes
at MSN. In short, you need the new elements-1.txt file in the Works in
Progress folder.

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Pete A
Sent: Thursday, May 03, 2012 5:41 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Instructions for fixing the elements problem....

13862 (company name) doesn't work at all when using the utility "GetData"
It's been down for several days now; I haven't delved into it because it
isn't critical. Is there something differenct about how GetData does it?
Thanks Randy!
Pete A

--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
Randy Harmelink <rharmelink@...> wrote:
>
> All of those element numbers are working fine for me right now:
>
> Element #
> MMM NFLX Element Description
> 13862 3M Co Netflix Inc Company Name 55 15.1 23.8 % Growth Rate --
<snip> 13862.... When do you think the errors of those elements are

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (18)
5f.: Re: Instructions for fixing the elements problem....

Posted by: "Pete A" optionzz@gmail.com option2z

Thu May 3, 2012 3:27 pm (PDT)

Thanks Mike. I had been following that MSM thing, and had downloaded the elements-1.txt file...still doesn't work. Most of the fixes do.

Appreciate the quick response! Save Randy a few minutes...

Pete A

--- In smf_addin@yahoogroups.com, "Mike McQuaid" <mikemcq802@...> wrote:
>
> Pete, 13862 comes from MSN. See all the messages recently about the changes
> at MSN. In short, you need the new elements-1.txt file in the Works in
> Progress folder.
>
> _____
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
> Of Pete A
> Sent: Thursday, May 03, 2012 5:41 PM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Re: Instructions for fixing the elements problem....
>
>
>
>
> 13862 (company name) doesn't work at all when using the utility "GetData"
> It's been down for several days now; I haven't delved into it because it
> isn't critical. Is there something differenct about how GetData does it?
> Thanks Randy!
> Pete A
>
> --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
> Randy Harmelink <rharmelink@> wrote:
> >
> > All of those element numbers are working fine for me right now:
> >
> > Element #
> > MMM NFLX Element Description
> > 13862 3M Co Netflix Inc Company Name 55 15.1 23.8 % Growth Rate --
> <snip> 13862.... When do you think the errors of those elements are
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (18)

6a.: smfGetOptionQuotes don't works anymore

Posted by: "dstange1978" danielcs@floripa.com.br dstange1978

Thu May 3, 2012 11:29 am (PDT)

Since yesterday, the function "smfGetOptionQuotes" is not working anymore in my file. How can I fix this?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
6b.: Re: smfGetOptionQuotes don't works anymore

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Thu May 3, 2012 12:58 pm (PDT)

I have no idea, since you didn't describe the problem. This works fine for
me:

=smfGetOptionQuotes("SPY May 2012 $140 Call","b")

On Thu, May 3, 2012 at 11:29 AM, dstange1978 <danielcs@floripa.com.br>wrote:

> Since yesterday, the function "smfGetOptionQuotes" is not working anymore
> in my file. How can I fix this?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

7a.: Old spreadsheets dont work after re instalation

Posted by: "steven_rourk" steven_rourk@hotmail.com steven_rourk

Thu May 3, 2012 2:36 pm (PDT)

I recently had a problem with my laptop, and they had to change my hardrive , so when I got my laptop back I had to install again the SMF addin. I have Windows 7 and Excell 2007.

I know its installed correctly, because if a create a new spreadsheet and put the formula =RCHGetElementNumber("aapl",6266) it gives me 116371

However when I open my old spreadsheets all the formulas in the cells apears something like this ='C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetElementNumber("aapl",6266) and gives me the error #NAME?

Please help!.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
7b.: Re: Old spreadsheets dont work after re instalation

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Thu May 3, 2012 2:47 pm (PDT)

Check the item in the "Links" area of the group related to location errors
and #NAME? errors.

On Thu, May 3, 2012 at 2:36 PM, steven_rourk <steven_rourk@hotmail.com>wrote:

> I recently had a problem with my laptop, and they had to change my
> hardrive , so when I got my laptop back I had to install again the SMF
> addin. I have Windows 7 and Excell 2007.
>
> I know its installed correctly, because if a create a new spreadsheet and
> put the formula =RCHGetElementNumber("aapl",6266) it gives me 116371
>
> However when I open my old spreadsheets all the formulas in the cells
> apears something like this ='C:\Program Files\SMF
> Add-In\RCH_Stock_Market_Functions.xla'!RCHGetElementNumber("aapl",6266) and
> gives me the error #NAME?
>
> Please help!.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
7c.: Re: Old spreadsheets dont work after re instalation

Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802

Thu May 3, 2012 2:48 pm (PDT)

Sounds like you installed the add-in in a different directory than you had
last time. You need to move the add-in or update your xls files to refer to
the new location.

See the links area topic 0.2
http://finance.groups.yahoo.com/group/smf_addin/links

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of steven_rourk
Sent: Thursday, May 03, 2012 5:36 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Old spreadsheets dont work after re instalation

I recently had a problem with my laptop, and they had to change my hardrive
, so when I got my laptop back I had to install again the SMF addin. I have
Windows 7 and Excell 2007.

I know its installed correctly, because if a create a new spreadsheet and
put the formula =RCHGetElementNumber("aapl",6266) it gives me 116371

However when I open my old spreadsheets all the formulas in the cells apears
something like this ='C:\Program Files\SMF
Add-In\RCH_Stock_Market_Functions.xla'!RCHGetElementNumber("aapl",6266) and
gives me the error #NAME?

Please help!.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
7d.: Re: Old spreadsheets dont work after re instalation

Posted by: "wschuplak@comcast.net" wschuplak@comcast.net shoenj

Thu May 3, 2012 2:48 pm (PDT)

I too had the same exact issue..it was frustrating..
Sent on the Sprint® Now Network from my BlackBerry®

-----Original Message-----
From: "steven_rourk" <steven_rourk@hotmail.com>
Sender: smf_addin@yahoogroups.com
Date: Thu, 03 May 2012 21:36:07
To: <smf_addin@yahoogroups.com>
Reply-To: smf_addin@yahoogroups.com
Subject: [smf_addin] Old spreadsheets dont work after re instalation

I recently had a problem with my laptop, and they had to change my hardrive , so when I got my laptop back I had to install again the SMF addin. I have Windows 7 and Excell 2007.

I know its installed correctly, because if a create a new spreadsheet and put the formula =RCHGetElementNumber("aapl",6266) it gives me 116371

However when I open my old spreadsheets all the formulas in the cells apears something like this ='C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetElementNumber("aapl",6266) and gives me the error #NAME?

Please help!.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
7e.: Re: Old spreadsheets dont work after re instalation

Posted by: "steven_rourk" steven_rourk@hotmail.com steven_rourk

Thu May 3, 2012 3:39 pm (PDT)

Thanks Mike, it did the job.....Unfortunately I have 500 spreadsheets!... I´ll have to do it one by one....Oh well.

--- In smf_addin@yahoogroups.com, "Mike McQuaid" <mikemcq802@...> wrote:
>
> Sounds like you installed the add-in in a different directory than you had
> last time. You need to move the add-in or update your xls files to refer to
> the new location.
>
> See the links area topic 0.2
> http://finance.groups.yahoo.com/group/smf_addin/links
>
> _____
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
> Of steven_rourk
> Sent: Thursday, May 03, 2012 5:36 PM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Old spreadsheets dont work after re instalation
>
>
>
>
> I recently had a problem with my laptop, and they had to change my hardrive
> , so when I got my laptop back I had to install again the SMF addin. I have
> Windows 7 and Excell 2007.
>
> I know its installed correctly, because if a create a new spreadsheet and
> put the formula =RCHGetElementNumber("aapl",6266) it gives me 116371
>
> However when I open my old spreadsheets all the formulas in the cells apears
> something like this ='C:\Program Files\SMF
> Add-In\RCH_Stock_Market_Functions.xla'!RCHGetElementNumber("aapl",6266) and
> gives me the error #NAME?
>
> Please help!.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

Create New Topic | Visit Your Group on the Web

Messages | Files | Photos | Polls

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

Kamis, 03 Mei 2012

Messages In This Digest (25 Messages)

Messages

Posted by: "tenenbaum88" kenneth.dooley@gmail.com tenenbaum88

Thu May 3, 2012 5:18 am (PDT)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Thu May 3, 2012 5:39 am (PDT)

Posted by: "tenenbaum88" kenneth.dooley@gmail.com tenenbaum88

Thu May 3, 2012 6:57 am (PDT)

Posted by: "bob_cutillo" bob.cutillo@yahoo.com bob_cutillo

Thu May 3, 2012 6:16 am (PDT)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Thu May 3, 2012 7:02 am (PDT)

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com kermitpra

Thu May 3, 2012 6:29 am (PDT)

Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802

Thu May 3, 2012 6:44 am (PDT)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Thu May 3, 2012 7:10 am (PDT)

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com kermitpra

Thu May 3, 2012 9:12 am (PDT)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Thu May 3, 2012 9:43 am (PDT)

Posted by: "thomas91112" thomas91112@yahoo.com thomas91112

Thu May 3, 2012 8:52 am (PDT)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Thu May 3, 2012 9:46 am (PDT)

Posted by: "Patrick Van Beesen" patrick.van.beesen@perso.be patrickvb

Thu May 3, 2012 8:58 am (PDT)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Thu May 3, 2012 9:39 am (PDT)

Posted by: "Pete A" optionzz@gmail.com option2z

Thu May 3, 2012 2:41 pm (PDT)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Thu May 3, 2012 2:48 pm (PDT)

Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802

Thu May 3, 2012 2:50 pm (PDT)

Posted by: "Pete A" optionzz@gmail.com option2z

Thu May 3, 2012 3:27 pm (PDT)

Posted by: "dstange1978" danielcs@floripa.com.br dstange1978

Thu May 3, 2012 11:29 am (PDT)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Thu May 3, 2012 12:58 pm (PDT)

Posted by: "steven_rourk" steven_rourk@hotmail.com steven_rourk

Thu May 3, 2012 2:36 pm (PDT)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Thu May 3, 2012 2:47 pm (PDT)

Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802

Thu May 3, 2012 2:48 pm (PDT)

Posted by: "wschuplak@comcast.net" wschuplak@comcast.net shoenj

Thu May 3, 2012 2:48 pm (PDT)

Posted by: "steven_rourk" steven_rourk@hotmail.com steven_rourk

Thu May 3, 2012 3:39 pm (PDT)

Tidak ada komentar:

Posting Komentar

Followers

Blog Archive

About Me