15 New Messages
Digest #2846
Messages
Fri Nov 8, 2013 1:53 am (PST) . Posted by:
af3512b8ef4166b5c33401271c05da3c
Thank you Randy !!
I cant understand why the smf-template-zacjs-data doesnt work for me
I insert the ticker e.g. xom and nothing happens . Iget the #name?
I have copied all the files from the addin to the c:\smf add-in\ .....
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
I updated the element definitions a few days ago -- see:
http://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/24316 http://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/24316
I posted an example of one of the extractions. :)
On Thu, Nov 7, 2013 at 2:36 AM, <johkouf@... mailto:johkouf@...> wrote:
Looking forward to it !
Is there any other way I could extract ? Like with url ?
If yes could you please help with syntax ?
I cant understand why the smf-template-
I insert the ticker e.g. xom and nothing happens . Iget the #name?
I have copied all the files from the addin to the c:\smf add-in\ .....
---In smf_addin@yahoogrou
I updated the element definitions a few days ago -- see:
http://groups.
I posted an example of one of the extractions. :)
On Thu, Nov 7, 2013 at 2:36 AM, <johkouf@
Looking forward to it !
Is there any other way I could extract ? Like with url ?
If yes could you please help with syntax ?
Fri Nov 8, 2013 2:06 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Do you have location errors? See the item in the LINKS area of the group.
If you did have location errors, EXCEL should have issued you a warning
about "missing links" when you opened the file.
You can try just running the smfFixLinks macro and see if that fixes the
problem.
On Fri, Nov 8, 2013 at 2:53 AM, <johkouf@hotmail.com> wrote:
>
> I cant understand why the smf-template-zacjs-data doesnt work for me
>
> I insert the ticker e.g. xom and nothing happens . Iget the #name?
>
> I have copied all the files from the addin to the c:\smf add-in\ .....
>
>
If you did have location errors, EXCEL should have issued you a warning
about "missing links" when you opened the file.
You can try just running the smfFixLinks macro and see if that fixes the
problem.
On Fri, Nov 8, 2013 at 2:53 AM, <johkouf@hotmail.
>
> I cant understand why the smf-template-
>
> I insert the ticker e.g. xom and nothing happens . Iget the #name?
>
> I have copied all the files from the addin to the c:\smf add-in\ .....
>
>
Fri Nov 8, 2013 2:31 am (PST) . Posted by:
af3512b8ef4166b5c33401271c05da3c
I followed the procedure described here : http://seekingalpha.com/instablog/326478-derek-a-barrett/1414481-automating-alpha-getting-started-with-stock-market-functions-smf-add-in-for-excel
But when I use =RCHGetElementNumber("A2";878) or any other element I get Undefined
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Do you have location errors? See the item in the LINKS area of the group. If you did have location errors, EXCEL should have issued you a warning about "missing links" when you opened the file.
You can try just running the smfFixLinks macro and see if that fixes the problem.
On Fri, Nov 8, 2013 at 2:53 AM, <johkouf@... mailto:johkouf@...> wrote:
I cant understand why the smf-template-zacjs-data doesnt work for me
I insert the ticker e.g. xom and nothing happens . Iget the #name?
I have copied all the files from the addin to the c:\smf add-in\ .....
But when I use =RCHGetElementNumbe
---In smf_addin@yahoogrou
Do you have location errors? See the item in the LINKS area of the group. If you did have location errors, EXCEL should have issued you a warning about "missing links" when you opened the file.
You can try just running the smfFixLinks macro and see if that fixes the problem.
On Fri, Nov 8, 2013 at 2:53 AM, <johkouf@
I cant understand why the smf-template-
I insert the ticker e.g. xom and nothing happens . Iget the #name?
I have copied all the files from the addin to the c:\smf add-in\ .....
Fri Nov 8, 2013 2:56 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Typically, a result of "Undefined" for elements that should have
definitions mean that the smf-elements-*.txt files are not in the folder
that the XLA file is. Those TXT files contain all the element definitions.
On Fri, Nov 8, 2013 at 3:31 AM, <johkouf@hotmail.com> wrote:
> But when I use =RCHGetElementNumber("A2";878) or any other element I get
> Undefined
>
definitions mean that the smf-elements-
that the XLA file is. Those TXT files contain all the element definitions.
On Fri, Nov 8, 2013 at 3:31 AM, <johkouf@hotmail.
> But when I use =RCHGetElementNumbe
> Undefined
>
Fri Nov 8, 2013 3:04 am (PST) . Posted by:
af3512b8ef4166b5c33401271c05da3c
What Can I do to fix this ?
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Typically, a result of "Undefined" for elements that should have definitions mean that the smf-elements-*.txt files are not in the folder that the XLA file is. Those TXT files contain all the element definitions.
On Fri, Nov 8, 2013 at 3:31 AM, <johkouf@... mailto:johkouf@...> wrote:
But when I use =RCHGetElementNumber("A2";878) or any other element I get Undefined
---In smf_addin@yahoogrou
Typically, a result of "Undefined&quo
On Fri, Nov 8, 2013 at 3:31 AM, <johkouf@
But when I use =RCHGetElementNumbe
Fri Nov 8, 2013 3:06 am (PST) . Posted by:
af3512b8ef4166b5c33401271c05da3c
I have everything in the same folder all the txt files + Rch stock market function + Rchgetelementnumber
---In smf_addin@yahoogroups.com, <johkouf@...> wrote:
What Can I do to fix this ?
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Typically, a result of "Undefined" for elements that should have definitions mean that the smf-elements-*.txt files are not in the folder that the XLA file is. Those TXT files contain all the element definitions.
On Fri, Nov 8, 2013 at 3:31 AM, <johkouf@... mailto:johkouf@...> wrote:
But when I use =RCHGetElementNumber("A2";878) or any other element I get Undefined
---In smf_addin@yahoogrou
What Can I do to fix this ?
---In smf_addin@yahoogrou
Typically, a result of "Undefined&quo
On Fri, Nov 8, 2013 at 3:31 AM, <johkouf@
But when I use =RCHGetElementNumbe
Fri Nov 8, 2013 3:13 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Is that the folder where the EXCEL Add-in Manager says the add-in is
located? In the past, people have had the files in multiple locations. That
doesn't fix things. You need to put it into one folder, and tell the EXCEL
Add-in Manager that location.
If you open a file that was created with the add-in in a different
location, it will have a hard-coded link prefixing each function
invocation, and you need to fix those links in EXCEL.
What do you get with:
=RCHGetElementNumber("Version")
On Fri, Nov 8, 2013 at 4:06 AM, <johkouf@hotmail.com> wrote:
> I have everything in the same folder all the txt files + Rch stock
> market function + Rchgetelementnumber
>
located? In the past, people have had the files in multiple locations. That
doesn't fix things. You need to put it into one folder, and tell the EXCEL
Add-in Manager that location.
If you open a file that was created with the add-in in a different
location, it will have a hard-coded link prefixing each function
invocation, and you need to fix those links in EXCEL.
What do you get with:
=RCHGetElementNumbe
On Fri, Nov 8, 2013 at 4:06 AM, <johkouf@hotmail.
> I have everything in the same folder all the txt files + Rch stock
> market function + Rchgetelementnumber
>
Fri Nov 8, 2013 3:23 am (PST) . Posted by:
af3512b8ef4166b5c33401271c05da3c
I get :
Stock Market Functions add-in, Version 2.1.2013.10.17 (C:\Users\Yiannis\Desktop; ; 30)
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Is that the folder where the EXCEL Add-in Manager says the add-in is located? In the past, people have had the files in multiple locations. That doesn't fix things. You need to put it into one folder, and tell the EXCEL Add-in Manager that location.
If you open a file that was created with the add-in in a different location, it will have a hard-coded link prefixing each function invocation, and you need to fix those links in EXCEL.
What do you get with:
=RCHGetElementNumber("Version")
On Fri, Nov 8, 2013 at 4:06 AM, <johkouf@... mailto:johkouf@...> wrote:
I have everything in the same folder all the txt files + Rch stock market function + Rchgetelementnumber
Stock Market Functions add-in, Version 2.1.2013.10.
---In smf_addin@yahoogrou
Is that the folder where the EXCEL Add-in Manager says the add-in is located? In the past, people have had the files in multiple locations. That doesn't fix things. You need to put it into one folder, and tell the EXCEL Add-in Manager that location.
If you open a file that was created with the add-in in a different location, it will have a hard-coded link prefixing each function invocation, and you need to fix those links in EXCEL.
What do you get with:
=RCHGetElementNumbe
On Fri, Nov 8, 2013 at 4:06 AM, <johkouf@
I have everything in the same folder all the txt files + Rch stock market function + Rchgetelementnumber
Fri Nov 8, 2013 3:23 am (PST) . Posted by:
af3512b8ef4166b5c33401271c05da3c
I get
Stock Market Functions add-in, Version 2.1.2013.10.17 (C:\Users\Yiannis\Desktop; ; 30)
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Is that the folder where the EXCEL Add-in Manager says the add-in is located? In the past, people have had the files in multiple locations. That doesn't fix things. You need to put it into one folder, and tell the EXCEL Add-in Manager that location.
If you open a file that was created with the add-in in a different location, it will have a hard-coded link prefixing each function invocation, and you need to fix those links in EXCEL.
What do you get with:
=RCHGetElementNumber("Version")
On Fri, Nov 8, 2013 at 4:06 AM, <johkouf@... mailto:johkouf@...> wrote:
I have everything in the same folder all the txt files + Rch stock market function + Rchgetelementnumber
Stock Market Functions add-in, Version 2.1.2013.10.
---In smf_addin@yahoogrou
Is that the folder where the EXCEL Add-in Manager says the add-in is located? In the past, people have had the files in multiple locations. That doesn't fix things. You need to put it into one folder, and tell the EXCEL Add-in Manager that location.
If you open a file that was created with the add-in in a different location, it will have a hard-coded link prefixing each function invocation, and you need to fix those links in EXCEL.
What do you get with:
=RCHGetElementNumbe
On Fri, Nov 8, 2013 at 4:06 AM, <johkouf@
I have everything in the same folder all the txt files + Rch stock market function + Rchgetelementnumber
Fri Nov 8, 2013 3:32 am (PST) . Posted by:
"Randy Harmelink" rharmelink
OK, so C:\Users\Yiannis\Desktop is where the add-in manager has been told
the add-in is located. That folder needs to have all of the
smf-elements-*.txt files. And you will definitely have to edit all links
any time you open up a workbook created by someone else. Because it's
highly unlikely anyone else will have the add-in in that location.
On Fri, Nov 8, 2013 at 4:23 AM, <johkouf@hotmail.com> wrote:
> I get :
>
> Stock Market Functions add-in, Version 2.1.2013.10.17
> (C:\Users\Yiannis\Desktop; ; 30)
>
the add-in is located. That folder needs to have all of the
smf-elements-
any time you open up a workbook created by someone else. Because it's
highly unlikely anyone else will have the add-in in that location.
On Fri, Nov 8, 2013 at 4:23 AM, <johkouf@hotmail.
> I get :
>
> Stock Market Functions add-in, Version 2.1.2013.10.
> (C:\Users&#
>
Fri Nov 8, 2013 3:41 am (PST) . Posted by:
af3512b8ef4166b5c33401271c05da3c
Nice Randy !!!
It works perfect ! I just copied all the TXT on desktop and works !!!
But how could I change the file location so I could put them all in a folder ?
Thanks !!!
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
OK, so C:\Users\Yiannis\Desktop is where the add-in manager has been told the add-in is located. That folder needs to have all of the smf-elements-*.txt files. And you will definitely have to edit all links any time you open up a workbook created by someone else. Because it's highly unlikely anyone else will have the add-in in that location.
On Fri, Nov 8, 2013 at 4:23 AM, <johkouf@... mailto:johkouf@...> wrote:
I get :
Stock Market Functions add-in, Version 2.1.2013.10.17 (C:\Users\Yiannis\Desktop; ; 30)
It works perfect ! I just copied all the TXT on desktop and works !!!
But how could I change the file location so I could put them all in a folder ?
Thanks !!!
---In smf_addin@yahoogrou
OK, so C:\Users&#
On Fri, Nov 8, 2013 at 4:23 AM, <johkouf@
I get :
Stock Market Functions add-in, Version 2.1.2013.10.
Fri Nov 8, 2013 4:07 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Create a folder, unzip the ZIP file into that folder, then tell the add-in
manager to use THAT location.
On Fri, Nov 8, 2013 at 4:41 AM, <johkouf@hotmail.com> wrote:
> It works perfect ! I just copied all the TXT on desktop and works !!!
>
> But how could I change the file location so I could put them all in a
> folder ?
>
manager to use THAT location.
On Fri, Nov 8, 2013 at 4:41 AM, <johkouf@hotmail.
> It works perfect ! I just copied all the TXT on desktop and works !!!
>
> But how could I change the file location so I could put them all in a
> folder ?
>
Fri Nov 8, 2013 4:10 am (PST) . Posted by:
mrmonopoly88
Good day,
I am trying to get fund risk ratios from google. By example for the FVVAX fund I try to the following to receive the Alpha ratio:
=RCHGetTableCell("https://www.google.com/finance?q="&M2;1;"Alpha*")
With M2 being the ticker offcourse. I always get a "Error".
Ps: using a belgian keyboard, so I use ; instead of , in my formulas.
Yahoo finance works well with other funds, but yahoo does not have information for FVVAX ratios.
I am trying to get fund risk ratios from google. By example for the FVVAX fund I try to the following to receive the Alpha ratio:
=RCHGetTableCell(
With M2 being the ticker offcourse. I always get a "Error"
Ps: using a belgian keyboard, so I use ; instead of , in my formulas.
Yahoo finance works well with other funds, but yahoo does not have information for FVVAX ratios.
Fri Nov 8, 2013 4:20 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Google doesn't have properly coded tables (no ending coding for each table
cell), so the RCHGetTableCell() function can't extract the data. The
smfGetTagContent() function is set up to work for missing ending table cell
tags, so you could extract with:
=smfConvertData(smfGetTagContent("https://www.google.com/finance?q=
"&E4,"td",1,">Alpha*"))
On Fri, Nov 8, 2013 at 5:10 AM, <montegnies.dennis@gmail.com> wrote:
>
> I am trying to get fund risk ratios from google. By example for the FVVAX
> fund I try to the following to receive the Alpha ratio:
>
> =RCHGetTableCell("https://www.google.com/finance?q="&M2;1;"Alpha*")
>
> With M2 being the ticker offcourse. I always get a "Error".
>
> Ps: using a belgian keyboard, so I use ; instead of , in my formulas.
>
> Yahoo finance works well with other funds, but yahoo does not have
> information for FVVAX ratios.
>
cell), so the RCHGetTableCell(
smfGetTagContent(
tags, so you could extract with:
=smfConvertData(
"&E4,"
On Fri, Nov 8, 2013 at 5:10 AM, <montegnies.dennis@
>
> I am trying to get fund risk ratios from google. By example for the FVVAX
> fund I try to the following to receive the Alpha ratio:
>
> =RCHGetTableCell(
>
> With M2 being the ticker offcourse. I always get a "Error"
>
> Ps: using a belgian keyboard, so I use ; instead of , in my formulas.
>
> Yahoo finance works well with other funds, but yahoo does not have
> information for FVVAX ratios.
>
Fri Nov 8, 2013 8:44 am (PST) . Posted by:
lewglenn
Great, thanks for the clarification.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Those are undocumented parameters that I originally added for my own use, so I could use the function in VBA. I didn't really want to document them because I didn't want people using them -- in case I wanted to add more parameters to the function. If so, I would want them in FRONT of those two parameters, which is a problem if people are using them in worksheet invocations.
The "pDim1" and "pDim2" parameters in any function that returns an array of data define the number of rows and columns of data that the function should return. In general, those dimensions are usually set when you array-enter those functions.
So, in this case, those parameters are telling RCHGetYahooHistory() to return 50 rows of data within a single column. It's the same result you would get if you array-entered the formula without those parameters, in a 50-row by 1-column worksheet range.
On Thu, Nov 7, 2013 at 6:12 PM, Yahoo! <lewglenn@... mailto:lewglenn@...> wrote:
In the example you provided to compute the 50-day SMA:
=AVERAGE(RCHGetYahooHistory("FBIOX";,,,,,,,,"a",0,,,50,1))
the last 2 entries in the function are not described in the online documentation. Is there a newer version of the documentation for RCHGetYahooHistory or is this the normal way AVERAGE & RCHGetYahooHistory are combined? What is the significance of the '1" after the '50'?
---In smf_addin@yahoogrou
Those are undocumented parameters that I originally added for my own use, so I could use the function in VBA. I didn't really want to document them because I didn't want people using them -- in case I wanted to add more parameters to the function. If so, I would want them in FRONT of those two parameters, which is a problem if people are using them in worksheet invocations.
The "pDim1" and "pDim2" parameters in any function that returns an array of data define the number of rows and columns of data that the function should return. In general, those dimensions are usually set when you array-enter those functions.
So, in this case, those parameters are telling RCHGetYahooHistory(
On Thu, Nov 7, 2013 at 6:12 PM, Yahoo! <lewglenn@
In the example you provided to compute the 50-day SMA:
=AVERAGE(RCHGetYaho
the last 2 entries in the function are not described in the online documentation. Is there a newer version of the documentation for RCHGetYahooHistory or is this the normal way AVERAGE & RCHGetYahooHistory are combined? What is the significance of the '1" after the '50'
Tidak ada komentar:
Posting Komentar