12 New Messages
Digest #2772
5a
smfFixLinks macro does not appear to work if file saved from another by "Kermit W. Prather" kermitpra
5b
Re: smfFixLinks macro does not appear to work if file saved from ano by "Randy Harmelink" rharmelink
Messages
Fri Sep 13, 2013 1:36 am (PDT) . Posted by:
sri.yanto
so nothing can be do?
thank bro
--- In smf_addin@yahoogrou
wrote:
Looks like that's what Yahoo is populating the file with...
On Thu, Sep 12, 2013 at 7:42 PM, sri yanto <sri.yanto@
<mailto:sri.
it's return zero for "w"
and Return N/A for "k"
i'am using RCHGetYahooQuotes(
content, which tildas replacing ticker like MAIN, BMRI
Fri Sep 13, 2013 5:21 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Nothing that I can do. You can use the "Send Feedback" link on the quotes
page of the stock to let Yahoo know that their CSV file is not providing
correct data:
http://download.finance.yahoo.com/d/quotes.csv?s=BMRI.JK&f=swk&e=.csv
Otherwise, it may just be a temporary thing. I don't know if they provide
CSV data for ".JK" stocks.
You could just use the RCHGetTableCell() function to get the data yourself.
Since you're not array-entering the formula, it may actually be faster to
do that if you're getting multiple fields with RCHGetYahooQuotes(). For
example:
=RCHGetTableCell("http://finance.yahoo.com/q?s=BMRI.JK",1,"52wk Range:")
On Fri, Sep 13, 2013 at 1:36 AM, <sri.yanto@yahoo.com> wrote:
> so nothing can be do?
>
>
page of the stock to let Yahoo know that their CSV file is not providing
correct data:
http://download.
Otherwise, it may just be a temporary thing. I don't know if they provide
CSV data for ".JK" stocks.
You could just use the RCHGetTableCell(
Since you're not array-entering the formula, it may actually be faster to
do that if you're getting multiple fields with RCHGetYahooQuotes(
example:
=RCHGetTableCell(
On Fri, Sep 13, 2013 at 1:36 AM, <sri.yanto@yahoo.
> so nothing can be do?
>
>
Fri Sep 13, 2013 5:50 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I can't say if that's normal or not. I usually only get one or two option
chains. But it would depend on which functions you're using and which data
source you're using. For example, I use OptionsXPress even though it's
slow, because it has much more reliable data.
It does sound high though.
On Thu, Sep 12, 2013 at 11:11 AM, john.kalkanis <john.kalkanis@yahoo.com>wrote:
> Hi. I am using smf via vmware (windows xp + excel 2011) for mac. It
> works. But it is very slow. A spreadsheer which retrieve the option chain
> for 60 stocks takes 20-30' to load. Is this normal? if not, any suggestion
> on how to speed it up?
>
chains. But it would depend on which functions you're using and which data
source you're using. For example, I use OptionsXPress even though it's
slow, because it has much more reliable data.
It does sound high though.
On Thu, Sep 12, 2013 at 11:11 AM, john.kalkanis <john.kalkanis@
> Hi. I am using smf via vmware (windows xp + excel 2011) for mac. It
> works. But it is very slow. A spreadsheer which retrieve the option chain
> for 60 stocks takes 20-30' to load. Is this normal? if not, any suggestion
> on how to speed it up?
>
Fri Sep 13, 2013 6:07 am (PDT) . Posted by:
bushpilote
yweinstock your great work on the new ADVFN financial template is
not all for not. The reason for the errors is that in both the
annual and quartely data the url's are incorrect.
To pull in the ANNUAL data for microsoft replace in the
RCHGetTableCell formula
"http://www.advfn.
&"/financials?
l=1&cffull=1&effull
"http://www.advfn.
-financials?
and for the QUARTELY data replace
"http://www.advfn.
s?btn=annual_
&effull=1&vrfull=
with
"http://www.advfn.
-financials?
.....leave the remaining content of the RCHGetTableCell formula
as is in both cases.
Replacing "microsoft-
financials. For IBM's financials you replace NASDAQ with NYSE and
"microsoft-
In ADVFN's beta version access to a company'
requires both the company name (the name they have in their
database) and ticker along with the exchange ticker symbol. It
remains to be seen if the need to use the company'
the new norm once they go live with their redesigned website.
Hope this helps.
--- In smf_addin@yahoogrou
Yeah.... Looks like I spoke too soon.
The spreadsheet returns errors now as the site reverted to the
old structure. Perhaps we caught a glimpse of an unintended
early release. Guess it's back to the waiting game..
--- In smf_addin@yahoogrou
Exactly. They don't seem to have their act together at all.
Makes me have second thoughts about the quality of the data!
On Wed, Sep 11, 2013 at 10:36 AM, <petekoch@
<https://mail.
> wrote:
It appears that AdvFN is going to be day-to-day for a while.
Consider any changes you make to be temporary.
Fri Sep 13, 2013 7:23 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
I was waiting for Randy's response but decided to put my results in the
thread.
I, also, have an error see table
Formula
IBM
=RCHGetElementNumber("Element",13862)
Company Name
=RCHGetElementNumber(D1,13862)
Error
=RCHGetElementNumber("IBM";,13862)
Error
=RCHGetElementNumber(D1,13863)
International Business Machines
I thought I'd expand it to see if any other element failed.
Element Number
Element Name
Element content
13860
Market Stats -- OTC BB -- Unchanged Volume
8,351,705 (22%)
13861
Market Stats -- OTC BB -- Total Volume
38157057
13862
Company Name
Error
13863
Company Name
International Business Machines
13864
Sector Number
8
13865
Sector Name
Technology
13866
Industry Number
824
13867
Industry Name
Information Technology Services
13868
Industry Symbol
^YHOh888
13869
Market Capitalization
208930000
13870
PEG Ratio
1.26
13871
Current Year Estimate
16.89
13872
EPS Last Year
15.92
13873
Zacks Recommendation
Hold
13874
This Quarter -- # of Estimates
15
13875
Next Quarter -- # of Estimates
14
13876
This Year -- # of Estimates
11
13877
Next Year -- # of Estimates
16
13878
Earning per Share (TTM)
15.92
13879
Sales
104507
13880
Net Income
15915
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Isaac Wiedmann
Sent: Thursday, September 12, 2013 7:52 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: smfUpdateDownloadTable macro - company name not
working
Hi Randy,
I just joined this group and started using your plugin. As an engineer
myself, I am impressed with the effort you have put in to make all this
work, so thank you.
I replied to this thread because I am experiencing the same issue that Bill
is. I receive an "Error" for both elements 13862 and 13863 when I enter the
equations "=RCHGetElementNumber("IBM",13862)" and
"=RCHGetElementNumber("IBM",13863)" respectively. The statements
"=RCHGetElementNumber("Element",13862)" and
"=RCHGetElementNumber("Element",13863)" both work, and several other
elements I am using work.
I also ran your suggested test listed in one of the replies and received the
same result "3M Co" as Bill.
Just like Bill I am using Microsoft Excel 2010 Professional on a Windows 7
machine.
Thank you
Isaac
--- In <mailto:smf_addin@yahoogroups.com> smf_addin@yahoogroups.com, Randy
Harmelink < <mailto:rharmelink@...> rharmelink@...> wrote:
>
> It leaves me confused, since the first of those is the what is saved
> for the element definition.
>
> Usually that means an issue with the VBA EVAL() function, but that
> occurs with older versions of EXCEL, which you say doesn't apply.
>
>
> On Sat, Aug 31, 2013 at 2:47 AM, < <mailto:bmissell@...> bmissell@...>
wrote:
>
> > Back to the original issue "13862" not working on my machine - My
> > machine returns "3M CO" for both lines - does that tell you anything
> > for diagnostics?
> >
>
------------------------------------
Yahoo! Groups Links
(Yahoo! ID required)
<mailto:smf_addin-fullfeatured@yahoogroups.com>
smf_addin-fullfeatured@yahoogroups.com
thread.
I, also, have an error see table
Formula
IBM
=RCHGetElementNumbe
Company Name
=RCHGetElementNumbe
Error
=RCHGetElementNumbe
Error
=RCHGetElementNumbe
International Business Machines
I thought I'd expand it to see if any other element failed.
Element Number
Element Name
Element content
13860
Market Stats -- OTC BB -- Unchanged Volume
8,351,705 (22%)
13861
Market Stats -- OTC BB -- Total Volume
38157057
13862
Company Name
Error
13863
Company Name
International Business Machines
13864
Sector Number
8
13865
Sector Name
Technology
13866
Industry Number
824
13867
Industry Name
Information Technology Services
13868
Industry Symbol
^YHOh888
13869
Market Capitalization
208930000
13870
PEG Ratio
1.26
13871
Current Year Estimate
16.89
13872
EPS Last Year
15.92
13873
Zacks Recommendation
Hold
13874
This Quarter -- # of Estimates
15
13875
Next Quarter -- # of Estimates
14
13876
This Year -- # of Estimates
11
13877
Next Year -- # of Estimates
16
13878
Earning per Share (TTM)
15.92
13879
Sales
104507
13880
Net Income
15915
-----Original Message-----
From: smf_addin@yahoogrou
Of Isaac Wiedmann
Sent: Thursday, September 12, 2013 7:52 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] Re: smfUpdateDownloadTa
working
Hi Randy,
I just joined this group and started using your plugin. As an engineer
myself, I am impressed with the effort you have put in to make all this
work, so thank you.
I replied to this thread because I am experiencing the same issue that Bill
is. I receive an "Error" for both elements 13862 and 13863 when I enter the
equations "=RCHGetElemen
"=RCHGetElemen
"=RCHGetElemen
"=RCHGetElemen
elements I am using work.
I also ran your suggested test listed in one of the replies and received the
same result "3M Co" as Bill.
Just like Bill I am using Microsoft Excel 2010 Professional on a Windows 7
machine.
Thank you
Isaac
--- In <mailto:smf_addin@yahoogrou
Harmelink < <mailto:rharmeli
>
> It leaves me confused, since the first of those is the what is saved
> for the element definition.
>
> Usually that means an issue with the VBA EVAL() function, but that
> occurs with older versions of EXCEL, which you say doesn't apply.
>
>
> On Sat, Aug 31, 2013 at 2:47 AM, < <mailto:bmissell
wrote:
>
> > Back to the original issue "13862" not working on my machine - My
> > machine returns "3M CO" for both lines - does that tell you anything
> > for diagnostics?
> >
>
------------
Yahoo! Groups Links
(Yahoo! ID required)
<mailto:smf_addin-fullfeatu
smf_addin-fullfeatu
Fri Sep 13, 2013 7:44 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Aha! I just looked at my change log. I did change the 13862 definition on
6/19. That may explain why it works for me and not for you guys. You may
just need a new copy of the smf-elements-1.txt file, with the new
definition.
PS: I never replied to the message you're replying to because I never
received it. Lately, it seems some messages come a day or two late. Not
often, but I've seen it more than once in the last month.
On Fri, Sep 13, 2013 at 7:23 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:
> I was waiting for Randy's response but decided to put my results in the
> thread.****
>
> I, also, have an error see table
>
> ****
>
> Formula****
>
> IBM****
>
> =RCHGetElementNumber("Element",13862)****
>
> Company Name****
>
> =RCHGetElementNumber(D1,13862)****
>
> Error****
>
> =RCHGetElementNumber("IBM";,13862)****
>
> Error****
>
> =RCHGetElementNumber(D1,13863)****
>
> International Business Machines****
>
>
>
6/19. That may explain why it works for me and not for you guys. You may
just need a new copy of the smf-elements-
definition.
PS: I never replied to the message you're replying to because I never
received it. Lately, it seems some messages come a day or two late. Not
often, but I've seen it more than once in the last month.
On Fri, Sep 13, 2013 at 7:23 AM, Kermit W. Prather
<kermitp@tampabay.
> I was waiting for Randy's response but decided to put my results in the
> thread.****
>
> I, also, have an error see table
>
> ****
>
> Formula****
>
> IBM****
>
> =RCHGetElementNumbe
>
> Company Name****
>
> =RCHGetElementNumbe
>
> Error****
>
> =RCHGetElementNumbe
>
> Error****
>
> =RCHGetElementNumbe
>
> International Business Machines****
>
>
>
Fri Sep 13, 2013 9:16 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Randy, there is some strange stuff going on today. Turns out my failure of the 13862 element is due to my long running MSN issue on my Vista 64 bit desktop.
You can probably ignore the rest of this message. Other than the new issue which I'll document in a new posting.
First, I thought I had the latest smf-elements-1.txt file But when I attempted to go online to the SMF-addin group Yahoo I get screen formats I have never seen before.
Is it just me or has Yahoo changed the layouts?
If this is their new format I think it sucks.
I get a list of files folder but I could not figure out how to access the files.
Well, I finally figured out how to open the smf-elements-1.txt file an hour later. I downloaded it and replaced the version I had even though visually they look the same.
Here is the definition I have for element 13862 in smf-elements01.txt file: I have no way of telling if it is the right level since there is no version code in the file and windows show a 7/24/2013 date as the last update in the folder.
Would you consider putting a last change date in the files at some point?
MY previous version
13862;MSN;Company Name;=TRIM(smfGetTagContent("http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~","h1",0,"title="""))
My newly downloaded version
13862;MSN;Company Name;=TRIM(smfGetTagContent("http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~","h1",0,"title="""))
I can't see any difference and I still get the error. But then I remembered that I have on-going problems with MSN elements on My Vista 64 bit system. I have not been able to resolve the MSN issue
So I tried it on my Windows 7 32 bit machine I then discovered I could not get the smfFixLinks macro to convert the links to the new system. I'll post a new message on this issue.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Friday, September 13, 2013 10:45 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: smfUpdateDownloadTable macro - company name not working
Aha! I just looked at my change log. I did change the 13862 definition on 6/19. That may explain why it works for me and not for you guys. You may just need a new copy of the smf-elements-1.txt file, with the new definition.
PS: I never replied to the message you're replying to because I never received it. Lately, it seems some messages come a day or two late. Not often, but I've seen it more than once in the last month.
On Fri, Sep 13, 2013 at 7:23 AM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:
I was waiting for Randy's response but decided to put my results in the thread.
I, also, have an error see table
Formula
IBM
=RCHGetElementNumber("Element",13862)
Company Name
=RCHGetElementNumber(D1,13862)
Error
=RCHGetElementNumber("IBM";,13862)
Error
=RCHGetElementNumber(D1,13863)
International Business Machines
You can probably ignore the rest of this message. Other than the new issue which I'll document in a new posting.
First, I thought I had the latest smf-elements-
Is it just me or has Yahoo changed the layouts?
If this is their new format I think it sucks.
I get a list of files folder but I could not figure out how to access the files.
Well, I finally figured out how to open the smf-elements-
Here is the definition I have for element 13862 in smf-elements01.
Would you consider putting a last change date in the files at some point?
MY previous version
13862;MSN;Company Name;=TRIM(smfGetTa
My newly downloaded version
13862;MSN;Company Name;=TRIM(smfGetTa
I can't see any difference and I still get the error. But then I remembered that I have on-going problems with MSN elements on My Vista 64 bit system. I have not been able to resolve the MSN issue
So I tried it on my Windows 7 32 bit machine I then discovered I could not get the smfFixLinks macro to convert the links to the new system. I'll post a new message on this issue.
From: smf_addin@yahoogrou
Sent: Friday, September 13, 2013 10:45 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Re: smfUpdateDownloadTa
Aha! I just looked at my change log. I did change the 13862 definition on 6/19. That may explain why it works for me and not for you guys. You may just need a new copy of the smf-elements-
PS: I never replied to the message you're replying to because I never received it. Lately, it seems some messages come a day or two late. Not often, but I've seen it more than once in the last month.
On Fri, Sep 13, 2013 at 7:23 AM, Kermit W. Prather <kermitp@tampabay.
I was waiting for Randy's response but decided to put my results in the thread.
I, also, have an error see table
Formula
IBM
=RCHGetElementNumbe
Company Name
=RCHGetElementNumbe
Error
=RCHGetElementNumbe
Error
=RCHGetElementNumbe
International Business Machines
Fri Sep 13, 2013 9:34 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm not real happy with the new Yahoo Groups either. Especially the FILES
area. I don't see any way to get the full description of a file. I'd also
like to get rid of the "cover" at the top that takes up half the page. They
remove it when looking at a conversation, but not when looking at files.
If you have MSN problems, element 13862 is NOT going to work. It is an MSN
element.
The element definition file does have the ability to have comments. When it
loads definitions, it ignores all lines that have an apostrophe in the
first byte of the line. So I could add a last change date as the first
record of a file.
My ability to help on your new system may be limited, since I don't have
that environment here and would have no way to reproduce any issues.
On Fri, Sep 13, 2013 at 9:16 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:
>
> Randy, there is some strange stuff going on today. Turns out my failure
> of the 13862 element is due to my long running MSN issue on my Vista 64 bit
> desktop. ****
>
> You can probably ignore the rest of this message. Other than the new issue
> which I'll document in a new posting. ****
>
> ** **
>
> First, I thought I had the latest smf-elements-1.txt file But when I
> attempted to go online to the SMF-addin group Yahoo I get screen formats
> I have never seen before.****
>
> Is it just me or has Yahoo changed the layouts?****
>
> If this is their new format I think it sucks. ****
>
> I get a list of files folder but I could not figure out how to access the
> files.****
>
> ** **
>
> Well, I finally figured out how to open the smf-elements-1.txt file an
> hour later. I downloaded it and replaced the version I had even though
> visually they look the same. ****
>
> ** **
>
> Here is the definition I have for element 13862 in smf-elements01.txt
> file: I have no way of telling if it is the right level since there is no
> version code in the file and windows show a 7/24/2013 date as the last
> update in the folder. ****
>
> Would you consider putting a last change date in the files at some point?
> ****
>
> ** **
>
> MY previous version****
>
> 13862;MSN;Company Name;=TRIM(smfGetTagContent("
> http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~
> ","h1",0,"title="""))****
>
> ** **
>
> My newly downloaded version****
>
> ** **
>
> 13862;MSN;Company Name;=TRIM(smfGetTagContent("
> http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~
> ","h1",0,"title="""))****
>
> ** **
>
> I can't see any difference and I still get the error. But then I
> remembered that I have on-going problems with MSN elements on My Vista 64
> bit system. I have not been able to resolve the MSN issue ****
>
> ** **
>
> So I tried it on my Windows 7 32 bit machine I then discovered I could not
> get the smfFixLinks macro to convert the links to the new system. I'll
> post a new message on this issue.
>
area. I don't see any way to get the full description of a file. I'd also
like to get rid of the "cover" at the top that takes up half the page. They
remove it when looking at a conversation, but not when looking at files.
If you have MSN problems, element 13862 is NOT going to work. It is an MSN
element.
The element definition file does have the ability to have comments. When it
loads definitions, it ignores all lines that have an apostrophe in the
first byte of the line. So I could add a last change date as the first
record of a file.
My ability to help on your new system may be limited, since I don't have
that environment here and would have no way to reproduce any issues.
On Fri, Sep 13, 2013 at 9:16 AM, Kermit W. Prather
<kermitp@tampabay.
>
> Randy, there is some strange stuff going on today. Turns out my failure
> of the 13862 element is due to my long running MSN issue on my Vista 64 bit
> desktop. ****
>
> You can probably ignore the rest of this message. Other than the new issue
> which I'll document in a new posting. ****
>
> ** **
>
> First, I thought I had the latest smf-elements-
> attempted to go online to the SMF-addin group Yahoo I get screen formats
> I have never seen before.****
>
> Is it just me or has Yahoo changed the layouts?****
>
> If this is their new format I think it sucks. ****
>
> I get a list of files folder but I could not figure out how to access the
> files.****
>
> ** **
>
> Well, I finally figured out how to open the smf-elements-
> hour later. I downloaded it and replaced the version I had even though
> visually they look the same. ****
>
> ** **
>
> Here is the definition I have for element 13862 in smf-elements01.
> file: I have no way of telling if it is the right level since there is no
> version code in the file and windows show a 7/24/2013 date as the last
> update in the folder. ****
>
> Would you consider putting a last change date in the files at some point?
> ****
>
> ** **
>
> MY previous version****
>
> 13862;MSN;Company Name;=TRIM(smfGetTa
> http://investing.
> ","
>
> ** **
>
> My newly downloaded version****
>
> ** **
>
> 13862;MSN;Company Name;=TRIM(smfGetTa
> http://investing.
> ","
>
> ** **
>
> I can't see any difference and I still get the error. But then I
> remembered that I have on-going problems with MSN elements on My Vista 64
> bit system. I have not been able to resolve the MSN issue ****
>
> ** **
>
> So I tried it on my Windows 7 32 bit machine I then discovered I could not
> get the smfFixLinks macro to convert the links to the new system. I'll
> post a new message on this issue.
>
Fri Sep 13, 2013 9:43 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Randy, It took me several attempts to find out why the smfFixLinks macro
would not work sometimes.
I'm not sure there is anything you can do about this issue. Just thought I'd
document it for others.
I keep my master files on one computer and I reference them from other
computers.
Normally, I'll copy the file to another computer to test a new function.
But, sometimes I'll just open it and save it on the new computer and then
work on it.
That's when I had problems changing the links.
Maybe someone can try this if they have multiple computers. Let me know the
results.
Maybe I am doing something wrong. Wouldn't be the first or last time.
I have 5 computers on my local network:
1. I create or save a file that contains smf-addin references in one
computer
2. I, then, open that saved file from another computer in my network
3. I save and close the file on the new computer
4. I open the saved file on the new computer
5. I execute the smfFixLinks macro but nothing gets changed.
I can change the link manually but not with the macro.
If I copy the file from the original saved computer to another computer.
Then open it in the new computer I can run smfFixLinks and it works.
Kermit
would not work sometimes.
I'm not sure there is anything you can do about this issue. Just thought I'd
document it for others.
I keep my master files on one computer and I reference them from other
computers.
Normally, I'll copy the file to another computer to test a new function.
But, sometimes I'll just open it and save it on the new computer and then
work on it.
That's when I had problems changing the links.
Maybe someone can try this if they have multiple computers. Let me know the
results.
Maybe I am doing something wrong. Wouldn't be the first or last time.
I have 5 computers on my local network:
1. I create or save a file that contains smf-addin references in one
computer
2. I, then, open that saved file from another computer in my network
3. I save and close the file on the new computer
4. I open the saved file on the new computer
5. I execute the smfFixLinks macro but nothing gets changed.
I can change the link manually but not with the macro.
If I copy the file from the original saved computer to another computer.
Then open it in the new computer I can run smfFixLinks and it works.
Kermit
Fri Sep 13, 2013 11:38 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
What do the unresolved links look like -- a formula in the cell with the
location attached?
EXCEL may be resolving links differently since things are on the same
network. Hmmm.
On Fri, Sep 13, 2013 at 9:43 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:
>
> Randy, It took me several attempts to find out why the smfFixLinks macro
> would not work sometimes. ****
>
> ** **
>
> I'm not sure there is anything you can do about this issue. Just thought
> I'd document it for others.****
>
> I keep my master files on one computer and I reference them from other
> computers. ****
>
> Normally, I'll copy the file to another computer to test a new function. *
> ***
>
> But, sometimes I'll just open it and save it on the new computer and then
> work on it. ****
>
> That's when I had problems changing the links. ****
>
> ** **
>
> Maybe someone can try this if they have multiple computers. Let me know
> the results.****
>
> Maybe I am doing something wrong. Wouldn't be the first or last time. ****
>
> ** **
>
> I have 5 computers on my local network: ****
>
> **1. **I create or save a file that contains smf-addin references in
> one computer****
>
> **2. **I, then, open that saved file from another computer in my
> network****
>
> **3. **I save and close the file on the new computer****
>
> **4. **I open the saved file on the new computer****
>
> **5. **I execute the smfFixLinks macro but nothing gets changed. ****
>
> ** **
>
> I can change the link manually but not with the macro. ****
>
> ** **
>
> If I copy the file from the original saved computer to another computer. *
> ***
>
> Then open it in the new computer I can run smfFixLinks and it works. ****
>
>
>
location attached?
EXCEL may be resolving links differently since things are on the same
network. Hmmm.
On Fri, Sep 13, 2013 at 9:43 AM, Kermit W. Prather
<kermitp@tampabay.
>
> Randy, It took me several attempts to find out why the smfFixLinks macro
> would not work sometimes. ****
>
> ** **
>
> I'm not sure there is anything you can do about this issue. Just thought
> I'd document it for others.****
>
> I keep my master files on one computer and I reference them from other
> computers. ****
>
> Normally, I'll copy the file to another computer to test a new function. *
> ***
>
> But, sometimes I'll just open it and save it on the new computer and then
> work on it. ****
>
> That's when I had problems changing the links. ****
>
> ** **
>
> Maybe someone can try this if they have multiple computers. Let me know
> the results.****
>
> Maybe I am doing something wrong. Wouldn't be the first or last time. ****
>
> ** **
>
> I have 5 computers on my local network: ****
>
> **1. **I create or save a file that contains smf-addin references in
> one computer****
>
> **2. **I, then, open that saved file from another computer in my
> network****
>
> **3. **I save and close the file on the new computer****
>
> **4. **I open the saved file on the new computer****
>
> **5. **I execute the smfFixLinks macro but nothing gets changed. ****
>
> ** **
>
> I can change the link manually but not with the macro. ****
>
> ** **
>
> If I copy the file from the original saved computer to another computer. *
> ***
>
> Then open it in the new computer I can run smfFixLinks and it works. ****
>
>
>
Fri Sep 13, 2013 11:06 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The full URL I use in FIreFox is:
view-source:
http://download.finance.yahoo.com/d/quotes.csv?s=MMM,IBM&f=sl1&e=.csv
..which gives me:
"MMM",118.25
"IBM",190.34
I don't know of any comprehensive list of all the codes. Yahoo hasn't
documented them that I know of, other than they are used with their
portfolios. But the codes can be a-z, a0-z0, ..., a9-z9. Some contain HTML
code, which is used by the portfolio display.
On Thu, Sep 12, 2013 at 11:21 AM, Jim Ranum <amt2100@gmail.com> wrote:
> That view-source instruction is probably the thing I'd like to see. But
> what would I enter to see all the codes? Maybe there are some unusual ones
> that would be interesting.
>
> I've tried several different ways of typing the view-source in front of
> the URL and none of them work. Can you please give us the specific way to
> type that? Is there a slash or period, etc.?
>
view-source:
http://download.
..which gives me:
"MMM"
"IBM"
I don't know of any comprehensive list of all the codes. Yahoo hasn't
documented them that I know of, other than they are used with their
portfolios. But the codes can be a-z, a0-z0, ..., a9-z9. Some contain HTML
code, which is used by the portfolio display.
On Thu, Sep 12, 2013 at 11:21 AM, Jim Ranum <amt2100@gmail.
> That view-source instruction is probably the thing I'd like to see. But
> what would I enter to see all the codes? Maybe there are some unusual ones
> that would be interesting.
>
> I've tried several different ways of typing the view-source in front of
> the URL and none of them work. Can you please give us the specific way to
> type that? Is there a slash or period, etc.?
>
Fri Sep 13, 2013 7:03 pm (PDT) . Posted by:
"Jim Ranum" amt2100
Thanks Randy.
It was that colon after view-source I had no idea to put in.
Take care,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Friday, September 13, 2013 2:06 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] basic quote
The full URL I use in FIreFox is:
view-source:http://download.finance.yahoo.com/d/quotes.csv?s=MMM,IBM <http://download.finance.yahoo.com/d/quotes.csv?s=MMM,IBM&f=sl1&e=.csv> &f=sl1&e=.csv
..which gives me:
"MMM",118.25
"IBM",190.34
I don't know of any comprehensive list of all the codes. Yahoo hasn't documented them that I know of, other than they are used with their portfolios. But the codes can be a-z, a0-z0, ..., a9-z9. Some contain HTML code, which is used by the portfolio display.
On Thu, Sep 12, 2013 at 11:21 AM, Jim Ranum <amt2100@gmail.com> wrote:
That view-source instruction is probably the thing I'd like to see. But what would I enter to see all the codes? Maybe there are some unusual ones that would be interesting.
I've tried several different ways of typing the view-source in front of the URL and none of them work. Can you please give us the specific way to type that? Is there a slash or period, etc.?
It was that colon after view-source I had no idea to put in.
Take care,
Jim
From: smf_addin@yahoogrou
Sent: Friday, September 13, 2013 2:06 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] basic quote
The full URL I use in FIreFox is:
view-source:http://download.
..which gives me:
"MMM"
"IBM"
I don't know of any comprehensive list of all the codes. Yahoo hasn't documented them that I know of, other than they are used with their portfolios. But the codes can be a-z, a0-z0, ..., a9-z9. Some contain HTML code, which is used by the portfolio display.
On Thu, Sep 12, 2013 at 11:21 AM, Jim Ranum <amt2100@gmail.
That view-source instruction is probably the thing I'd like to see. But what would I enter to see all the codes? Maybe there are some unusual ones that would be interesting.
I've tried several different ways of typing the view-source in front of the URL and none of them work. Can you please give us the specific way to type that? Is there a slash or period, etc.?
Tidak ada komentar:
Posting Komentar