Kamis, 24 Mei 2012

[smf_addin] Digest Number 2224

Messages In This Digest (25 Messages)

1a.
Re: ADVFN Financial Statements From: mdediegop
1b.
Re: ADVFN Financial Statements From: Randy Harmelink
1c.
Re: ADVFN Financial Statements From: mdediegop
1d.
Re: ADVFN Financial Statements From: rebalance85
1e.
Re: ADVFN Financial Statements From: Randy Harmelink
1f.
Re: ADVFN Financial Statements From: rebalance85
1g.
Re: ADVFN Financial Statements From: Randy Harmelink
1h.
Re: ADVFN Financial Statements From: rebalance85
1i.
Re: ADVFN Financial Statements From: Clark F. Grain
1j.
Re: ADVFN Financial Statements From: rebalance85
1k.
Re: ADVFN Financial Statements From: rebalance85
2a.
Last Price From: truemavsfan
2b.
Re: Last Price From: Randy Harmelink
2c.
Re: Last Price From: Jason Strauss
2d.
Re: Last Price From: truemavsfan
2e.
Re: Last Price From: Randy Harmelink
2f.
Re: Last Price From: truemavsfan
3a.
download issue From: ddbohrer
3b.
Re: download issue From: Randy Harmelink
3c.
Re: download issue From: ddbohrer
3d.
Re: download issue From: Randy Harmelink
4a.
Re: RCHGetElementNumber Errors From: sando2067
4b.
Re: RCHGetElementNumber Errors From: Randy Harmelink
5a.
Re: Rchgetelement errors From: bobc94595
5b.
Re: Rchgetelement errors From: Randy Harmelink

Messages

1a.

Re: ADVFN Financial Statements

Posted by: "mdediegop" mdediego@telefonica.net   mdediegop

Thu May 24, 2012 2:24 am (PDT)



Hello Randy,

First of all, thanks a lot for this wonderful tool you've created. It has saved me hours of work, and helped me to make more informed decisions.

On this same topic, I was having problems with the AdvFN links too, after digging in the forums found out about the fix with the .txt prefix file. For me it works perfect for all my AdvFN links. The only minor issue that I have is that now my link to the last price (=RCHGetElementNumber(Ticker,25)) returns error. It is a very very minor thing, but if there is any workaround please let me know.

P.D.: I think the txt file is a very good fix for the AdvFN problem for us international users. Much easier and faster than having to edit code...

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> (2) won't work. The code is not correct. Besides, you just said you can't
> save changes to the VBA code.
>
> As I see it you have two options:
>
> 1. Uninstall the add-in and move it to a new location that isn't
> protected, so you don't get the read only error. But you'll get location
> errors you need to fix if you do that (see item in "Links" area of the
> group).
>
> 2. Install the beta version of the add-in and use the file fix we talked
> about on the other thread, creating the file with notepad and just having
> the two characters in it. Then you don't need to edit the VBA.
>
> On Wed, May 23, 2012 at 8:52 PM, rebalance85 <rebalance85@...> wrote:
>
> > I couldn't save the file after replacement, tell me the file is read noly.
> > I try to save in the same name, but re-open it, still www. Here is the two
> > line:
> > 1.Const kAdvFNPrefix = "www" ' URL prefix to use for
> > AdvFN
> > The new one:Const kAdvFNPrefix = "cn" ' URL prefix to
> > use for AdvFN
> >
> > 2.sURL = "http://" & kAdvFNPrefix & ".advfn.com/p.php?pid=financials" &
> > "&symbol=" & sTicker & sLabel1
> > The new one:sURL = "http://" & cn & ".advfn.com/p.php?pid=financials" &
> > "&symbol=" & sTicker & sLabel1
> >
> > The data is still error.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (25)
1b.

Re: ADVFN Financial Statements

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

Thu May 24, 2012 2:55 am (PDT)



Hmmm. Just tried it here and it's working. Most people have complained that
it returns the wrong value, but it's MSN that is posting the wrong value.

You do have the new MSN element definitions, right?

http://finance.groups.yahoo.com/group/smf_addin/message/18529

The question I'm currently pondering is whether to obsolete element 25, or
fix it and expand to additional fields they now have on the print report.

One issue with it the current way is that it's a very inefficient way to
get current prices, off a print report that needs to be generated.

On Thu, May 24, 2012 at 1:47 AM, mdediegop <mdediego@telefonica.net> wrote:

>
> On this same topic, I was having problems with the AdvFN links too, after
> digging in the forums found out about the fix with the .txt prefix file.
> For me it works perfect for all my AdvFN links. The only minor issue that I
> have is that now my link to the last price
> (=RCHGetElementNumber(Ticker,25)) returns error. It is a very very minor
> thing, but if there is any workaround please let me know.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (25)
1c.

Re: ADVFN Financial Statements

Posted by: "mdediegop" mdediego@telefonica.net   mdediegop

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



Ok, must be some other problem on my end, don't worry about it. I haven't used the sheets in quite some time and when I came back nothing was working. I updated things and now I have almost everything working again but I haven't had time to dig into everything. If I have some time I'll dig deeper into my element 25 issue.

Thanks a lot

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Hmmm. Just tried it here and it's working. Most people have complained that
> it returns the wrong value, but it's MSN that is posting the wrong value.
>
> You do have the new MSN element definitions, right?
>
> http://finance.groups.yahoo.com/group/smf_addin/message/18529
>
> The question I'm currently pondering is whether to obsolete element 25, or
> fix it and expand to additional fields they now have on the print report.
>
> One issue with it the current way is that it's a very inefficient way to
> get current prices, off a print report that needs to be generated.
>
> On Thu, May 24, 2012 at 1:47 AM, mdediegop <mdediego@...> wrote:
>
> >
> > On this same topic, I was having problems with the AdvFN links too, after
> > digging in the forums found out about the fix with the .txt prefix file.
> > For me it works perfect for all my AdvFN links. The only minor issue that I
> > have is that now my link to the last price
> > (=RCHGetElementNumber(Ticker,25)) returns error. It is a very very minor
> > thing, but if there is any workaround please let me know.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (25)
1d.

Re: ADVFN Financial Statements

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

Thu May 24, 2012 7:46 am (PDT)



Many thanks Randy, the beta version works well, I use excel 2003. I will try 2007 later.
Another is the ticker, when I try IBM, then all the cells are error. I check other ticker,works well. If you have time, please check it.

Thank you very much!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> (2) won't work. The code is not correct. Besides, you just said you can't
> save changes to the VBA code.
>
> As I see it you have two options:
>
> 1. Uninstall the add-in and move it to a new location that isn't
> protected, so you don't get the read only error. But you'll get location
> errors you need to fix if you do that (see item in "Links" area of the
> group).
>
> 2. Install the beta version of the add-in and use the file fix we talked
> about on the other thread, creating the file with notepad and just having
> the two characters in it. Then you don't need to edit the VBA.
>
> On Wed, May 23, 2012 at 8:52 PM, rebalance85 <rebalance85@...> wrote:
>
> > I couldn't save the file after replacement, tell me the file is read noly.
> > I try to save in the same name, but re-open it, still www. Here is the two
> > line:
> > 1.Const kAdvFNPrefix = "www" ' URL prefix to use for
> > AdvFN
> > The new one:Const kAdvFNPrefix = "cn" ' URL prefix to
> > use for AdvFN
> >
> > 2.sURL = "http://" & kAdvFNPrefix & ".advfn.com/p.php?pid=financials" &
> > "&symbol=" & sTicker & sLabel1
> > The new one:sURL = "http://" & cn & ".advfn.com/p.php?pid=financials" &
> > "&symbol=" & sTicker & sLabel1
> >
> > The data is still error.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (25)
1e.

Re: ADVFN Financial Statements

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

Thu May 24, 2012 9:16 am (PDT)



Does the cn domain handle IBM differently? It works fine here.

On Thu, May 24, 2012 at 7:46 AM, rebalance85 <rebalance85@yahoo.com> wrote:

> Many thanks Randy, the beta version works well, I use excel 2003. I will
> try 2007 later.
> Another is the ticker, when I try IBM, then all the cells are error. I
> check other ticker,works well. If you have time, please check it.
>
> Thank you very much!
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (25)
1f.

Re: ADVFN Financial Statements

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

Thu May 24, 2012 6:00 pm (PDT)



http://cn.advfn.com/p.php?pid=financials&btn=annual_reports&mode=&symbol=NYSE%3AIBM

Now works well in Excel 2007, but IBM is still error. I check the URL, it seems that there is no difference.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Does the cn domain handle IBM differently? It works fine here.
>
> On Thu, May 24, 2012 at 7:46 AM, rebalance85 <rebalance85@...> wrote:
>
> > Many thanks Randy, the beta version works well, I use excel 2003. I will
> > try 2007 later.
> > Another is the ticker, when I try IBM, then all the cells are error. I
> > check other ticker,works well. If you have time, please check it.
> >
> > Thank you very much!
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (25)
1g.

Re: ADVFN Financial Statements

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

Thu May 24, 2012 6:03 pm (PDT)



If you JUST use "IBM" as the ticker symbol, your domain assumes it is the
one on the London Stock Exchange, which has no web pages for quarterly and
annual financial statements data. So, yes, you would get "Error" for
everything.

On Thu, May 24, 2012 at 6:00 PM, rebalance85 <rebalance85@yahoo.com> wrote:

>
> http://cn.advfn.com/p.php?pid=financials&btn=annual_reports&mode=&symbol=NYSE%3AIBM
>
> Now works well in Excel 2007, but IBM is still error. I check the URL, it
> seems that there is no difference.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (25)
1h.

Re: ADVFN Financial Statements

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

Thu May 24, 2012 6:23 pm (PDT)



Yes. I check three tickers:
IBM: NYSE/LSE; ANV: AMEX/TSE; CYAN: NASDAQ/LSE.

So, if it's possible help me to update the template, correct the ticker as: NYSE:IBM,AMEX:ANV,NASDAQ:CYAN......

And I think it works for international stock......

Thanks again!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> If you JUST use "IBM" as the ticker symbol, your domain assumes it is the
> one on the London Stock Exchange, which has no web pages for quarterly and
> annual financial statements data. So, yes, you would get "Error" for
> everything.
>
> On Thu, May 24, 2012 at 6:00 PM, rebalance85 <rebalance85@...> wrote:
>
> >
> > http://cn.advfn.com/p.php?pid=financials&btn=annual_reports&mode=&symbol=NYSE%3AIBM
> >
> > Now works well in Excel 2007, but IBM is still error. I check the URL, it
> > seems that there is no difference.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (25)
1i.

Re: ADVFN Financial Statements

Posted by: "Clark F. Grain" cgrain@rcn.com   cgrain76

Thu May 24, 2012 7:15 pm (PDT)



Hello all,

I am not sure about what you are trying to accomplish. I think you are interested in downloading financial data, for specific companies, in order to purchase shares of the company, If this is true I have developed a rather simple way of getting the data and analyzing it using "web queries". If you are interested the spreadsheets can be downloaded from the link shown below. The files to be downloaded are "SA_6.0.4"(Excel 2007-2010), and "SA_6.0.4(2000) for Excel 97-2003.

C. Grain
https://www.myiclub.com/club/folders/public.aspx?club=3442
----- Original Message -----
From: Randy Harmelink
To: smf_addin@yahoogroups.com
Sent: Thursday, May 24, 2012 9:03 PM
Subject: Re: [smf_addin] Re: ADVFN Financial Statements

If you JUST use "IBM" as the ticker symbol, your domain assumes it is the one on the London Stock Exchange, which has no web pages for quarterly and annual financial statements data. So, yes, you would get "Error" for everything.

On Thu, May 24, 2012 at 6:00 PM, rebalance85 <rebalance85@yahoo.com> wrote:

http://cn.advfn.com/p.php?pid=financials&btn=annual_reports&mode=&symbol=NYSE%3AIBM

Now works well in Excel 2007, but IBM is still error. I check the URL, it seems that there is no difference.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (25)
1j.

Re: ADVFN Financial Statements

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

Thu May 24, 2012 8:01 pm (PDT)



Thank you very much for your kindess.
We want to have 10 years financial statments, the goal is the same, find, analysis, buy and sell.
I want to put some tab into your file, if it's possible, I will sent the file to your mailbox.
Thanks again!

--- In smf_addin@yahoogroups.com, "Clark F. Grain" <cgrain@...> wrote:
>
> Hello all,
>
> I am not sure about what you are trying to accomplish. I think you are interested in downloading financial data, for specific companies, in order to purchase shares of the company, If this is true I have developed a rather simple way of getting the data and analyzing it using "web queries". If you are interested the spreadsheets can be downloaded from the link shown below. The files to be downloaded are "SA_6.0.4"(Excel 2007-2010), and "SA_6.0.4(2000) for Excel 97-2003.
>
> C. Grain
> https://www.myiclub.com/club/folders/public.aspx?club=3442
> ----- Original Message -----
> From: Randy Harmelink
> To: smf_addin@yahoogroups.com
> Sent: Thursday, May 24, 2012 9:03 PM
> Subject: Re: [smf_addin] Re: ADVFN Financial Statements
>
>
>
> If you JUST use "IBM" as the ticker symbol, your domain assumes it is the one on the London Stock Exchange, which has no web pages for quarterly and annual financial statements data. So, yes, you would get "Error" for everything.
>
>
>
> On Thu, May 24, 2012 at 6:00 PM, rebalance85 <rebalance85@...> wrote:
>
> http://cn.advfn.com/p.php?pid=financials&btn=annual_reports&mode=&symbol=NYSE%3AIBM
>
> Now works well in Excel 2007, but IBM is still error. I check the URL, it seems that there is no difference.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (25)
1k.

Re: ADVFN Financial Statements

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

Thu May 24, 2012 11:35 pm (PDT)



What should I do? How to change the ticker as: NYSE:IBM?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> If you JUST use "IBM" as the ticker symbol, your domain assumes it is the
> one on the London Stock Exchange, which has no web pages for quarterly and
> annual financial statements data. So, yes, you would get "Error" for
> everything.
>
> On Thu, May 24, 2012 at 6:00 PM, rebalance85 <rebalance85@...> wrote:
>
> >
> > http://cn.advfn.com/p.php?pid=financials&btn=annual_reports&mode=&symbol=NYSE%3AIBM
> >
> > Now works well in Excel 2007, but IBM is still error. I check the URL, it
> > seems that there is no difference.
> >
>

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

Last Price

Posted by: "truemavsfan" brad.valentine@hotmail.com   truemavsfan

Thu May 24, 2012 8:40 am (PDT)



It appears that the MSN #25 of Last Price is returning the previous close and not the last price.

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

Re: Last Price

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

Thu May 24, 2012 9:17 am (PDT)



That's because that is what MSN is populating the field with...

On Thu, May 24, 2012 at 8:39 AM, truemavsfan <brad.valentine@hotmail.com>wrote:

> It appears that the MSN #25 of Last Price is returning the previous close
> and not the last price.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2c.

Re: Last Price

Posted by: "Jason Strauss" xxjaysonxx@aol.com   g3m1n1980

Thu May 24, 2012 10:08 am (PDT)



I have a gethtmltable setup as a back for yahoo that I will send when I get home

Sent from my iPhone

On May 24, 2012, at 12:17 PM, Randy Harmelink <rharmelink@gmail.com> wrote:

> That's because that is what MSN is populating the field with...
>
>
> On Thu, May 24, 2012 at 8:39 AM, truemavsfan <brad.valentine@hotmail.com> wrote:
> It appears that the MSN #25 of Last Price is returning the previous close and not the last price.
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2d.

Re: Last Price

Posted by: "truemavsfan" brad.valentine@hotmail.com   truemavsfan

Thu May 24, 2012 11:19 am (PDT)



Is there a way to link it to the current price?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> That's because that is what MSN is populating the field with...
>
> On Thu, May 24, 2012 at 8:39 AM, truemavsfan <brad.valentine@...>wrote:
>
> > It appears that the MSN #25 of Last Price is returning the previous close
> > and not the last price.
> >
>

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

Re: Last Price

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

Thu May 24, 2012 12:24 pm (PDT)



I'd rather people use RCHGetYahooQuotes()...

I should never have added something as volatile as Last Price to
RCHGetElementNumber() -- it's not intended for constant updating.

I've come very close to obsoleting element #25 a number of times.

On Thu, May 24, 2012 at 11:19 AM, truemavsfan <brad.valentine@hotmail.com>wrote:

> Is there a way to link it to the current price?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2f.

Re: Last Price

Posted by: "truemavsfan" brad.valentine@hotmail.com   truemavsfan

Thu May 24, 2012 12:36 pm (PDT)



Understood. Thanks for your help.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I'd rather people use RCHGetYahooQuotes()...
>
> I should never have added something as volatile as Last Price to
> RCHGetElementNumber() -- it's not intended for constant updating.
>
> I've come very close to obsoleting element #25 a number of times.
>
> On Thu, May 24, 2012 at 11:19 AM, truemavsfan <brad.valentine@...>wrote:
>
> > Is there a way to link it to the current price?
> >
>

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

download issue

Posted by: "ddbohrer" ddbohrer@gmail.com   ddbohrer

Thu May 24, 2012 1:54 pm (PDT)



I try to download the add-in to the recommended location. It seems to do it but when I go to the smf add-in folder nothing is there. Not sure what is going on. Have you seen this problem?

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

Re: download issue

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

Thu May 24, 2012 1:57 pm (PDT)



Sounds like a problem in your downloading process. For FireFox, it usually
ends up in the default "Download" folder.

You can download the ZIP archive anywhere you want. You just need to
extract the contents into the folder you plan to use for the add-in and
supplementary files.

On Thu, May 24, 2012 at 1:24 PM, ddbohrer <ddbohrer@gmail.com> wrote:

> I try to download the add-in to the recommended location. It seems to do
> it but when I go to the smf add-in folder nothing is there. Not sure what
> is going on. Have you seen this problem?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3c.

Re: download issue

Posted by: "ddbohrer" ddbohrer@gmail.com   ddbohrer

Thu May 24, 2012 4:33 pm (PDT)



So for the add-in to work it does not have to reside in the c:\programs file\smf add-in\ folder

--- In smf_addin@yahoogroups.com, "ddbohrer" <ddbohrer@...> wrote:
>
> I try to download the add-in to the recommended location. It seems to do it but when I go to the smf add-in folder nothing is there. Not sure what is going on. Have you seen this problem?
>

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

Re: download issue

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

Thu May 24, 2012 5:39 pm (PDT)



Correct. You can locate the add-in almost any where.

HOWEVER, if you open up a workbook that was saved with the add-in in a
different location, you'll end up with unresolved links that you'll need to
manually fix. See the "Location Errors" item in the "Links" area of the
group.

I actually have mine in the "C:\SMF Add-In" folder, as I had issues
updating the add-in file in Vista when it was in the Program Files folder.

On Thu, May 24, 2012 at 4:33 PM, ddbohrer <ddbohrer@gmail.com> wrote:

> So for the add-in to work it does not have to reside in the c:\programs
> file\smf add-in\ folder
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4a.

Re: RCHGetElementNumber Errors

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

Thu May 24, 2012 5:43 pm (PDT)




I've been following the changes and the May 10 file did seem to work for awhile. The fix seems to be broken again ... thanks MSN.
i.e. entry #25, "Last Price" is actually returns the previous day's closing price so even after the closing bell we are a day behind.

MSN's formats seems to be a moving target.
On http://investing.money.msn.com/investments/stock-price? ..etc.
(note 'stock-price' not 'stock-report' as in smf-elements-1.txt #25) they have changed the label to "Previous Close" and do not even have a "Last Price" listed.

===================================================

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> See: http://finance.groups.yahoo.com/group/smf_addin/message/18529
>
> On Wed, May 23, 2012 at 6:43 PM, curt.brandt@... <
> curt_brandt@...> wrote:
>
> > I'm getting errors for MSN data where I never did before as well.
> >
>

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

Re: RCHGetElementNumber Errors

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

Thu May 24, 2012 5:56 pm (PDT)



"Last Price" is not retrieved from the "stock-price" page, but from the
"stock-report" page:

http://investing.money.msn.com/investments/stock-report?symbol=MMM&QD=1&OP=1&Y1=1&CR=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

And, it DOES have a "Last Price" field shown. But, yes, MSN is posting the
previous day's close there.

On Thu, May 24, 2012 at 5:43 PM, sando2067 <sando2067@yahoo.com> wrote:

>
> I've been following the changes and the May 10 file did seem to work for
> awhile. The fix seems to be broken again ... thanks MSN.
> i.e. entry #25, "Last Price" is actually returns the previous day's
> closing price so even after the closing bell we are a day behind.
>
> MSN's formats seems to be a moving target.
> On http://investing.money.msn.com/investments/stock-price? ..etc.
> (note 'stock-price' not 'stock-report' as in smf-elements-1.txt #25) they
> have changed the label to "Previous Close" and do not even have a "Last
> Price" listed.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
5a.

Re: Rchgetelement errors

Posted by: "bobc94595" conlonrc@comcast.net   bobc94595

Thu May 24, 2012 10:06 pm (PDT)



Randy, I have extracted the files within Works In Progress created on April 7,2012, "RCH_Stock_Market_Functions-2.1.2012.04.07.zip" to the following location within my "C" drive location: C\Program Files (x86)\SMF Add-In. So far, so good, but when I open a spreadsheet, I still can't get MSN data.
You have a revised "smf-elements-1.txt" in Works In Progress dated May 10, 2012 which contains updates to MSN data element definitions. I assume that this revision should replace "smf-elements-1.txt" dated April 7, 2012. As I noted earlier, I opened and copied the May 10th version, and tried to paste it as a replacement of the April 7th version which appears within my C\Program Files (x86)\SMF Add-In, but to no avail. How do I get this latest May 10th revision into my SMF Add-In file to replace the current April 7 version? How do I "download the new file and use it as a replacement for the file in the add-in folder." I am running Win7 and Excel 2010.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You should exit EXCEL, download the new file and use it as a replacement
> for the file in the add-in folder. I don't know what you're doing cut and
> paste on, but I doubt it would replace a file that already exists.
>
> On Tue, May 22, 2012 at 5:39 PM, bobc94595 <conlonrc@...> wrote:
>
> > You also have a revised "smf-elements-1.txt" in your entry dated May 10,
> > 2012. I assume that this revision is of a date later than Jan 27, and could
> > be dated May 10, although I can't tell. How do I get this latest revision
> > into my SMF Add-In file to replace the current Jan 10 version? I have tried
> > cut and paste, but get "access denied."
> > I am running Win7 and Excel 2010
> >
>

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

Re: Rchgetelement errors

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

Thu May 24, 2012 10:37 pm (PDT)



I know nothing about Win7 or EXCEL 2010. On Vista, I would just tell
FireFox to download the file, and then drag and drop it into the folder
from where it was downloaded. I would get a warning that I'm replacing an
existing file, which I would tell it go ahead and do.

By the way, putting it into the (x86) folder is going to mean you probably
won't match the configuration of anyone that uploads files. So you'll need
to be editing unresolved links if you use other people's workbooks. See the
"Location Errors" item in the "Links" area of the group for info on that.

On Thu, May 24, 2012 at 10:06 PM, bobc94595 <conlonrc@comcast.net> wrote:

> Randy, I have extracted the files within Works In Progress created on
> April 7,2012, "RCH_Stock_Market_Functions-2.1.2012.04.07.zip" to the
> following location within my "C" drive location: C\Program Files (x86)\SMF
> Add-In. So far, so good, but when I open a spreadsheet, I still can't get
> MSN data.
> You have a revised "smf-elements-1.txt" in Works In Progress dated May 10,
> 2012 which contains updates to MSN data element definitions. I assume that
> this revision should replace "smf-elements-1.txt" dated April 7, 2012. As I
> noted earlier, I opened and copied the May 10th version, and tried to paste
> it as a replacement of the April 7th version which appears within my
> C\Program Files (x86)\SMF Add-In, but to no avail. How do I get this latest
> May 10th revision into my SMF Add-In file to replace the current April 7
> version? How do I "download the new file and use it as a replacement for
> the file in the add-in folder." I am running Win7 and Excel 2010.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
Recent Activity
Visit Your Group
New business?

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! News

Odd News

You won't believe

it, but it's true

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
Diposting oleh EXCEL FEED LEARNING di 23.35

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)