15 New Messages
Digest #2701
4b
Re: ADV/FN data - all returning ERROR - others all work fine though by "Randy Harmelink" rharmelink
Messages
Fri Jul 19, 2013 5:48 am (PDT) . Posted by:
"Dvir Harmelech" h_dvir
First of all Randy, I must complement you on the amazing job you are doing here.
Not only you have developed this code (which is admirable by itself) but providing such a great response answering all these questions from the group. Unbelievable !!
I still have a question:
=RCHGetTableCell("http://www.investorpoint.com/stock/wfc.ws-Wells+Fargo+Co.+Wt/price-history?startDay=1 <http://www.investorpoint.com/stock/wfc.ws-Wells+Fargo+Co.+Wt/price-history?startDay=1&startMonth=6&startYear=2013&endDay=1&endMonth=6&endYear=2013 > &startMonth=6&startYear=2013&endDay=1&endMonth=6&endYear=2013",4,">Trade Val","07/01/13")
Works for me well.
Is there a way to automate the url address ?
I mean, a string operation within the RCHGetTableCell that will generate the correct address from a "date" cell in my table ?
Thank you again,
Dvir
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Friday, July 19, 2013 12:12 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Quotations from Yahoo
You should use multiple dates in a single smfPricesByDates() function, because you need to go to the Internet for data with EACH function invocation.
I don't know of a work-around without another data source.
The other site you mention can be used, but you would need to get the data a page at a time:
=RCHGetHTMLTable("http://www.investorpoint.com/stock/wfc.ws-Wells+Fargo+Co.+Wt/price-history/?page=1 <http://www.investorpoint.com/stock/wfc.ws-Wells+Fargo+Co.+Wt/price-history/?page=1&startDay=18&startMonth=5&startYear=2012&endDay=18&endMonth=6&endYear=2013&perPage=100 > &startDay=18&startMonth=5&startYear=2012&endDay=18&endMonth=6&endYear=2013&perPage=100",">Trade Val",-1,"",1)
=RCHGetHTMLTable("http://www.investorpoint.com/stock/wfc.ws-Wells+Fargo+Co.+Wt/price-history/?page=2 <http://www.investorpoint.com/stock/wfc.ws-Wells+Fargo+Co.+Wt/price-history/?page=2&startDay=18&startMonth=5&startYear=2012&endDay=18&endMonth=6&endYear=2013&perPage=100 > &startDay=18&startMonth=5&startYear=2012&endDay=18&endMonth=6&endYear=2013&perPage=100",">Trade Val",-1,"",1)
Etc. Or, to get the data for a single day, such as July 1, 2013:
=RCHGetTableCell("http://www.investorpoint.com/stock/wfc.ws-Wells+Fargo+Co.+Wt/price-history?startDay=1 <http://www.investorpoint.com/stock/wfc.ws-Wells+Fargo+Co.+Wt/price-history?startDay=1&startMonth=6&startYear=2013&endDay=1&endMonth=6&endYear=2013 > &startMonth=6&startYear=2013&endDay=1&endMonth=6&endYear=2013",4,">Trade Val","07/01/13")
Note that "startMonth" and "endMonth"; are offset values (i.e. actual month less 1).
On Thu, Jul 18, 2013 at 12:33 PM, Dvir Harmelech <dvir.harmelech@gmail.com <mailto:dvir.harmelech@gmail.com > > wrote:
I actually was using smfPricesByDates ("WFC-WT",D1) where D1 is a date cell in a table, to create a table of prices-by-date (and use it to plot a time graph)
Is there a way around the problem of the WFC-WT historic values ?
I have found that http://www.investorpoint.com/stock/wfc.ws-Wells%20Fargo%20Co.%20Wt/price-history/ have this information, for example.
Is that a way I could extract the prices from there, of any other place that may have this information ?
Not only you have developed this code (which is admirable by itself) but providing such a great response answering all these questions from the group. Unbelievable !!
I still have a question:
=RCHGetTableCell(
Works for me well.
Is there a way to automate the url address ?
I mean, a string operation within the RCHGetTableCell that will generate the correct address from a "date" cell in my table ?
Thank you again,
Dvir
From: smf_addin@yahoogrou
Sent: Friday, July 19, 2013 12:12 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Quotations from Yahoo
You should use multiple dates in a single smfPricesByDates(
I don't know of a work-around without another data source.
The other site you mention can be used, but you would need to get the data a page at a time:
=RCHGetHTMLTable(
=RCHGetHTMLTable(
Etc. Or, to get the data for a single day, such as July 1, 2013:
=RCHGetTableCell(
Note that "startMonth&qu
On Thu, Jul 18, 2013 at 12:33 PM, Dvir Harmelech <dvir.harmelech@
I actually was using smfPricesByDates ("WFC-WT"
Is there a way around the problem of the WFC-WT historic values ?
I have found that http://www.investor
Is that a way I could extract the prices from there, of any other place that may have this information ?
Fri Jul 19, 2013 8:31 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Just use normal EXCEL concatenation to combine strings and cell references
and/or functions. For example, something like:
="...string1..." & A1 & "...string2..." & YEAR(B1) & "...string3..."
Be sure to use month offsets rather than month values.
On Fri, Jul 19, 2013 at 5:47 AM, Dvir Harmelech <dvir.harmelech@gmail.com >wrote:
>
> I still have a question:****
>
> ** **
>
> =RCHGetTableCell("
> http://www.investorpoint.com/stock/wfc.ws-Wells+Fargo+Co.+Wt/price-history?startDay=1&startMonth=6&startYear=2013&endDay=1&endMonth=6&endYear=2013 ",4,">Trade
> Val","07/01/13")****
>
> ** **
>
> Works for me well. ****
>
> Is there a way to automate the url address ? ****
>
> I mean, a string operation within the RCHGetTableCell that will generate
> the correct address from a "date" cell in my table ?****
>
>
>
and/or functions. For example, something like:
="...string1.
Be sure to use month offsets rather than month values.
On Fri, Jul 19, 2013 at 5:47 AM, Dvir Harmelech <dvir.harmelech@
>
> I still have a question:***
>
> ** **
>
> =RCHGetTableCell(
> http://www.investor
> Val","
>
> ** **
>
> Works for me well. ****
>
> Is there a way to automate the url address ? ****
>
> I mean, a string operation within the RCHGetTableCell that will generate
> the correct address from a "date" cell in my table ?****
>
>
>
Fri Jul 19, 2013 8:28 am (PDT) . Posted by:
"tenspeed39255" tenspeed39255
Hi Randy Rather than ask how to use your program I am asking for the
area where I can learn how to use your amf_addin program. I have downloaded RCHGetElementNumber() Element Definitions as of 2012-02-12
and have it in an Excel ss but this is as far as I have got. So where is the page showing how to use your program. Thanks for any help with this.
Max
area where I can learn how to use your amf_addin program. I have downloaded RCHGetElementNumber
and have it in an Excel ss but this is as far as I have got. So where is the page showing how to use your program. Thanks for any help with this.
Max
Fri Jul 19, 2013 8:32 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Check out the "Documentation" folder of the FILES area of the group.
Also, the LINKS area of the group has a lot of tips and FAQs.
On Fri, Jul 19, 2013 at 6:27 AM, tenspeed39255 <tenspeed23@comcast.net >wrote:
> Hi Randy Rather than ask how to use your program I am asking for the
> area where I can learn how to use your amf_addin program. I have
> downloaded RCHGetElementNumber() Element Definitions as of 2012-02-12
> and have it in an Excel ss but this is as far as I have got. So where is
> the page showing how to use your program.
>
Also, the LINKS area of the group has a lot of tips and FAQs.
On Fri, Jul 19, 2013 at 6:27 AM, tenspeed39255 <tenspeed23@comcast.
> Hi Randy Rather than ask how to use your program I am asking for the
> area where I can learn how to use your amf_addin program. I have
> downloaded RCHGetElementNumber
> and have it in an Excel ss but this is as far as I have got. So where is
> the page showing how to use your program.
>
Fri Jul 19, 2013 10:16 am (PDT) . Posted by:
"yjeffs1" yjeffs1
To use the files we need to enable the macros. In practically all cases they are safe. What confidence should we have in their being malware free 100% ? How do you prevent someone modifying existing files or uploading malicious file? Do the usual antivirus apps vet the Excel files? (Does MSE?)
Fri Jul 19, 2013 10:27 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You do NOT need to enable macros in order to use the add-in. By the very
fact of you adding the add-in with the add-in manager, you've already given
it all the security approval you need to. That in itself can be a leap of
faith, but it is the reason I have open source code -- so anyone could look
at it and see what's going on.
My option is set to disable with notification. Then you can enable them on
a case by case basis.
There are other ways that workbooks can automatically be approved, but I've
rarely used them.
No antivirus app could vet the EXCEL files, since it would have to examine
the code line by line to do so. And have a pretty sophisticated routine to
examine the code to find something malicious.
I am always very nervous about using workbooks with protected VBA code,
since you have no idea what they could be doing. However, I am pretty
trusting of things like ASAP and TA-Lib, just because of their nature and
exposure.
So if you are using workbooks from the FILES area that have macros, it's up
to you whether you will trust the author. I don't usually turn on the
macros, since I have my own processing that I do and don't need the
functions that those workbooks provide.
On Fri, Jul 19, 2013 at 9:55 AM, yjeffs1 <yjshaham@gmail.com > wrote:
> To use the files we need to enable the macros. In practically all cases
> they are safe. What confidence should we have in their being malware free
> 100% ? How do you prevent someone modifying existing files or uploading
> malicious file? Do the usual antivirus apps vet the Excel files? (Does
> MSE?)
>
fact of you adding the add-in with the add-in manager, you've already given
it all the security approval you need to. That in itself can be a leap of
faith, but it is the reason I have open source code -- so anyone could look
at it and see what's going on.
My option is set to disable with notification. Then you can enable them on
a case by case basis.
There are other ways that workbooks can automatically be approved, but I've
rarely used them.
No antivirus app could vet the EXCEL files, since it would have to examine
the code line by line to do so. And have a pretty sophisticated routine to
examine the code to find something malicious.
I am always very nervous about using workbooks with protected VBA code,
since you have no idea what they could be doing. However, I am pretty
trusting of things like ASAP and TA-Lib, just because of their nature and
exposure.
So if you are using workbooks from the FILES area that have macros, it's up
to you whether you will trust the author. I don't usually turn on the
macros, since I have my own processing that I do and don't need the
functions that those workbooks provide.
On Fri, Jul 19, 2013 at 9:55 AM, yjeffs1 <yjshaham@gmail.
> To use the files we need to enable the macros. In practically all cases
> they are safe. What confidence should we have in their being malware free
> 100% ? How do you prevent someone modifying existing files or uploading
> malicious file? Do the usual antivirus apps vet the Excel files? (Does
> MSE?)
>
Fri Jul 19, 2013 10:45 am (PDT) . Posted by:
"yjeffs1" yjeffs1
Randy,
Thank you for this reply. The dilemma comes up with the uploaded files that don't work without the macros.
If the files have a virus that acts immediately then the 1st person would be hit, but he (and you) will let us know. The problem comes with delayed action malware.
I am security nervous since in the last few days I have full page pop-up ads that I can't get rid of with reasonable search and effort.
Thank you for holding, carrying and leading this website.
BTW, a couple of files in the files directory are not found. Next time I will note them down.
Jeff
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You do NOT need to enable macros in order to use the add-in. By the very
> fact of you adding the add-in with the add-in manager, you've already given
> it all the security approval you need to. That in itself can be a leap of
> faith, but it is the reason I have open source code -- so anyone could look
> at it and see what's going on.
>
> My option is set to disable with notification. Then you can enable them on
> a case by case basis.
>
> There are other ways that workbooks can automatically be approved, but I've
> rarely used them.
>
> No antivirus app could vet the EXCEL files, since it would have to examine
> the code line by line to do so. And have a pretty sophisticated routine to
> examine the code to find something malicious.
>
> I am always very nervous about using workbooks with protected VBA code,
> since you have no idea what they could be doing. However, I am pretty
> trusting of things like ASAP and TA-Lib, just because of their nature and
> exposure.
>
> So if you are using workbooks from the FILES area that have macros, it's up
> to you whether you will trust the author. I don't usually turn on the
> macros, since I have my own processing that I do and don't need the
> functions that those workbooks provide.
>
> On Fri, Jul 19, 2013 at 9:55 AM, yjeffs1 <yjshaham@...> wrote:
>
> > To use the files we need to enable the macros. In practically all cases
> > they are safe. What confidence should we have in their being malware free
> > 100% ? How do you prevent someone modifying existing files or uploading
> > malicious file? Do the usual antivirus apps vet the Excel files? (Does
> > MSE?)
> >
>
Thank you for this reply. The dilemma comes up with the uploaded files that don't work without the macros.
If the files have a virus that acts immediately then the 1st person would be hit, but he (and you) will let us know. The problem comes with delayed action malware.
I am security nervous since in the last few days I have full page pop-up ads that I can't get rid of with reasonable search and effort.
Thank you for holding, carrying and leading this website.
BTW, a couple of files in the files directory are not found. Next time I will note them down.
Jeff
--- In smf_addin@yahoogrou
>
> You do NOT need to enable macros in order to use the add-in. By the very
> fact of you adding the add-in with the add-in manager, you've already given
> it all the security approval you need to. That in itself can be a leap of
> faith, but it is the reason I have open source code -- so anyone could look
> at it and see what's going on.
>
> My option is set to disable with notification. Then you can enable them on
> a case by case basis.
>
> There are other ways that workbooks can automatically be approved, but I've
> rarely used them.
>
> No antivirus app could vet the EXCEL files, since it would have to examine
> the code line by line to do so. And have a pretty sophisticated routine to
> examine the code to find something malicious.
>
> I am always very nervous about using workbooks with protected VBA code,
> since you have no idea what they could be doing. However, I am pretty
> trusting of things like ASAP and TA-Lib, just because of their nature and
> exposure.
>
> So if you are using workbooks from the FILES area that have macros, it's up
> to you whether you will trust the author. I don't usually turn on the
> macros, since I have my own processing that I do and don't need the
> functions that those workbooks provide.
>
> On Fri, Jul 19, 2013 at 9:55 AM, yjeffs1 <yjshaham@
>
> > To use the files we need to enable the macros. In practically all cases
> > they are safe. What confidence should we have in their being malware free
> > 100% ? How do you prevent someone modifying existing files or uploading
> > malicious file? Do the usual antivirus apps vet the Excel files? (Does
> > MSE?)
> >
>
Fri Jul 19, 2013 10:50 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's typically just a Yahoo temporary glitch. I usually just try again
later.
On Fri, Jul 19, 2013 at 10:45 AM, yjeffs1 <yjshaham@gmail.com > wrote:
> BTW, a couple of files in the files directory are not found. Next time I
> will note them down.
>
later.
On Fri, Jul 19, 2013 at 10:45 AM, yjeffs1 <yjshaham@gmail.
> BTW, a couple of files in the files directory are not found. Next time I
> will note them down.
>
Fri Jul 19, 2013 11:22 am (PDT) . Posted by:
"bablam" bablam
Hi,
I am getting errors for all smfgetelement() functions that use the field from the ADV/FN, i.e, all of the fields referenced in the smf-elements-7 file. I have tried re-installing the add-in, downloading the files again from the Group location, but same result.
All other fields work, from the other smf-elements-.. files, though.
Has anyone encountered this problem, and is there a workaround.
Thanks,
Manish
I am getting errors for all smfgetelement(
All other fields work, from the other smf-elements-
Has anyone encountered this problem, and is there a workaround.
Thanks,
Manish
Fri Jul 19, 2013 11:25 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Have you tried the fix mentioned in the LINKS area of the group?
On Fri, Jul 19, 2013 at 11:21 AM, bablam <mbabla@gmail.com > wrote:
>
> I am getting errors for all smfgetelement() functions that use the field
> from the ADV/FN, i.e, all of the fields referenced in the smf-elements-7
> file. I have tried re-installing the add-in, downloading the files again
> from the Group location, but same result.
>
> All other fields work, from the other smf-elements-.. files, though.
>
> Has anyone encountered this problem, and is there a workaround.
>
On Fri, Jul 19, 2013 at 11:21 AM, bablam <mbabla@gmail.
>
> I am getting errors for all smfgetelement(
> from the ADV/FN, i.e, all of the fields referenced in the smf-elements-
> file. I have tried re-installing the add-in, downloading the files again
> from the Group location, but same result.
>
> All other fields work, from the other smf-elements-
>
> Has anyone encountered this problem, and is there a workaround.
>
Fri Jul 19, 2013 12:35 pm (PDT) . Posted by:
"bablam" bablam
Hi Randy,
Thank you once again, for quickly pointing me to the right direction. Problem solved. With Gratitude,
Manish
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Have you tried the fix mentioned in the LINKS area of the group?
>
> On Fri, Jul 19, 2013 at 11:21 AM, bablam <mbabla@...> wrote:
>
> >
> > I am getting errors for all smfgetelement() functions that use the field
> > from the ADV/FN, i.e, all of the fields referenced in the smf-elements-7
> > file. I have tried re-installing the add-in, downloading the files again
> > from the Group location, but same result.
> >
> > All other fields work, from the other smf-elements-.. files, though.
> >
> > Has anyone encountered this problem, and is there a workaround.
> >
>
Thank you once again, for quickly pointing me to the right direction. Problem solved. With Gratitude,
Manish
--- In smf_addin@yahoogrou
>
> Have you tried the fix mentioned in the LINKS area of the group?
>
> On Fri, Jul 19, 2013 at 11:21 AM, bablam <mbabla@.
>
> >
> > I am getting errors for all smfgetelement(
> > from the ADV/FN, i.e, all of the fields referenced in the smf-elements-
> > file. I have tried re-installing the add-in, downloading the files again
> > from the Group location, but same result.
> >
> > All other fields work, from the other smf-elements-
> >
> > Has anyone encountered this problem, and is there a workaround.
> >
>
Fri Jul 19, 2013 11:42 am (PDT) . Posted by:
"ajtalukdar" ajtalukdar
Alcoa declared its results for the quarter ending June 2013 on the 8th of July. This is visible in Google Finance.
However, Advfn is still showing the March 13 qtr results as the latest quarterly result. The situation is the same for all other companies which I have mentioned earlier (and some more).
Does anyone know whether Advfn has stopped updating quarterly results on their site?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I just looked at Alcoa -- it is up-to-date. The most recent 10-Q was
> released on 4/18 for the quarter ending 3/31.
>
> What are you expecting to see?
>
> On Thu, Jul 18, 2013 at 12:06 PM, ajtalukdar <ajtalukdar@...> wrote:
>
> >
> > I have noticed that lately advfn quarterly data is not getting updated on
> > their website. Intiially I thought it was a problem with the add-in, but
> > found that the advfn site itself is where the problem is. For instance, the
> > quarterly data for none of the companies that have declared results this
> > quarter have beenn updated - e.g. Alcoa, Yum Brands, wells fargo etc..
> >
> > The quarterly reports of some stock from the previous quarter are also
> > pending - e.g. Oracle, Nike, Fedex, etc.
> >
> > Is anyone else facing this problem?
> >
>
However, Advfn is still showing the March 13 qtr results as the latest quarterly result. The situation is the same for all other companies which I have mentioned earlier (and some more).
Does anyone know whether Advfn has stopped updating quarterly results on their site?
--- In smf_addin@yahoogrou
>
> I just looked at Alcoa -- it is up-to-date. The most recent 10-Q was
> released on 4/18 for the quarter ending 3/31.
>
> What are you expecting to see?
>
> On Thu, Jul 18, 2013 at 12:06 PM, ajtalukdar <ajtalukdar@
>
> >
> > I have noticed that lately advfn quarterly data is not getting updated on
> > their website. Intiially I thought it was a problem with the add-in, but
> > found that the advfn site itself is where the problem is. For instance, the
> > quarterly data for none of the companies that have declared results this
> > quarter have beenn updated - e.g. Alcoa, Yum Brands, wells fargo etc..
> >
> > The quarterly reports of some stock from the previous quarter are also
> > pending - e.g. Oracle, Nike, Fedex, etc.
> >
> > Is anyone else facing this problem?
> >
>
Fri Jul 19, 2013 12:20 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
They may have ANNOUNCED the results, but they haven't filed the 10-Q yet.
At least it's not showing up on any SEC or Edgar searches I've done.
http://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&CIK=0000004281&owner=exclude&count=40&hidefilings=0
On Fri, Jul 19, 2013 at 11:42 AM, ajtalukdar <ajtalukdar@yahoo.com > wrote:
> Alcoa declared its results for the quarter ending June 2013 on the 8th of
> July. This is visible in Google Finance.
>
> However, Advfn is still showing the March 13 qtr results as the latest
> quarterly result. The situation is the same for all other companies which I
> have mentioned earlier (and some more).
>
> Does anyone know whether Advfn has stopped updating quarterly results on
> their site?
>
At least it's not showing up on any SEC or Edgar searches I've done.
http://www.sec.
On Fri, Jul 19, 2013 at 11:42 AM, ajtalukdar <ajtalukdar@yahoo.
> Alcoa declared its results for the quarter ending June 2013 on the 8th of
> July. This is visible in Google Finance.
>
> However, Advfn is still showing the March 13 qtr results as the latest
> quarterly result. The situation is the same for all other companies which I
> have mentioned earlier (and some more).
>
> Does anyone know whether Advfn has stopped updating quarterly results on
> their site?
>
Fri Jul 19, 2013 3:12 pm (PDT) . Posted by:
"John Bassett" johnbassett64
I am new to the group and think this is a cool tool. I am, however,
struggling with many of the examples. One of the messages I think should be
easily solveable. Can anyone help me with a compile error below?
struggling with many of the examples. One of the messages I think should be
easily solveable. Can anyone help me with a compile error below?
Fri Jul 19, 2013 3:12 pm (PDT) . Posted by:
"roger.donaldson" roger.donaldson
--- In smf_addin@yahoogrou
> I always use the smfForceRecalculati
> have it as a button on my Quick Access Toolbar.
>
Were is this macro located so it can be downloaded?
Tidak ada komentar:
Posting Komentar