15 New Messages
Digest #2648
1a
Re: Some assistance with RCHGetYahooQuotes part of spreadsheet by "thefishermanpedro15" thefishermanpedro15
4b
Re: what is the difference between Rch type formula and smf type for by "Randy Harmelink" rharmelink
4d
Re: what is the difference between Rch type formula and smf type for by "Randy Harmelink" rharmelink
Messages
Fri Jun 7, 2013 5:54 am (PDT) . Posted by:
"thefishermanpedro15" thefishermanpedro15
Thanks.
Fixed that ok
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> See the location errors item in the LINKS area of the group.
>
> On Wed, Jun 5, 2013 at 5:47 PM, thefishermanpedro15 <prob1@...>wrote:
>
> > I am using excel 2003 , on windows 7 and have an old spreadsheet based on
> > above.
> >
> > During time I last used it and now I have changed computers and the Add
> > ins required were not on machine.
> > Have downloaded RCH_Stock_Market_Functions to Programme Files (x86) to a
> > folder styled SMF Add-in.
> > When I try to refresh file I get a #NAME error.
> > Formula in spreadsheet is
> > ='C:\Program
> > Files\SMF-Addin\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(A2:A100,B1:M1)
> > One of the stocks used in A2 is AGK.ax
> >
> > I did try using Program Files rather than Program Files (x86) but same
> > result (#NAME error)
> >
> > It appears to me that I also need an add in styled RCHGetYahooQuotes
> > but am unable to find it.
> >
> > Where am I going wrong?
> >
>
Fixed that ok
--- In smf_addin@yahoogrou
>
> See the location errors item in the LINKS area of the group.
>
> On Wed, Jun 5, 2013 at 5:47 PM, thefishermanpedro15 <prob1@..
>
> > I am using excel 2003 , on windows 7 and have an old spreadsheet based on
> > above.
> >
> > During time I last used it and now I have changed computers and the Add
> > ins required were not on machine.
> > Have downloaded RCH_Stock_Market_
> > folder styled SMF Add-in.
> > When I try to refresh file I get a #NAME error.
> > Formula in spreadsheet is
> > ='C:\
> > Files\SMF-
> > One of the stocks used in A2 is AGK.ax
> >
> > I did try using Program Files rather than Program Files (x86) but same
> > result (#NAME error)
> >
> > It appears to me that I also need an add in styled RCHGetYahooQuotes
> > but am unable to find it.
> >
> > Where am I going wrong?
> >
>
Fri Jun 7, 2013 7:37 am (PDT) . Posted by:
"brad.valentine" brad.valentine
I am trying to build a stock quotes monitor using real-time data. I have the real-time stock quotes using the Yahoo Real-Time quote formula; however, this formula does not work for S&P 500, NASDAQ Composite, or Dow Jones Industrial? Does anyone know how to do this? How do I import real-time index quotes into a spreadsheet?
Thanks,
Brad
Thanks,
Brad
Fri Jun 7, 2013 8:19 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It would have helped if you had stated the formula that wasn't working. Try
this:
=smfConvertData(smfGetTagContent("http://finance.yahoo.com/q?s=
"&$C2,"span",-1,"id=""yfs_l10"))
Also, no need to repeat the message.
On Thu, Jun 6, 2013 at 1:38 PM, brad.valentine <brad.valentine@yahoo.com >wrote:
> How do I get real-time S&P 500, NASDAQ Composite, and Dow Jones Industrial
> quotes into excel? The Yahoo Real Time Quotes formula works for individual
> stocks, but it does not seem to work for the indices.
>
>
this:
=smfConvertData(
"&$C2,"
Also, no need to repeat the message.
On Thu, Jun 6, 2013 at 1:38 PM, brad.valentine <brad.valentine@
> How do I get real-time S&P 500, NASDAQ Composite, and Dow Jones Industrial
> quotes into excel? The Yahoo Real Time Quotes formula works for individual
> stocks, but it does not seem to work for the indices.
>
>
Fri Jun 7, 2013 12:13 pm (PDT) . Posted by:
"brad.valentine" brad.valentine
Sorry about that. I thought that I forgot to submit it because I couldn't see it this morning, so I resubmitted the message. Your response was exactly what I needed. Thank you very much.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It would have helped if you had stated the formula that wasn't working. Try
> this:
>
> =smfConvertData(smfGetTagContent("http://finance.yahoo.com/q?s=
> "&$C2,"span",-1,"id=""yfs_l10"))
>
> Also, no need to repeat the message.
>
> On Thu, Jun 6, 2013 at 1:38 PM, brad.valentine <brad.valentine@...>wrote:
>
> > How do I get real-time S&P 500, NASDAQ Composite, and Dow Jones Industrial
> > quotes into excel? The Yahoo Real Time Quotes formula works for individual
> > stocks, but it does not seem to work for the indices.
> >
> >
>
--- In smf_addin@yahoogrou
>
> It would have helped if you had stated the formula that wasn't working. Try
> this:
>
> =smfConvertData(
> "&$C2,"
>
> Also, no need to repeat the message.
>
> On Thu, Jun 6, 2013 at 1:38 PM, brad.valentine <brad.valentine@
>
> > How do I get real-time S&P 500, NASDAQ Composite, and Dow Jones Industrial
> > quotes into excel? The Yahoo Real Time Quotes formula works for individual
> > stocks, but it does not seem to work for the indices.
> >
> >
>
Fri Jun 7, 2013 8:47 am (PDT) . Posted by:
"Roger Diaz" rogerdiazbernal
I have Excel 2010
Fri Jun 7, 2013 8:52 am (PDT) . Posted by:
"Roger Diaz" rogerdiazbernal
Randy:
But the file save in format 2007.
But the file save in format 2007.
Fri Jun 7, 2013 9:41 am (PDT) . Posted by:
"Roger Diaz" rogerdiazbernal
Randy:
Thanks to your observation, I checked the Add-in and it was not in the
right direction.
I corrected it and now it works fine.
I will be more careful
Sorry.
Roger
Thanks to your observation, I checked the Add-in and it was not in the
right direction.
I corrected it and now it works fine.
I will be more careful
Sorry.
Roger
Fri Jun 7, 2013 10:37 am (PDT) . Posted by:
"Xin L" liucyndy
1. I use all the RCHGetElementNumber()formula well. But when I tried to use formulas starting with smf, it only works for one formula, all the rest I tried failed. I wonder if I need to install some add_in other than the one named "RCH_Stock_Market_Functions-2.1.2012.12.29.zip ". For example, smfgetcsv.
2. Also, for =smfGetAdvFNElement, where can I find the complete element list?
3. how can I download a company's 10-k and 10-q?
Thanks a lot!
2. Also, for =smfGetAdvFNElement
3. how can I download a company'
Thanks a lot!
Fri Jun 7, 2013 10:56 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
1. Originally, I wrote the functions for my own use. I used my initials
(RCH), so they would all be grouped together in the list of functions. It
wasn't until later that I released them as a group, in an add-in. At that
time, others were already using the functions, so I really couldn't change
the names. I would prefer they ALL have an "smf" prefix. So, as a result,
only NEW functions start with "smf", but the original "RCH" functions
remain as they were. Unfortunately, Visual Basic doesn't have an alias type
usage for function names, or at least not one that I know about.
2. You'd need to go to the AdvFN web site, to see what labels they use.
I don't know of any comprehensive listing anywhere. Also, what works for
one company may not work for another. For example, financial companies have
their own set of line items for financial statements.
3. Unfortunately, they aren't all the same, so it's somewhat
problematic. You can go online and search for them, find out the CBRL file
name (or the HTML name), and use functions to grab the data. But what works
for one company may not work for another, or there may be a vastly
different set of data items available. Plus, you have the issue of history
not being available, or difficult to coordinate, so I really haven't
focused much on SEC type filings.
On Fri, Jun 7, 2013 at 10:37 AM, Xin L <jgr1230@gmail.com > wrote:
> 1. I use all the RCHGetElementNumber()formula well. But when I tried to
> use formulas starting with smf, it only works for one formula, all the rest
> I tried failed. I wonder if I need to install some add_in other than the
> one named "RCH_Stock_Market_Functions-2.1.2012.12.29.zip ". For example,
> smfgetcsv.
> 2. Also, for =smfGetAdvFNElement, where can I find the complete element
> list?
> 3. how can I download a company's 10-k and 10-q?
> Thanks a lot!
>
(RCH), so they would all be grouped together in the list of functions. It
wasn't until later that I released them as a group, in an add-in. At that
time, others were already using the functions, so I really couldn't change
the names. I would prefer they ALL have an "smf" prefix. So, as a result,
only NEW functions start with "smf"
remain as they were. Unfortunately, Visual Basic doesn't have an alias type
usage for function names, or at least not one that I know about.
2. You'd need to go to the AdvFN web site, to see what labels they use.
I don't know of any comprehensive listing anywhere. Also, what works for
one company may not work for another. For example, financial companies have
their own set of line items for financial statements.
3. Unfortunately, they aren't all the same, so it's somewhat
problematic. You can go online and search for them, find out the CBRL file
name (or the HTML name), and use functions to grab the data. But what works
for one company may not work for another, or there may be a vastly
different set of data items available. Plus, you have the issue of history
not being available, or difficult to coordinate, so I really haven't
focused much on SEC type filings.
On Fri, Jun 7, 2013 at 10:37 AM, Xin L <jgr1230@gmail.
> 1. I use all the RCHGetElementNumber
> use formulas starting with smf, it only works for one formula, all the rest
> I tried failed. I wonder if I need to install some add_in other than the
> one named "RCH_Stock_
> smfgetcsv.
> 2. Also, for =smfGetAdvFNElement
> list?
> 3. how can I download a company'
> Thanks a lot!
>
Fri Jun 7, 2013 11:15 am (PDT) . Posted by:
"Xin L" liucyndy
Thanks a lot!
but why most of smf functions I used does not work? for example, =smfGetCSVFile, I hard copied the formula from your website to my excel but it returned #VALUE!.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> 1. Originally, I wrote the functions for my own use. I used my initials
> (RCH), so they would all be grouped together in the list of functions. It
> wasn't until later that I released them as a group, in an add-in. At that
> time, others were already using the functions, so I really couldn't change
> the names. I would prefer they ALL have an "smf" prefix. So, as a result,
> only NEW functions start with "smf", but the original "RCH" functions
> remain as they were. Unfortunately, Visual Basic doesn't have an alias type
> usage for function names, or at least not one that I know about.
>
> 2. You'd need to go to the AdvFN web site, to see what labels they use.
> I don't know of any comprehensive listing anywhere. Also, what works for
> one company may not work for another. For example, financial companies have
> their own set of line items for financial statements.
>
> 3. Unfortunately, they aren't all the same, so it's somewhat
> problematic. You can go online and search for them, find out the CBRL file
> name (or the HTML name), and use functions to grab the data. But what works
> for one company may not work for another, or there may be a vastly
> different set of data items available. Plus, you have the issue of history
> not being available, or difficult to coordinate, so I really haven't
> focused much on SEC type filings.
>
>
> On Fri, Jun 7, 2013 at 10:37 AM, Xin L <jgr1230@...> wrote:
>
> > 1. I use all the RCHGetElementNumber()formula well. But when I tried to
> > use formulas starting with smf, it only works for one formula, all the rest
> > I tried failed. I wonder if I need to install some add_in other than the
> > one named "RCH_Stock_Market_Functions-2.1.2012.12.29.zip ". For example,
> > smfgetcsv.
> > 2. Also, for =smfGetAdvFNElement, where can I find the complete element
> > list?
> > 3. how can I download a company's 10-k and 10-q?
> > Thanks a lot!
> >
>
but why most of smf functions I used does not work? for example, =smfGetCSVFile, I hard copied the formula from your website to my excel but it returned #VALUE!.
--- In smf_addin@yahoogrou
>
> 1. Originally, I wrote the functions for my own use. I used my initials
> (RCH), so they would all be grouped together in the list of functions. It
> wasn't until later that I released them as a group, in an add-in. At that
> time, others were already using the functions, so I really couldn't change
> the names. I would prefer they ALL have an "smf" prefix. So, as a result,
> only NEW functions start with "smf"
> remain as they were. Unfortunately, Visual Basic doesn't have an alias type
> usage for function names, or at least not one that I know about.
>
> 2. You'd need to go to the AdvFN web site, to see what labels they use.
> I don't know of any comprehensive listing anywhere. Also, what works for
> one company may not work for another. For example, financial companies have
> their own set of line items for financial statements.
>
> 3. Unfortunately, they aren't all the same, so it's somewhat
> problematic. You can go online and search for them, find out the CBRL file
> name (or the HTML name), and use functions to grab the data. But what works
> for one company may not work for another, or there may be a vastly
> different set of data items available. Plus, you have the issue of history
> not being available, or difficult to coordinate, so I really haven't
> focused much on SEC type filings.
>
>
> On Fri, Jun 7, 2013 at 10:37 AM, Xin L <jgr1230@
>
> > 1. I use all the RCHGetElementNumber
> > use formulas starting with smf, it only works for one formula, all the rest
> > I tried failed. I wonder if I need to install some add_in other than the
> > one named "RCH_Stock_
> > smfgetcsv.
> > 2. Also, for =smfGetAdvFNElement
> > list?
> > 3. how can I download a company'
> > Thanks a lot!
> >
>
Fri Jun 7, 2013 12:36 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Can you give me an example?
Typical reasons for #VALUE! on an add-in function:
- Improper parameter
- A string being returned is too long for EXCEL. This mostly affects
older versions of EXCEL.
But if you're copying and pasting, that pretty much leaves the second
item...
On Fri, Jun 7, 2013 at 11:15 AM, Xin L <jgr1230@gmail.com > wrote:
> but why most of smf functions I used does not work? for example,
> =smfGetCSVFile, I hard copied the formula from your website to my excel but
> it returned #VALUE!.
>
Typical reasons for #VALUE! on an add-in function:
- Improper parameter
- A string being returned is too long for EXCEL. This mostly affects
older versions of EXCEL.
But if you're copying and pasting, that pretty much leaves the second
item...
On Fri, Jun 7, 2013 at 11:15 AM, Xin L <jgr1230@gmail.
> but why most of smf functions I used does not work? for example,
> =smfGetCSVFile, I hard copied the formula from your website to my excel but
> it returned #VALUE!.
>
Fri Jun 7, 2013 12:09 pm (PDT) . Posted by:
"JPS" jpsartrean
I need to check the legislative history on a bunch of Michigan statutes and am hoping the addin could potentially pull them for me.
I'd like to be able to extract:
History: 2012, Act 387, Imd. Eff. Dec. 19, 2012
from the following webpage:
http://www.legislature.mi.gov/ (S(lvvp5iqzhaw1yz45enuhze3s))/mileg.aspx?page=getobject&objectname=mcl-124-542
I've been trying with RCHGetTableCell, smfGetTagContent, and RCHGetWebData, but so far no luck... Unfortunately my knowledge of HTML coding/tables is pretty basic...
Can anyone help me out with a formula that will work? I'd be extraordinarily grateful!!
I'd like to be able to extract:
History: 2012, Act 387, Imd. Eff. Dec. 19, 2012
from the following webpage:
http://www.legislat
I've been trying with RCHGetTableCell, smfGetTagContent, and RCHGetWebData, but so far no luck... Unfortunately my knowledge of HTML coding/tables is pretty basic...
Can anyone help me out with a formula that will work? I'd be extraordinarily grateful!!
Fri Jun 7, 2013 12:33 pm (PDT) . Posted by:
"JPS" jpsartrean
link should be:
http://www.legislat
--- In smf_addin@yahoogrou
>
> I need to check the legislative history on a bunch of Michigan statutes and am hoping the addin could potentially pull them for me.
>
> I'd like to be able to extract:
>
> History: 2012, Act 387, Imd. Eff. Dec. 19, 2012
>
> from the following webpage:
>
> http://www.legislat
>
>
> I've been trying with RCHGetTableCell, smfGetTagContent, and RCHGetWebData, but so far no luck... Unfortunately my knowledge of HTML coding/tables is pretty basic...
>
> Can anyone help me out with a formula that will work? I'd be extraordinarily grateful!!
>
Fri Jun 7, 2013 12:40 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
This:
=smfGetTagContent("
http://www.legislature.mi.gov/%28S%28lvvp5iqzhaw1yz45enuhze3s%29%29/mileg.aspx?page=getobject&objectname=mcl-124-542
","p",-1,"History:")
...returns:
<BR><B>History:</B> 2012, Act 387, Imd. Eff. Dec. 19, 2012
...but you can do:
=smfStrExtr(smfGetTagContent("
http://www.legislature.mi.gov/%28S%28lvvp5iqzhaw1yz45enuhze3s%29%29/mileg.aspx?page=getobject&objectname=mcl-124-542 ","p",-1,"History:"),"B>
","~")
...for just:
2012, Act 387, Imd. Eff. Dec. 19, 2012
...or use SUBSTITUTE() functions to remove those HTML tags.
On Fri, Jun 7, 2013 at 12:09 PM, JPS <jpsartrean@yahoo.com > wrote:
> I need to check the legislative history on a bunch of Michigan statutes
> and am hoping the addin could potentially pull them for me.
>
> I'd like to be able to extract:
>
> History: 2012, Act 387, Imd. Eff. Dec. 19, 2012
>
> from the following webpage:
>
>
> http://www.legislature.mi.gov/ (S(lvvp5iqzhaw1yz45enuhze3s))/mileg.aspx?page=getobject&objectname=mcl-124-542
>
>
> I've been trying with RCHGetTableCell, smfGetTagContent, and
> RCHGetWebData, but so far no luck... Unfortunately my knowledge of HTML
> coding/tables is pretty basic...
>
> Can anyone help me out with a formula that will work? I'd be
> extraordinarily grateful!!
>
=smfGetTagContent(
http://www.legislat
","
...returns:
<BR><
...but you can do:
=smfStrExtr(
http://www.legislat
","
...for just:
2012, Act 387, Imd. Eff. Dec. 19, 2012
...or use SUBSTITUTE() functions to remove those HTML tags.
On Fri, Jun 7, 2013 at 12:09 PM, JPS <jpsartrean@yahoo.
> I need to check the legislative history on a bunch of Michigan statutes
> and am hoping the addin could potentially pull them for me.
>
> I'd like to be able to extract:
>
> History: 2012, Act 387, Imd. Eff. Dec. 19, 2012
>
> from the following webpage:
>
>
> http://www.legislat
>
>
> I've been trying with RCHGetTableCell, smfGetTagContent, and
> RCHGetWebData, but so far no luck... Unfortunately my knowledge of HTML
> coding/tables is pretty basic...
>
> Can anyone help me out with a formula that will work? I'd be
> extraordinarily grateful!!
>
Fri Jun 7, 2013 12:57 pm (PDT) . Posted by:
"JPS" jpsartrean
Randy,
You TRULY are a wizard!! Thanks ever so much...
--- In smf_addin@yahoogrou
>
> This:
>
> =smfGetTagContent(
> http://www.legislat
> ","
>
> ...returns:
>
> <BR><
>
> ...but you can do:
>
> =smfStrExtr(
> http://www.legislat
> ","
>
> ...for just:
>
> 2012, Act 387, Imd. Eff. Dec. 19, 2012
>
> ...or use SUBSTITUTE() functions to remove those HTML tags.
>
> On Fri, Jun 7, 2013 at 12:09 PM, JPS <jpsartrean@
>
> > I need to check the legislative history on a bunch of Michigan statutes
> > and am hoping the addin could potentially pull them for me.
> >
> > I'd like to be able to extract:
> >
> > History: 2012, Act 387, Imd. Eff. Dec. 19, 2012
> >
> > from the following webpage:
> >
> >
> > http://www.legislat
> >
> >
> > I've been trying with RCHGetTableCell, smfGetTagContent, and
> > RCHGetWebData, but so far no luck... Unfortunately my knowledge of HTML
> > coding/tables is pretty basic...
> >
> > Can anyone help me out with a formula that will work? I'd be
> > extraordinarily grateful!!
> >
>
Tidak ada komentar:
Posting Komentar