12 New Messages
Digest #2296
| |
Messages
Mon Jul 30, 2012 6:11 am (PDT) . Posted by:
"rr76012" rr76012
Hi Randy,
I updated to the newer smf-elements-1.txt file, and re-booted, I am now working.
Thank You.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Yes, you have the old MSN element definitions, so it's the
> smf-elements-1.txt file that you need:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/18529
>
> Best practice:
>
> 1. Exit EXCEL
> 2. Download the new version of the element definition file
> 3. Replace the older version of this file in your add-in's file folder
> with the newer downloaded version
> 4. Restart EXCEL
>
> On Sun, Jul 29, 2012 at 1:05 PM, NicholasDavid <nicholasdavid@...>wrote:
>
> >
> > Oh!
> > Here's what I get for these formulas:
> > Stock Market Functions add-in, Version 2.1.2012.04.07 (C:\Program
> > Files\SMF Add-In; 1) MSN;Last Price;
> > http://moneycentral.msn.com/investor/research/sreport.asp?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=~~~~~;1;STOCKACTIVITY;LAST PRICE; ; ;0;0;0;0
> > Error
> > I've been trying to fix this problem for some time.
> > In Works in progress, I see two files that might help.
> > one: RCH_Stock_Market_Functions 2.1.2012.07.12.zip
> >
> > and two: Smf-elements-1.txt
> >
> > Which of these file will make =RCHGetElementNumber(T,27) reveal the 3mth
> > price change.
> >
> > Please give me the detail of how I procedurally go about updating. I
> > thought I was smart but
> > I need help. Thanks, David
> >
>
I updated to the newer smf-elements-
Thank You.
--- In smf_addin@yahoogrou
>
> Yes, you have the old MSN element definitions, so it's the
> smf-elements-
>
> http://finance.
>
> Best practice:
>
> 1. Exit EXCEL
> 2. Download the new version of the element definition file
> 3. Replace the older version of this file in your add-in's file folder
> with the newer downloaded version
> 4. Restart EXCEL
>
> On Sun, Jul 29, 2012 at 1:05 PM, NicholasDavid <nicholasdavid@
>
> >
> > Oh!
> > Here's what I get for these formulas:
> > Stock Market Functions add-in, Version 2.1.2012.04.
> > Files\SMF Add-In; 1) MSN;Last Price;
> > http://moneycentral
> > Error
> > I've been trying to fix this problem for some time.
> > In Works in progress, I see two files that might help.
> > one: RCH_Stock_Market_
> >
> > and two: Smf-elements-
> >
> > Which of these file will make =RCHGetElementNumbe
> > price change.
> >
> > Please give me the detail of how I procedurally go about updating. I
> > thought I was smart but
> > I need help. Thanks, David
> >
>
Mon Jul 30, 2012 7:13 am (PDT) . Posted by:
"NicholasDavid" davidnicholas738
Randy,
I downloaded the updated Element text file and I still can't use some of the codes.
I have attached a simple worksheet that is trying to use =RCHGetElementNumber(symbol,27)
I have also attached the element text file I'm using.
Would you please take a look at this to see if you can see why I'm not having any success.
Thanks, David
----- Original Message -----
From: "Randy Harmelink" <rharmelink@gmail.com >
To: "smf addin" <smf_addin@yahoogroups.com >
Sent: Sunday, July 29, 2012 1:38:52 PM
Subject: Re: [smf_addin] =RCHGetElementNumber()
Element #27 is working here. What ticker symbol did you use? Do you have the MSN element definition updates from the "Works in Progress" folder?
Documentation of the Yahoo codes is in the "Documentation" folder in the files area of the group. Everything I am aware of is there -- I don't know of any documentation by Yahoo.
FinViz could be another source -- see the two entries in the "Links" area of the group for possible ways to extract data for multiple tickers.
On Sun, Jul 29, 2012 at 9:54 AM, ufdn16 < ufdn16@yahoo.com > wrote:
I'm getting an error in the cell that I place =RCHGetElementNumber(Symbol,27) which is supposed to return price change over 3 months.
Is there a code to get this info by using =GetYahooQuotes()
And, is there a site that has all the codes for using =GetYahooQuotes()
I downloaded the updated Element text file and I still can't use some of the codes.
I have attached a simple worksheet that is trying to use =RCHGetElementNumbe
I have also attached the element text file I'm using.
Would you please take a look at this to see if you can see why I'm not having any success.
Thanks, David
----- Original Message -----
From: "Randy Harmelink" <rharmelink@gmail.
To: "smf addin" <smf_addin@yahoogrou
Sent: Sunday, July 29, 2012 1:38:52 PM
Subject: Re: [smf_addin] =RCHGetElementNumbe
Element #27 is working here. What ticker symbol did you use? Do you have the MSN element definition updates from the "Works in Progress" folder?
Documentation of the Yahoo codes is in the "Documentation" folder in the files area of the group. Everything I am aware of is there -- I don't know of any documentation by Yahoo.
FinViz could be another source -- see the two entries in the "Links" area of the group for possible ways to extract data for multiple tickers.
On Sun, Jul 29, 2012 at 9:54 AM, ufdn16 < ufdn16@yahoo.
I'm getting an error in the cell that I place =RCHGetElementNumbe
Is there a code to get this info by using =GetYahooQuotes(
And, is there a site that has all the codes for using =GetYahooQuotes(
Attachments with this message:
2 of 2 File(s)
Mon Jul 30, 2012 8:31 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
My opening your file doesn't help anything, because it would use my version
of the add-in and related element definitions. And, as such, the workbook
worked fine for me. Except for SPX, which isn't a valid ticker symbol for
MSN.
Exit and restart EXCEL, and tell me what you get with these formulas in a
new workbook:
=RCHGetElementNumber("Version")
=RCHGetElementNumber("MMM",27)
=smfGetAParms(27)
On Mon, Jul 30, 2012 at 7:12 AM, NicholasDavid <nicholasdavid@comcast.net >wrote:
>
> I downloaded the updated Element text file and I still can't use some of
> the codes.
> I have attached a simple worksheet that is trying to use
> =RCHGetElementNumber(symbol,27)
> I have also attached the element text file I'm using.
>
> Would you please take a look at this to see if you can see why I'm not
> having any success.
>
of the add-in and related element definitions. And, as such, the workbook
worked fine for me. Except for SPX, which isn't a valid ticker symbol for
MSN.
Exit and restart EXCEL, and tell me what you get with these formulas in a
new workbook:
=RCHGetElementNumbe
=RCHGetElementNumbe
=smfGetAParms(
On Mon, Jul 30, 2012 at 7:12 AM, NicholasDavid <nicholasdavid@
>
> I downloaded the updated Element text file and I still can't use some of
> the codes.
> I have attached a simple worksheet that is trying to use
> =RCHGetElementNumbe
> I have also attached the element text file I'm using.
>
> Would you please take a look at this to see if you can see why I'm not
> having any success.
>
Mon Jul 30, 2012 9:26 am (PDT) . Posted by:
"NicholasDavid" davidnicholas738
Randy,
I get the following:
=RCHGetElementNumber("Version")
Stock Market Functions add-in, Version 2.1.2012.04.07 (C:\Program Files\SMF Add-In; 1)
=RCHGetElementNumber("MMM",27)
Error
=smfGetAParms(27)
MSN;3 Month % Price Change;http://moneycentral.msn.com/investor/research/sreport.asp?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=~~~~~;1;STOCK PRICE HISTORY;LAST 3 MONTHS; ; ;0;0;0;0
----- Original Message -----
From: "Randy Harmelink" <rharmelink@gmail.com >
To: "smf addin" <smf_addin@yahoogroups.com >
Sent: Monday, July 30, 2012 10:31:42 AM
Subject: Re: [smf_addin] =RCHGetElementNumber()
My opening your file doesn't help anything, because it would use my version of the add-in and related element definitions. And, as such, the workbook worked fine for me. Except for SPX, which isn't a valid ticker symbol for MSN.
Exit and restart EXCEL, and tell me what you get with these formulas in a new workbook:
=RCHGetElementNumber("Version")
=RCHGetElementNumber("MMM",27)
=smfGetAParms(27)
On Mon, Jul 30, 2012 at 7:12 AM, NicholasDavid < nicholasdavid@comcast.net > wrote:
I downloaded the updated Element text file and I still can't use some of the codes.
I have attached a simple worksheet that is trying to use =RCHGetElementNumber(symbol,27)
I have also attached the element text file I'm using.
Would you please take a look at this to see if you can see why I'm not having any success.
I get the following:
=RCHGetElementNumbe
Stock Market Functions add-in, Version 2.1.2012.04.
=RCHGetElementNumbe
Error
=smfGetAParms(
MSN;3 Month % Price Change;http://moneycentral
----- Original Message -----
From: "Randy Harmelink" <rharmelink@gmail.
To: "smf addin" <smf_addin@yahoogrou
Sent: Monday, July 30, 2012 10:31:42 AM
Subject: Re: [smf_addin] =RCHGetElementNumbe
My opening your file doesn't help anything, because it would use my version of the add-in and related element definitions. And, as such, the workbook worked fine for me. Except for SPX, which isn't a valid ticker symbol for MSN.
Exit and restart EXCEL, and tell me what you get with these formulas in a new workbook:
=RCHGetElementNumbe
=RCHGetElementNumbe
=smfGetAParms(
On Mon, Jul 30, 2012 at 7:12 AM, NicholasDavid < nicholasdavid@
I downloaded the updated Element text file and I still can't use some of the codes.
I have attached a simple worksheet that is trying to use =RCHGetElementNumbe
I have also attached the element text file I'm using.
Would you please take a look at this to see if you can see why I'm not having any success.
Mon Jul 30, 2012 9:29 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You still have the old element definition. Did you put the replacement file
in the correct folder -- C:\Program Files\SMF Add-In?
On Mon, Jul 30, 2012 at 9:26 AM, NicholasDavid <nicholasdavid@comcast.net >
wrote:
> I get the following:
>
> =RCHGetElementNumber("Version")
>
> Stock Market Functions add-in, Version 2.1.2012.04.07 (C:\Program
Files\SMF Add-In; 1)
>
> =RCHGetElementNumber("MMM",27)
>
> Error
>
> =smfGetAParms(27)
>
> MSN;3 Month % Price Change;
http://moneycentral.msn.com/investor/research/sreport.asp?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=~~~~~;1;STOCKPRICE
HISTORY;LAST 3 MONTHS; ; ;0;0;0;0
in the correct folder -- C:\Program Files\SMF Add-In?
On Mon, Jul 30, 2012 at 9:26 AM, NicholasDavid <nicholasdavid@
wrote:
> I get the following:
>
> =RCHGetElementNumbe
>
> Stock Market Functions add-in, Version 2.1.2012.04.
Files\SMF Add-In; 1)
>
> =RCHGetElementNumbe
>
> Error
>
> =smfGetAParms(
>
> MSN;3 Month % Price Change;
http://moneycentral
HISTORY;LAST 3 MONTHS; ; ;0;0;0;0
Mon Jul 30, 2012 12:57 pm (PDT) . Posted by:
"NicholasDavid" davidnicholas738
Randy,
All's well. My problem was that I had two locations on my computer for SMF Add-In.
One under C:\programs\smf add-in and one under c:\documents\smf add-in.
When I downloaded the new file, it went into c:\documents\smf add-in.
Thanks for your patience. Everything works now. David
----- Original Message -----
From: "Randy Harmelink" <rharmelink@gmail.com >
To: "smf addin" <smf_addin@yahoogroups.com >
Sent: Monday, July 30, 2012 11:29:00 AM
Subject: Re: [smf_addin] =RCHGetElementNumber()
You still have the old element definition. Did you put the replacement file in the correct folder -- C:\Program Files\SMF Add-In?
On Mon, Jul 30, 2012 at 9:26 AM, NicholasDavid < nicholasdavid@comcast.net > wrote:
> I get the following:
>
> =RCHGetElementNumber("Version")
>
> Stock Market Functions add-in, Version 2.1.2012.04.07 (C:\Program Files\SMF Add-In; 1)
>
> =RCHGetElementNumber("MMM",27)
>
> Error
>
> =smfGetAParms(27)
>
> MSN;3 Month % Price Change; http://moneycentral.msn.com/investor/research/sreport.asp?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=~~~~~;1;STOCK PRICE HISTORY;LAST 3 MONTHS; ; ;0;0;0;0
All's well. My problem was that I had two locations on my computer for SMF Add-In.
One under C:\programs\
When I downloaded the new file, it went into c:\documents\
Thanks for your patience. Everything works now. David
----- Original Message -----
From: "Randy Harmelink" <rharmelink@gmail.
To: "smf addin" <smf_addin@yahoogrou
Sent: Monday, July 30, 2012 11:29:00 AM
Subject: Re: [smf_addin] =RCHGetElementNumbe
You still have the old element definition. Did you put the replacement file in the correct folder -- C:\Program Files\SMF Add-In?
On Mon, Jul 30, 2012 at 9:26 AM, NicholasDavid < nicholasdavid@
> I get the following:
>
> =RCHGetElementNumbe
>
> Stock Market Functions add-in, Version 2.1.2012.04.
>
> =RCHGetElementNumbe
>
> Error
>
> =smfGetAParms(
>
> MSN;3 Month % Price Change; http://moneycentral
Mon Jul 30, 2012 4:52 pm (PDT) . Posted by:
"rb_luther" rb_luther
Is there a way to write a macro to retrieve financial statement data from the advfn website and then depending on the rows specified paste that data into excel. (Basically running the macro in background and then pasting the data into excel without using a formula in each cell to retrieve the lines.) I'm looking to retrieve ADVFN data more efficiently (decrease processing time) than using the getADVFN formula in numerous cells.
Is the processing time long due to the formula in each cell retrieving one by one, or is it due to having to open numerous web pages to retrieve the data for different time frames and different tickers?
Lastly, there is a macro that I have used in the past to retrieve data from the finviz website and it is much faster processing time than using the formulas in the cell with the smfaddin macros. Is this due to the finviz website being able to export csv files and then retrieve the data from the csv in the background as opposed to retrieving data from an html table? If so, is there a way to convert the html table on advfn to a csv file to run more efficiently?
Thanks for the help.
Is the processing time long due to the formula in each cell retrieving one by one, or is it due to having to open numerous web pages to retrieve the data for different time frames and different tickers?
Lastly, there is a macro that I have used in the past to retrieve data from the finviz website and it is much faster processing time than using the formulas in the cell with the smfaddin macros. Is this due to the finviz website being able to export csv files and then retrieve the data from the csv in the background as opposed to retrieving data from an html table? If so, is there a way to convert the html table on advfn to a csv file to run more efficiently?
Thanks for the help.
Mon Jul 30, 2012 5:03 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
There are two reasons AdvFN takes longer than most other sites:
1. They only have 5 periods of data on a page. So if you want 20 annual
periods and 40 quarterly periods, you need to access 12 web pages to get
the data for a single ticker symbol.
2. Each web page has a lot of data on it, so if you extract a lot of
data from the web page, they do take longer to search for and extract than
a smaller web page.
You may be able to speed it up by doing RCHGetHTMLTable() on each of the 12
web pages, if you're getting all of the data.
I get FinViz data quickly, but I do use their CSV file (see LINKS area of
the group for more info). Depending on how you're getting the data, and how
much data you're getting, it can be a lot slower getting things
individually.
On Mon, Jul 30, 2012 at 4:52 PM, rb_luther <rb_luther@yahoo.com > wrote:
> Is there a way to write a macro to retrieve financial statement data from
> the advfn website and then depending on the rows specified paste that data
> into excel. (Basically running the macro in background and then pasting the
> data into excel without using a formula in each cell to retrieve the
> lines.) I'm looking to retrieve ADVFN data more efficiently (decrease
> processing time) than using the getADVFN formula in numerous cells.
>
> Is the processing time long due to the formula in each cell retrieving one
> by one, or is it due to having to open numerous web pages to retrieve the
> data for different time frames and different tickers?
>
> Lastly, there is a macro that I have used in the past to retrieve data
> from the finviz website and it is much faster processing time than using
> the formulas in the cell with the smfaddin macros. Is this due to the
> finviz website being able to export csv files and then retrieve the data
> from the csv in the background as opposed to retrieving data from an html
> table? If so, is there a way to convert the html table on advfn to a csv
> file to run more efficiently?
>
> Thanks for the help.
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
1. They only have 5 periods of data on a page. So if you want 20 annual
periods and 40 quarterly periods, you need to access 12 web pages to get
the data for a single ticker symbol.
2. Each web page has a lot of data on it, so if you extract a lot of
data from the web page, they do take longer to search for and extract than
a smaller web page.
You may be able to speed it up by doing RCHGetHTMLTable(
web pages, if you're getting all of the data.
I get FinViz data quickly, but I do use their CSV file (see LINKS area of
the group for more info). Depending on how you're getting the data, and how
much data you're getting, it can be a lot slower getting things
individually.
On Mon, Jul 30, 2012 at 4:52 PM, rb_luther <rb_luther@yahoo.
> Is there a way to write a macro to retrieve financial statement data from
> the advfn website and then depending on the rows specified paste that data
> into excel. (Basically running the macro in background and then pasting the
> data into excel without using a formula in each cell to retrieve the
> lines.) I'm looking to retrieve ADVFN data more efficiently (decrease
> processing time) than using the getADVFN formula in numerous cells.
>
> Is the processing time long due to the formula in each cell retrieving one
> by one, or is it due to having to open numerous web pages to retrieve the
> data for different time frames and different tickers?
>
> Lastly, there is a macro that I have used in the past to retrieve data
> from the finviz website and it is much faster processing time than using
> the formulas in the cell with the smfaddin macros. Is this due to the
> finviz website being able to export csv files and then retrieve the data
> from the csv in the background as opposed to retrieving data from an html
> table? If so, is there a way to convert the html table on advfn to a csv
> file to run more efficiently?
>
> Thanks for the help.
>
>
>
> ------------
>
> Yahoo! Groups Links
>
>
>
>
Mon Jul 30, 2012 11:52 pm (PDT) . Posted by:
"Fred Lin" FredSLin
Randy,
I have no problem using smfPricesByDates but RCHGetYahooQuotes seems to behave
differently. For example: =RCHGetYahooQuotes("IBM") returns literal IBM.
I am running win7 64b and Excel2007.
FredL
I have no problem using smfPricesByDates but RCHGetYahooQuotes seems to behave
differently. For example: =RCHGetYahooQuotes(
I am running win7 64b and Excel2007.
FredL
Mon Jul 30, 2012 11:53 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
See: http://finance.groups.yahoo.com/group/smf_addin/message/19447
On Mon, Jul 30, 2012 at 11:33 PM, Fred Lin <fredslin@yahoo.com > wrote:
>
> I have no problem using smfPricesByDates but RCHGetYahooQuotes seems to
> behave
> differently. For example: =RCHGetYahooQuotes("IBM") returns literal IBM.
>
> I am running win7 64b and Excel2007.
>
>
On Mon, Jul 30, 2012 at 11:33 PM, Fred Lin <fredslin@yahoo.
>
> I have no problem using smfPricesByDates but RCHGetYahooQuotes seems to
> behave
> differently. For example: =RCHGetYahooQuotes(
>
> I am running win7 64b and Excel2007.
>
>
Tue Jul 31, 2012 4:28 am (PDT) . Posted by:
"ttelip" ttelip
Hi
I'm getting errors in some elements. It seems those related with Yahoo work propery but not those ones related with MSN or others
=RCHGEtElementNumber("Source";941)=YahooKS
=RCHGEtElementNumber("Element";941)=MarketCap
=RCHGEtElementNumber("IBM";941)=224220000
But
=RCHGEtElementNumber("IBM";1541)=Error
=rchgetelementnumber(Ticker; 163)=Error
The SMF-Addin is in C:\SMF Add-in
I'm running Windows 7, spanish, excel 2007 and I've changed regional settings from X.XXX,00 (Spanish) to X,XXX.00(English)
My version is
Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\SMF Add-in; 34)
I've searched by the forum but similar problems were caused by not having the smfxxx.txt files in the same directory or having two smf_XXXXX.xla in diferent places. This is not my case.
Any suggestion?
Best Regards and many thanks for your help
I'm getting errors in some elements. It seems those related with Yahoo work propery but not those ones related with MSN or others
=RCHGEtElementNumbe
=RCHGEtElementNumbe
=RCHGEtElementNumbe
But
=RCHGEtElementNumbe
=rchgetelementnumbe
The SMF-Addin is in C:\SMF Add-in
I'm running Windows 7, spanish, excel 2007 and I've changed regional settings from X.XXX,00 (Spanish) to X,XXX.00(English)
My version is
Stock Market Functions add-in, Version 2.1.2012.02.
I've searched by the forum but similar problems were caused by not having the smfxxx.txt files in the same directory or having two smf_XXXXX.xla in diferent places. This is not my case.
Any suggestion?
Best Regards and many thanks for your help
Tue Jul 31, 2012 4:31 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
See: http://finance.groups.yahoo.com/group/smf_addin/message/19499
On Tue, Jul 31, 2012 at 4:27 AM, ttelip <felipeporcel@gmail.com > wrote:
> Hi
> I'm getting errors in some elements. It seems those related with Yahoo
> work propery but not those ones related with MSN or others
>
> =RCHGEtElementNumber("Source";941)=YahooKS
> =RCHGEtElementNumber("Element";941)=MarketCap
> =RCHGEtElementNumber("IBM";941)=224220000
>
> But
>
> =RCHGEtElementNumber("IBM";1541)=Error
> =rchgetelementnumber(Ticker; 163)=Error
>
> The SMF-Addin is in C:\SMF Add-in
> I'm running Windows 7, spanish, excel 2007 and I've changed regional
> settings from X.XXX,00 (Spanish) to X,XXX.00(English)
>
> My version is
> Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\SMF Add-in; 34)
>
> I've searched by the forum but similar problems were caused by not having
> the smfxxx.txt files in the same directory or having two smf_XXXXX.xla in
> diferent places. This is not my case.
> Any suggestion?
> Best Regards and many thanks for your help
>
On Tue, Jul 31, 2012 at 4:27 AM, ttelip <felipeporcel@
> Hi
> I'm getting errors in some elements. It seems those related with Yahoo
> work propery but not those ones related with MSN or others
>
> =RCHGEtElementNumbe
> =RCHGEtElementNumbe
> =RCHGEtElementNumbe
>
> But
>
> =RCHGEtElementNumbe
> =rchgetelementnumbe
>
> The SMF-Addin is in C:\SMF Add-in
> I'm running Windows 7, spanish, excel 2007 and I've changed regional
> settings from X.XXX,00 (Spanish) to X,XXX.00(English)
>
> My version is
> Stock Market Functions add-in, Version 2.1.2012.02.
>
> I've searched by the forum but similar problems were caused by not having
> the smfxxx.txt files in the same directory or having two smf_XXXXX.xla in
> diferent places. This is not my case.
> Any suggestion?
> Best Regards and many thanks for your help
>
Tidak ada komentar:
Posting Komentar