7 New Messages
Digest #2851
Messages
Sun Nov 10, 2013 3:36 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Just use the normal EXCEL concatenation operator to create the URL. For
example:
=RCHGetTableCell("http://finance.yahoo.com/q/pr?s="&A2,1,"Sector:")
On Sun, Nov 10, 2013 at 3:50 PM, <zach_beth@comcast.net> wrote:
>
> I am currently using RCHGetTableCell to retrieve sector and industry
> information for a list of stocks. I have to manually enter the stock on
> each line.
>
> For example:
>
> =RCHGetTableCell("http://finance.yahoo.com/q/pr?s=MCHP+Profile
> ",1,"Sector:")
>
> Is there a way to automate this?
>
> For examples, if my stocks are in A2:A11. B1 is the header for SECTOR and
> C1 is the header for INDUSTRY.
>
> Would like to fill B2:C11.
>
example:
=RCHGetTableCell(
On Sun, Nov 10, 2013 at 3:50 PM, <zach_beth@comcast.
>
> I am currently using RCHGetTableCell to retrieve sector and industry
> information for a list of stocks. I have to manually enter the stock on
> each line.
>
> For example:
>
> =RCHGetTableCell(
> ",1,"
>
> Is there a way to automate this?
>
> For examples, if my stocks are in A2:A11. B1 is the header for SECTOR and
> C1 is the header for INDUSTRY.
>
> Would like to fill B2:C11.
>
Sun Nov 10, 2013 5:30 pm (PST) . Posted by:
ztripp2000
Thanks Randy! Works great.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Just use the normal EXCEL concatenation operator to create the URL. For example:
=RCHGetTableCell("http://finance.yahoo.com/q/pr?s= http://finance.yahoo.com/q/pr?s="&A2,1,"Sector:")
On Sun, Nov 10, 2013 at 3:50 PM, <zach_beth@... mailto:zach_beth@...> wrote:
I am currently using RCHGetTableCell to retrieve sector and industry information for a list of stocks. I have to manually enter the stock on each line.
For example:
=RCHGetTableCell("http://finance.yahoo.com/q/pr?s=MCHP+Profile http://finance.yahoo.com/q/pr?s=MCHP+Profile",1,"Sector:")
Is there a way to automate this?
For examples, if my stocks are in A2:A11. B1 is the header for SECTOR and C1 is the header for INDUSTRY.
Would like to fill B2:C11.
---In smf_addin@yahoogrou
Just use the normal EXCEL concatenation operator to create the URL. For example:
=RCHGetTableCell(
On Sun, Nov 10, 2013 at 3:50 PM, <zach_beth@
I am currently using RCHGetTableCell to retrieve sector and industry information for a list of stocks. I have to manually enter the stock on each line.
For example:
=RCHGetTableCell(
Is there a way to automate this?
For examples, if my stocks are in A2:A11. B1 is the header for SECTOR and C1 is the header for INDUSTRY.
Would like to fill B2:C11.
Sun Nov 10, 2013 3:49 pm (PST) . Posted by:
a.sorensen
I have a spreadsheet using ADVFN-Q functions that I have been using for a couple of years now. I haven't opened it in the last month or so but when I open it now it returns "ERROR" for all the functions. I have noticed that most other functions are working but the none of the ADVFN stuff is. I have searched the conversations but can't find anything. Can anyone offer some help?
Thanks
Thanks
Sun Nov 10, 2013 4:37 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
AdvFN changes have been a topic of discussion here for months. See:
http://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/24009
On Sun, Nov 10, 2013 at 4:49 PM, <sorensea@hotmail.com> wrote:
> I have a spreadsheet using ADVFN-Q functions that I have been using for
> a couple of years now. I haven't opened it in the last month or so but
> when I open it now it returns "ERROR" for all the functions. I have
> noticed that most other functions are working but the none of the ADVFN
> stuff is. I have searched the conversations but can't find anything. Can
> anyone offer some help?
>
http://groups.
On Sun, Nov 10, 2013 at 4:49 PM, <sorensea@hotmail.
> I have a spreadsheet using ADVFN-Q functions that I have been using for
> a couple of years now. I haven't opened it in the last month or so but
> when I open it now it returns "ERROR" for all the functions. I have
> noticed that most other functions are working but the none of the ADVFN
> stuff is. I have searched the conversations but can't find anything. Can
> anyone offer some help?
>
Sun Nov 10, 2013 6:22 pm (PST) . Posted by:
a.sorensen
Version 2 worked great! Thank you very much for your help.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
AdvFN changed their website in November, so I had to make changes to account for them. The 2.0k version of the add-in isn't officially released yet, but it is available in the "Works in Progress" folder of the files area. All of the elements were redefined and a new function is available. Documentation for the new function and new AdvFN templates are also available in that folder.
On Sat, Apr 3, 2010 at 1:57 PM, shabzog <shabzog@... mailto:shabzog@...> wrote:
Hello,
I am a recent user of this excellent add-in however I am getting errors with advfn. I need to use adfvn since it is the only provider that has quarterly historical fundamental data for over 15 years.
Thank you in advance.
SHb
---In smf_addin@yahoogrou
AdvFN changed their website in November, so I had to make changes to account for them. The 2.0k version of the add-in isn't officially released yet, but it is available in the "Works in Progress" folder of the files area. All of the elements were redefined and a new function is available. Documentation for the new function and new AdvFN templates are also available in that folder.
On Sat, Apr 3, 2010 at 1:57 PM, shabzog <shabzog@
Hello,
I am a recent user of this excellent add-in however I am getting errors with advfn. I need to use adfvn since it is the only provider that has quarterly historical fundamental data for over 15 years.
Thank you in advance.
SHb
Sun Nov 10, 2013 10:40 pm (PST) . Posted by:
dabutler89
I can't seem to get this file to work properly: "smfGetAdvFNElement-Template-All-Line-Items.xls" It is the template used to dump the ADVFN data.
This is what I have done so far ( I know there has been an issue with ADVFN, my impression is that with the new add-in everything was up and running)
I am running windows 7 (x64), Excel 2013
I updated my add-in to the 10.17
changed the path of the cells to my element-definition file
What else should I be doing? The number of periods cell is coming up with "Error".
Let me know and thank you for this amazing plug-in; It's working with GuruFocus data and the add-in is a life saver.
This is what I have done so far ( I know there has been an issue with ADVFN, my impression is that with the new add-in everything was up and running)
I am running windows 7 (x64), Excel 2013
I updated my add-in to the 10.17
changed the path of the cells to my element-definition file
What else should I be doing? The number of periods cell is coming up with "Error"
Let me know and thank you for this amazing plug-in; It's working with GuruFocus data and the add-in is a life saver.
Mon Nov 11, 2013 12:09 am (PST) . Posted by:
rharmelink
I just uploaded an updated copy of that template. It was retrieving the line items labels using the old AdvFN URL structure. So those URLs needed to be changed.
However, that shouldn't affect the "Number of Periods" cell. If you're getting "Error" there, you'll still have a problem.
When you updated to 2013.10.17, did you exit EXCEL first? Add-ins are loaded at EXCEL start-up, so changing the XLA file while in EXCEL won't update the add-in until EXCEL is restarted.
You shouldn't be changing the paths in the cells, you should be removing them altogether. I usually just run the smfFixLinks macro that is within the add-in.
Be sure you have the Internet Options settings fix, described in an item in the LINKS area of the group.
If you're in another region, where AdvFN redirects you to a different domain prefix, you'll need to add an smf-AdvFN-prefix.txt file in the add-in folder, with that prefix as the only thing in the file (e.g a 2-byte "uk" value). Otherwise, the add-in defaults to the "www" domain prefix.
On Sun, Nov 10, 2013 at 10:24 PM, <dabutler89@yahoo.com mailto:dabutler89@yahoo.com> wrote:
I can't seem to get this file to work properly: "smfGetAdvFNElement-Template- All-Line-Items.xls" It is the template used to dump the ADVFN data.
This is what I have done so far ( I know there has been an issue with ADVFN, my impression is that with the new add-in everything was up and running)
I am running windows 7 (x64), Excel 2013
I updated my add-in to the 10.17
changed the path of the cells to my element-definition file
What else should I be doing? The number of periods cell is coming up with "Error".
Let me know and thank you for this amazing plug-in; It's working with GuruFocus data and the add-in is a life saver.
However, that shouldn'
When you updated to 2013.10.17, did you exit EXCEL first? Add-ins are loaded at EXCEL start-up, so changing the XLA file while in EXCEL won't update the add-in until EXCEL is restarted.
You shouldn'
Be sure you have the Internet Options settings fix, described in an item in the LINKS area of the group.
If you're in another region, where AdvFN redirects you to a different domain prefix, you'll need to add an smf-AdvFN-prefix.
On Sun, Nov 10, 2013 at 10:24 PM, <dabutler89@yahoo.
I can't seem to get this file to work properly: "smfGetAdvFNEl
This is what I have done so far ( I know there has been an issue with ADVFN, my impression is that with the new add-in everything was up and running)
I am running windows 7 (x64), Excel 2013
I updated my add-in to the 10.17
changed the path of the cells to my element-definition file
What else should I be doing? The number of periods cell is coming up with "Error"
Let me know and thank you for this amazing plug-in; It's working with GuruFocus data and the add-in is a life saver.
Tidak ada komentar:
Posting Komentar