8 New Messages
Digest #2373
Messages
Sat Oct 13, 2012 6:15 am (PDT) . Posted by:
"digsupply" digsupply
I have just downloaded the new file Templates and Examples/RCHGetWebData/RCHGetWebData-Template-BarChart-Quotes-Extract.xls and I noticed that when I get the data for 5, 10, 15 minutes and so on, only data for the last week comes up. In the previous version data for several weeks, up to 276 rows, appeared. I checked the Barchart webpage, and the information is there, as I can set up the data to be shown at 5 min intervals for the last 30 days. How can I extract this information using this template? Thank you in advance
http://www.barchart.com/chart.php?sym=AAPL&style=technical&template=&p=I&d=X&im=5&sd=09%2F26%2F2012&ed=10%2F12%2F2012&size=M&log=0&t=BAR&v=1&g=1&evnt=1&late=1&o1=&o2=&o3=&sh=100&indicators=&addindicator=&submitted=1&fpage=&txtDate=10%2F12%2F2012#jump
--- In smf_addin@yahoogroups.com , smf_addin@yahoogroups.com wrote:
>
>
> Hello,
>
> This email message is a notification to let you know that
> a file has been uploaded to the Files area of the smf_addin
> group.
>
> File : /Templates and Examples/RCHGetWebData/RCHGetWebData-Template-BarChart-Quotes-Extract.xls
> Uploaded by : rharmelink <rharmelink@...>
> Description : An updated template to show how the RCHGetWebData() function can be used to extract in-page quotes from a BarChart.com chart page, which has the historical data coded within the page. Since the data is not in an HTML table, it needs to be extracted in a cascading fashion, one following another. The BarChart.com chart page allows time intervals from 5-minute periods through monthly periods.
>
> You can access this file at the URL:
> http://groups.yahoo.com/group/smf_addin/files/Templates%20and%20Examples/RCHGetWebData/RCHGetWebData-Template-BarChart-Quotes-Extract.xls
>
> To learn more about file sharing for your group, please visit:
> http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.html
> Regards,
>
> rharmelink <rharmelink@...>
>
http://www.barchart
--- In smf_addin@yahoogrou
>
>
> Hello,
>
> This email message is a notification to let you know that
> a file has been uploaded to the Files area of the smf_addin
> group.
>
> File : /Templates and Examples/RCHGetWebD
> Uploaded by : rharmelink <rharmelink@
> Description : An updated template to show how the RCHGetWebData(
>
> You can access this file at the URL:
> http://groups.
>
> To learn more about file sharing for your group, please visit:
> http://help.
> Regards,
>
> rharmelink <rharmelink@
>
Sat Oct 13, 2012 10:11 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It looks like you overrode the "1 Week" setting by giving it a specific
starting date and ending date:
&sd=09/26/2012&ed=10/12/2012
I'm not sure how much data is actually available...
I also noted that the formula in D should be changed -- it currently
returns 200 bytes for each RCHGetWebData() function. It needs to be longer
for some dates, or it stops getting data.
On Sat, Oct 13, 2012 at 6:15 AM, digsupply <picsound@gmail.com > wrote:
> I have just downloaded the new file Templates and
> Examples/RCHGetWebData/RCHGetWebData-Template-BarChart-Quotes-Extract.xls
> and I noticed that when I get the data for 5, 10, 15 minutes and so on,
> only data for the last week comes up. In the previous version data for
> several weeks, up to 276 rows, appeared. I checked the Barchart webpage,
> and the information is there, as I can set up the data to be shown at 5 min
> intervals for the last 30 days. How can I extract this information using
> this template? Thank you in advance
>
>
> http://www.barchart.com/chart.php?sym=AAPL&style=technical&template=&p=I&d=X&im=5&sd=09%2F26%2F2012&ed=10%2F12%2F2012&size=M&log=0&t=BAR&v=1&g=1&evnt=1&late=1&o1=&o2=&o3=&sh=100&indicators=&addindicator=&submitted=1&fpage=&txtDate=10%2F12%2F2012#jump
>
starting date and ending date:
&sd=09/26/2012&
I'm not sure how much data is actually available...
I also noted that the formula in D should be changed -- it currently
returns 200 bytes for each RCHGetWebData(
for some dates, or it stops getting data.
On Sat, Oct 13, 2012 at 6:15 AM, digsupply <picsound@gmail.
> I have just downloaded the new file Templates and
> Examples/RCHGetWebD
> and I noticed that when I get the data for 5, 10, 15 minutes and so on,
> only data for the last week comes up. In the previous version data for
> several weeks, up to 276 rows, appeared. I checked the Barchart webpage,
> and the information is there, as I can set up the data to be shown at 5 min
> intervals for the last 30 days. How can I extract this information using
> this template? Thank you in advance
>
>
> http://www.barchart
>
Sat Oct 13, 2012 7:31 am (PDT) . Posted by:
"tenenbaum88" tenenbaum88
Hi Randy,
I'm getting a strange error with the above function.
I'm using: =smfGetADVFNElement(D1,"Q",1,"Total Common Shares Out")
Where D1 is the equity ticker.
This works with most tickers, however, it will return 'error' for others. Specifically, it does not work with "IBM" or "TGT". I've checked the ADVFN website and the data is there with the correct field headings for both IBM and Target. Any idea what might be causing this?
TIA
I'm getting a strange error with the above function.
I'm using: =smfGetADVFNElement
Where D1 is the equity ticker.
This works with most tickers, however, it will return 'error' for others. Specifically, it does not work with "IBM" or "TGT". I've checked the ADVFN website and the data is there with the correct field headings for both IBM and Target. Any idea what might be causing this?
TIA
Sat Oct 13, 2012 10:13 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not sure what to tell you -- both of these formulas work fine for me:
=smfGetADVFNElement("IBM","Q",1,"Total Common Shares Out")
=smfGetADVFNElement("TGT","Q",1,"Total Common Shares Out")
On Sat, Oct 13, 2012 at 7:31 AM, tenenbaum88 <kenneth.dooley@gmail.com >wrote:
>
> I'm getting a strange error with the above function.
>
> I'm using: =smfGetADVFNElement(D1,"Q",1,"Total Common Shares Out")
>
> Where D1 is the equity ticker.
>
> This works with most tickers, however, it will return 'error' for others.
> Specifically, it does not work with "IBM" or "TGT". I've checked the
> ADVFN website and the data is there with the correct field headings for
> both IBM and Target. Any idea what might be causing this?
>
=smfGetADVFNElement
=smfGetADVFNElement
On Sat, Oct 13, 2012 at 7:31 AM, tenenbaum88 <kenneth.dooley@
>
> I'm getting a strange error with the above function.
>
> I'm using: =smfGetADVFNElement
>
> Where D1 is the equity ticker.
>
> This works with most tickers, however, it will return 'error' for others.
> Specifically, it does not work with "IBM" or "TGT". I've checked the
> ADVFN website and the data is there with the correct field headings for
> both IBM and Target. Any idea what might be causing this?
>
Sat Oct 13, 2012 8:31 pm (PDT) . Posted by:
"tenenbaum88" tenenbaum88
Even stranger, when I opened the spreadsheet this morning, the morfula would not work with any ticker. Any call using the smfGetADVFNElement function now just returns 'Error'. Could this be a problem with my internet connection? The other smf functions are working fine.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Not sure what to tell you -- both of these formulas work fine for me:
>
> =smfGetADVFNElement("IBM","Q",1,"Total Common Shares Out")
> =smfGetADVFNElement("TGT","Q",1,"Total Common Shares Out")
>
> On Sat, Oct 13, 2012 at 7:31 AM, tenenbaum88 <kenneth.dooley@...>wrote:
>
> >
> > I'm getting a strange error with the above function.
> >
> > I'm using: =smfGetADVFNElement(D1,"Q",1,"Total Common Shares Out")
> >
> > Where D1 is the equity ticker.
> >
> > This works with most tickers, however, it will return 'error' for others.
> > Specifically, it does not work with "IBM" or "TGT". I've checked the
> > ADVFN website and the data is there with the correct field headings for
> > both IBM and Target. Any idea what might be causing this?
> >
>
--- In smf_addin@yahoogrou
>
> Not sure what to tell you -- both of these formulas work fine for me:
>
> =smfGetADVFNElement
> =smfGetADVFNElement
>
> On Sat, Oct 13, 2012 at 7:31 AM, tenenbaum88 <kenneth.dooley@
>
> >
> > I'm getting a strange error with the above function.
> >
> > I'm using: =smfGetADVFNElement
> >
> > Where D1 is the equity ticker.
> >
> > This works with most tickers, however, it will return 'error' for others.
> > Specifically, it does not work with "IBM" or "TGT". I've checked the
> > ADVFN website and the data is there with the correct field headings for
> > both IBM and Target. Any idea what might be causing this?
> >
>
Sat Oct 13, 2012 10:02 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Are you located outside of the USA -- if you go to www.advfn.com, do you
get redirected to a different domain?
Also, check out the AdvFN entry in the LINKS area of the group.
On Sat, Oct 13, 2012 at 8:31 PM, tenenbaum88 <kenneth.dooley@gmail.com >wrote:
> Even stranger, when I opened the spreadsheet this morning, the morfula
> would not work with any ticker. Any call using the smfGetADVFNElement
> function now just returns 'Error'. Could this be a problem with my
> internet connection? The other smf functions are working fine.
>
get redirected to a different domain?
Also, check out the AdvFN entry in the LINKS area of the group.
On Sat, Oct 13, 2012 at 8:31 PM, tenenbaum88 <kenneth.dooley@
> Even stranger, when I opened the spreadsheet this morning, the morfula
> would not work with any ticker. Any call using the smfGetADVFNElement
> function now just returns 'Error'. Could this be a problem with my
> internet connection? The other smf functions are working fine.
>
Sat Oct 13, 2012 11:04 pm (PDT) . Posted by:
"tenenbaum88" tenenbaum88
I am outside the US, but I am normally directed to the 'www' version of the website, not the 'uk' version. I'll check the links section and come back if make some progress. Thanks, Randy.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Are you located outside of the USA -- if you go to www.advfn.com, do you
> get redirected to a different domain?
>
> Also, check out the AdvFN entry in the LINKS area of the group.
>
> On Sat, Oct 13, 2012 at 8:31 PM, tenenbaum88 <kenneth.dooley@...>wrote:
>
> > Even stranger, when I opened the spreadsheet this morning, the morfula
> > would not work with any ticker. Any call using the smfGetADVFNElement
> > function now just returns 'Error'. Could this be a problem with my
> > internet connection? The other smf functions are working fine.
> >
>
--- In smf_addin@yahoogrou
>
> Are you located outside of the USA -- if you go to www.advfn.com, do you
> get redirected to a different domain?
>
> Also, check out the AdvFN entry in the LINKS area of the group.
>
> On Sat, Oct 13, 2012 at 8:31 PM, tenenbaum88 <kenneth.dooley@
>
> > Even stranger, when I opened the spreadsheet this morning, the morfula
> > would not work with any ticker. Any call using the smfGetADVFNElement
> > function now just returns 'Error'. Could this be a problem with my
> > internet connection? The other smf functions are working fine.
> >
>
Sat Oct 13, 2012 11:09 pm (PDT) . Posted by:
"tenenbaum88" tenenbaum88
I tried the fix posted in this link:
http://finance.groups.yahoo.com/group/smf_addin/message/10464
and all is working now. Thanks again, Randy!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Are you located outside of the USA -- if you go to www.advfn.com, do you
> get redirected to a different domain?
>
> Also, check out the AdvFN entry in the LINKS area of the group.
>
> On Sat, Oct 13, 2012 at 8:31 PM, tenenbaum88 <kenneth.dooley@...>wrote:
>
> > Even stranger, when I opened the spreadsheet this morning, the morfula
> > would not work with any ticker. Any call using the smfGetADVFNElement
> > function now just returns 'Error'. Could this be a problem with my
> > internet connection? The other smf functions are working fine.
> >
>
http://finance.
and all is working now. Thanks again, Randy!
--- In smf_addin@yahoogrou
>
> Are you located outside of the USA -- if you go to www.advfn.com, do you
> get redirected to a different domain?
>
> Also, check out the AdvFN entry in the LINKS area of the group.
>
> On Sat, Oct 13, 2012 at 8:31 PM, tenenbaum88 <kenneth.dooley@
>
> > Even stranger, when I opened the spreadsheet this morning, the morfula
> > would not work with any ticker. Any call using the smfGetADVFNElement
> > function now just returns 'Error'. Could this be a problem with my
> > internet connection? The other smf functions are working fine.
> >
>
Tidak ada komentar:
Posting Komentar