Selasa, 04 Agustus 2015

[smf_addin] Digest Number 3476[1 Attachment]

15 Messages

Digest #3476
2b
Re: Elements Displaying all ZEROS by "Randy Harmelink" rharmelink
2d
Re: Elements Displaying all ZEROS by "Randy Harmelink" rharmelink
3a
Add-In errors by "Jim Ranum" amt2100
3b
Re: Add-In errors by "Randy Harmelink" rharmelink
3c
Re: Add-In errors by "Jim Ranum" amt2100
3d
Re: Add-In errors by "Randy Harmelink" rharmelink
3e
Re: Add-In errors by "Kermit W. Prather" kermitpra
3f
Re: Add-In errors by "Jim Ranum" amt2100
3g
Re: Add-In errors by "Jim Ranum" amt2100
4a
xls file by cgrauballe
4b
Re: xls file by "Randy Harmelink" rharmelink

Messages

Mon Aug 3, 2015 2:38 am (PDT) . Posted by:

marion_stuchlik

Hello,
I cannot display stock data with RCH macro.
The stack data are downloaded from Yahoo, but don't put in the table vData.
I don't know where is the problem.
Could you help me?
Thanks in advance,

P.S. the file is enclosed

Marion


Attachment(s) from
1 of 1 File(s)

Mon Aug 3, 2015 4:28 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'm not exactly sure what you're asking?

Could you be running into a regional issue? The add-in is written for the
U.S. regional setting.

On Mon, Aug 3, 2015 at 2:38 AM, marion_stuchlik@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Hello,
> I cannot display stock data with RCH macro.
> The stack data are downloaded from Yahoo, but don't put in the table vData.
> I don't know where is the problem.
> Could you help me?
> Thanks in advance,
>
>
>

Mon Aug 3, 2015 5:36 am (PDT) . Posted by:

Hello Randy.


Hope all is well with you.


I've been using and enjoying SMF for awhile now (longer than one year, actually).


Suddenly, starting this past Saturday the following elements are displaying all ZEROS: 4673, 4675, 4677, 4679 while 4947 and 4671 are displaying as expected.


Perhaps is it because my Windows7 was upgrade to Windows10? If so, what should I do to fix that?


I've already done ForceRecalculation twice to no avail.


By the way, my Excel is 2010.


Any hints?


Thanks


Armando


Mon Aug 3, 2015 7:14 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's because MorningStar hasn't populated the data items on the web page
they are extracted from, at least for the one I looked at (you didn't give
any example ticker symbols):

http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=SPY

They may be in the midst of month-end updating?

On Mon, Aug 3, 2015 at 5:35 AM, armando@pipeline.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Suddenly, starting this past Saturday the following elements are
> displaying all ZEROS: 4673, 4675, 4677, 4679 while 4947 and 4671 are
> displaying as expected.
>
> Perhaps is it because my Windows7 was upgrade to Windows10? If so, what
> should I do to fix that?
>
> I've already done ForceRecalculation twice to no avail.
>
> By the way, my Excel is 2010.
>
> Any hints?
>
>

Tue Aug 4, 2015 6:29 am (PDT) . Posted by:

Thanks for your quick reply, Randy.
It seems that way. I mean, I hope that is the reason for the
zeros. Hopefully Morningstar will repopulate those elements.
Best regards
Armando

-----Original Message-----
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]"
Sent: Aug 3, 2015 11:14 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Elements Displaying all ZEROS



It's because MorningStar hasn't populated the data items on the
web page they are extracted from, at least for the one I looked
at (you didn't give any example ticker symbols):

http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=\
SPY
<http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol\
=SPY>

They may be in the midst of month-end updating?

On Mon, Aug 3, 2015 at 5:35 AM, armando@pipeline.com
<mailto:armando@pipeline.com> [smf_addin]
<smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> >
wrote:
Suddenly, starting this past Saturday the following elements are
displaying all ZEROS: 4673, 4675, 4677, 4679 while 4947 and 4671
are displaying as expected.


Perhaps is it because my Windows7 was upgrade to Windows10? If
so, what should I do to fix that?



I've already done ForceRecalculation twice to no avail.



By the way, my Excel is 2010.



Any hints?







Tue Aug 4, 2015 8:29 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Looks like they're working today. I get a non-zero number now for:

=RCHGetElementNumber("SPY",4673)

On Tue, Aug 4, 2015 at 6:25 AM, armando@pipeline.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> It seems that way. I mean, I hope that is the reason for the zeros.
> Hopefully Morningstar will repopulate those elements.
>
>

Mon Aug 3, 2015 8:31 am (PDT) . Posted by:

"Jim Ranum" amt2100

Hi Randy,

I'm recently getting these annoying popups whenever I make a new entry in my
gurufocus spreadsheet:

After I re-enter the correct file, the new entry will have #NAME pop up in
all the new cells and they have this inserted in the formula.

='C:\Users\JimR\AppData\Roaming\Microsoft\AddIns\RCH_Stock_Market_Functions.
xla'!RCHGetTableCell("http://www.gurufocus.com/financials/"&A11,1,">P/E(ttm)
")

I do a replace all and get it working again after minor work, but why is it
persisting in doing this, when it didn't used to? Also, every time I open
the spreadsheet now it wants to Update Links, and it didn't used to.

I also get this popup if I try to use the force macro function:

How do I make these things stop? I've tried going in and redirecting the
Add-In to the correct directory several times.

Thanks.

Best regards,

Jim

Mon Aug 3, 2015 8:47 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sounds like you are creating the problem yourself, when you are
"redirecting the Add-In to the correct directory".

The problem is that every time you save a file, it also saves the
hard-coded location of the add-in AT THAT TIME. That means EACH WORKBOOK
could have its own location of the add-in. When you open the workbook, it
looks for the add-in in that hard-coded location. If it's not there, you
get unresolved links.

What you need to do is KEEP the add-in in one location. When you fix the
unresolved links AND save the workbook, *that* workbook will now be able to
be opened without unresolved links.

But if you now move the add-in, that workbook will have a problem. I'm not
happy with the way it works, but that's the way Microsoft has EXCEL doing
it.

The macro error sounds like you no longer have the add-in in that location.
Again, decide on a single location. Delete all other add-in folders.

Whenever I open up a workbook with unresolved links, I just use the
smfFixLinks macro (which I have assigned to a toolbar button).

On Mon, Aug 3, 2015 at 8:31 AM, 'Jim Ranum' amt2100@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> I'm recently getting these annoying popups whenever I make a new entry in
> my gurufocus spreadsheet:
>
>
>
>
>
>
>
> After I re-enter the correct file, the new entry will have #NAME pop up in
> all the new cells and they have this inserted in the formula.
>
>
> ='C:\Users\JimR\AppData\Roaming\Microsoft\AddIns\RCH_Stock_Market_Functions.xla'!RCHGetTableCell("
> http://www.gurufocus.com/financials/"&A11,1,">P/E(ttm)")
>
>
>
> I do a replace all and get it working again after minor work, but why is
> it persisting in doing this, when it didn't used to? Also, every time I
> open the spreadsheet now it wants to Update Links, and it didn't used to.
>
> I also get this popup if I try to use the force macro function:
>
>
>
> How do I make these things stop? I've tried going in and redirecting the
> Add-In to the correct directory several times.
>
>
>
> Thanks.
>
>
>
>
>
> Best regards,
>
> Jim
>
>
>
>

Mon Aug 3, 2015 9:15 am (PDT) . Posted by:

"Jim Ranum" amt2100

Yes, I messed it up when I installed the FRED add-in for Economic data. It has an add-in that goes into the Microsoft standard folder, Users\JimR\AppData\Roaming\Microsoft\AddIns

How can I clean up this mess?

And since Microsoft "wants" the add-in's in that folder, wouldn't it be easier to just not fight it and go with the flow? I know you've discussed this many times, but it sure seems like we are bashing our heads against a brick wall.

Best regards,

Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, August 03, 2015 11:48 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Add-In errors

Sounds like you are creating the problem yourself, when you are "redirecting the Add-In to the correct directory".

The problem is that every time you save a file, it also saves the hard-coded location of the add-in AT THAT TIME. That means EACH WORKBOOK could have its own location of the add-in. When you open the workbook, it looks for the add-in in that hard-coded location. If it's not there, you get unresolved links.

What you need to do is KEEP the add-in in one location. When you fix the unresolved links AND save the workbook, *that* workbook will now be able to be opened without unresolved links.

But if you now move the add-in, that workbook will have a problem. I'm not happy with the way it works, but that's the way Microsoft has EXCEL doing it.

The macro error sounds like you no longer have the add-in in that location. Again, decide on a single location. Delete all other add-in folders.

Whenever I open up a workbook with unresolved links, I just use the smfFixLinks macro (which I have assigned to a toolbar button).

On Mon, Aug 3, 2015 at 8:31 AM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

I'm recently getting these annoying popups whenever I make a new entry in my gurufocus spreadsheet:

After I re-enter the correct file, the new entry will have #NAME pop up in all the new cells and they have this inserted in the formula.

='C:\Users\JimR\AppData\Roaming\Microsoft\AddIns\RCH_Stock_Market_Functions.xla'!RCHGetTableCell("http://www.gurufocus.com/financials/"&A11,1,">P/E(ttm)")

I do a replace all and get it working again after minor work, but why is it persisting in doing this, when it didn't used to? Also, every time I open the spreadsheet now it wants to Update Links, and it didn't used to.

I also get this popup if I try to use the force macro function:

How do I make these things stop? I've tried going in and redirecting the Add-In to the correct directory several times.

Thanks.

Best regards,

Jim

Mon Aug 3, 2015 9:45 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The only way to clean up the mess is to keep the SMF add-in in a single
location. If that's not the proper location for any given workbook, then
fix the workbook. Once saved, you shouldn't need to fix that workbook again.

You can choose any location you want. However, the reason I opt for a fixed
location is that it makes it easier for people to share workbooks. If you
use the "...JimR..." location, no one else will have that location. So
anyone that opens a workbook of yours will need to fix the location.

But even then, it's only a temporary issue for them. Once they've fixed the
location and saved the file, it will be ready to go the next time they open
it. As long as they haven't change the location on their system in between.
:)

By definition, the "Roaming" folder is one that can travel along with the
profile (i.e. "JimR"). It makes it easier for backup purposes if all of the
Application Data is within the user profile. However, for workbook sharing
purposes, the SMF add-in really can't roam by profile, but works best as a
fixed location for all profiles. Even to the point of being in a fixed
location between different machines.

On Mon, Aug 3, 2015 at 9:15 AM, 'Jim Ranum' amt2100@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Yes, I messed it up when I installed the FRED add-in for Economic data. It
> has an add-in that goes into the Microsoft standard folder,
> Users\JimR&#92;AppData&#92;Roaming&#92;Microsoft&#92;AddIns
>
>
>
> How can I clean up this mess?
>
> And since Microsoft "wants" the add-in's in that folder, wouldn't it be
> easier to just not fight it and go with the flow? I know you've discussed
> this many times, but it sure seems like we are bashing our heads against a
> brick wall.
>
>
>

Mon Aug 3, 2015 9:51 am (PDT) . Posted by:

"Kermit W. Prather" kermitpra

Jim, it is not mandatory that you use what Mircosoft wants for folder location.

I put my SMF-ADDIN in a folder on the C: drive named SMFADDIN, it works just find. That is, as long as I remember to change the links to my specific location.

Kermit

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, August 03, 2015 12:15 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Add-In errors


Yes, I messed it up when I installed the FRED add-in for Economic data. It has an add-in that goes into the Microsoft standard folder, Users\JimR\AppData\Roaming\Microsoft\AddIns

How can I clean up this mess?
And since Microsoft "wants" the add-in's in that folder, wouldn't it be easier to just not fight it and go with the flow? I know you've discussed this many times, but it sure seems like we are bashing our heads against a brick wall.

Best regards,
Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, August 03, 2015 11:48 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Add-In errors


Sounds like you are creating the problem yourself, when you are "redirecting the Add-In to the correct directory".
The problem is that every time you save a file, it also saves the hard-coded location of the add-in AT THAT TIME. That means EACH WORKBOOK could have its own location of the add-in. When you open the workbook, it looks for the add-in in that hard-coded location. If it's not there, you get unresolved links.
What you need to do is KEEP the add-in in one location. When you fix the unresolved links AND save the workbook, *that* workbook will now be able to be opened without unresolved links.
But if you now move the add-in, that workbook will have a problem. I'm not happy with the way it works, but that's the way Microsoft has EXCEL doing it.

The macro error sounds like you no longer have the add-in in that location. Again, decide on a single location. Delete all other add-in folders.
Whenever I open up a workbook with unresolved links, I just use the smfFixLinks macro (which I have assigned to a toolbar button).

On Mon, Aug 3, 2015 at 8:31 AM, 'Jim Ranum' amt2100@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

I'm recently getting these annoying popups whenever I make a new entry in my gurufocus spreadsheet:


After I re-enter the correct file, the new entry will have #NAME pop up in all the new cells and they have this inserted in the formula.
='C:\Users\JimR\AppData\Roaming\Microsoft\AddIns\RCH_Stock_Market_Functions.xla'!RCHGetTableCell("http://www.gurufocus.com/financials/"&A11,1,">P/E(ttm)")

I do a replace all and get it working again after minor work, but why is it persisting in doing this, when it didn't used to? Also, every time I open the spreadsheet now it wants to Update Links, and it didn't used to.
I also get this popup if I try to use the force macro function:

How do I make these things stop? I've tried going in and redirecting the Add-In to the correct directory several times.

Thanks.


Best regards,
Jim





Mon Aug 3, 2015 9:57 am (PDT) . Posted by:

"Jim Ranum" amt2100

Will do. Sorry I forgot all the background on this.

Thanks for the reminder, and your patience.

Best regards,

Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, August 03, 2015 12:45 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Add-In errors

The only way to clean up the mess is to keep the SMF add-in in a single location. If that's not the proper location for any given workbook, then fix the workbook. Once saved, you shouldn't need to fix that workbook again.

You can choose any location you want. However, the reason I opt for a fixed location is that it makes it easier for people to share workbooks. If you use the "...JimR..." location, no one else will have that location. So anyone that opens a workbook of yours will need to fix the location.

But even then, it's only a temporary issue for them. Once they've fixed the location and saved the file, it will be ready to go the next time they open it. As long as they haven't change the location on their system in between. :)

By definition, the "Roaming" folder is one that can travel along with the profile (i.e. "JimR"). It makes it easier for backup purposes if all of the Application Data is within the user profile. However, for workbook sharing purposes, the SMF add-in really can't roam by profile, but works best as a fixed location for all profiles. Even to the point of being in a fixed location between different machines.

On Mon, Aug 3, 2015 at 9:15 AM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

Yes, I messed it up when I installed the FRED add-in for Economic data. It has an add-in that goes into the Microsoft standard folder, Users\JimR&#92;AppData&#92;Roaming&#92;Microsoft&#92;AddIns

How can I clean up this mess?

And since Microsoft "wants" the add-in's in that folder, wouldn't it be easier to just not fight it and go with the flow? I know you've discussed this many times, but it sure seems like we are bashing our heads against a brick wall.

Mon Aug 3, 2015 9:58 am (PDT) . Posted by:

"Jim Ranum" amt2100

Thanks.

Best regards,

Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, August 03, 2015 12:51 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Add-In errors

Jim, it is not mandatory that you use what Mircosoft wants for folder location.

I put my SMF-ADDIN in a folder on the C: drive named SMFADDIN, it works just find. That is, as long as I remember to change the links to my specific location.

Kermit

From: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> [mailto:smf_addin@yahoogroups.com]
Sent: Monday, August 03, 2015 12:15 PM
To: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com>
Subject: RE: [smf_addin] Add-In errors

Yes, I messed it up when I installed the FRED add-in for Economic data. It has an add-in that goes into the Microsoft standard folder, Users\JimR\AppData\Roaming\Microsoft\AddIns

How can I clean up this mess?

And since Microsoft "wants" the add-in's in that folder, wouldn't it be easier to just not fight it and go with the flow? I know you've discussed this many times, but it sure seems like we are bashing our heads against a brick wall.

Best regards,

Jim

From: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> [mailto:smf_addin@yahoogroups.com]
Sent: Monday, August 03, 2015 11:48 AM
To: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com>
Subject: Re: [smf_addin] Add-In errors

Sounds like you are creating the problem yourself, when you are "redirecting the Add-In to the correct directory".

The problem is that every time you save a file, it also saves the hard-coded location of the add-in AT THAT TIME. That means EACH WORKBOOK could have its own location of the add-in. When you open the workbook, it looks for the add-in in that hard-coded location. If it's not there, you get unresolved links.

What you need to do is KEEP the add-in in one location. When you fix the unresolved links AND save the workbook, *that* workbook will now be able to be opened without unresolved links.

But if you now move the add-in, that workbook will have a problem. I'm not happy with the way it works, but that's the way Microsoft has EXCEL doing it.

The macro error sounds like you no longer have the add-in in that location. Again, decide on a single location. Delete all other add-in folders.

Whenever I open up a workbook with unresolved links, I just use the smfFixLinks macro (which I have assigned to a toolbar button).

On Mon, Aug 3, 2015 at 8:31 AM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

I'm recently getting these annoying popups whenever I make a new entry in my gurufocus spreadsheet:

After I re-enter the correct file, the new entry will have #NAME pop up in all the new cells and they have this inserted in the formula.

='C:\Users\JimR\AppData\Roaming\Microsoft\AddIns\RCH_Stock_Market_Functions.xla'!RCHGetTableCell("http://www.gurufocus.com/financials/"&A11,1,">P/E(ttm)")

I do a replace all and get it working again after minor work, but why is it persisting in doing this, when it didn't used to? Also, every time I open the spreadsheet now it wants to Update Links, and it didn't used to.

I also get this popup if I try to use the force macro function:

How do I make these things stop? I've tried going in and redirecting the Add-In to the correct directory several times.

Thanks.

Best regards,

Jim

Mon Aug 3, 2015 11:38 pm (PDT) . Posted by:

cgrauballe

Does anyone know if it is possible to extract this excel file: http://www.dvca.dk/uploads/Publikationer/DVCA_Liste%20over%20buyouts%20i%20DK.xls http://www.dvca.dk/uploads/Publikationer/DVCA_Liste%20over%20buyouts%20i%20DK.xls
And then the sheet: "Samlet" and all data


I tried using the following formula:
="http://www.dvca.dk/uploads/Publikationer/[DVCA_Liste%20over%20buyouts%20i%20DK.xls]Samlet!J9
Didnt work :/


thx
/Caspar

Tue Aug 4, 2015 1:53 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You aren't doing it quite right. For one thing, you can't use the HTML
encoded characters of the URL -- each of those "%20" character encodes
needs to be a space instead. And you need single quotes around everything
but the cell address.

This worked for me:

='http://www.dvca.dk/uploads/Publikationer/[DVCA_Liste over buyouts i
DK.xls]Samlet'!J9

On Mon, Aug 3, 2015 at 11:38 PM, cgrauballe@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Does anyone know if it is possible to extract this excel file:
> http://www.dvca.dk/uploads/Publikationer/DVCA_Liste%20over%20buyouts%20i%20DK.xls
>
> And then the sheet: "Samlet" and all data
>
> I tried using the following formula:
>
> ="
> http://www.dvca.dk/uploads/Publikationer/[DVCA_Liste%20over%20buyouts%20i%20DK.xls]Samlet!J9
> <http://www.dvca.dk/uploads/Publikationer/%5BDVCA_Liste%20over%20buyouts%20i%20DK.xls%5DSamlet!J9>
>
> Didnt work :/
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar