8 New Messages
Digest #2824
Messages
Tue Oct 22, 2013 1:30 pm (PDT) . Posted by:
nuno.quental
Hello!
Is it possible to download intraday 1 min data?
Thanks!
Is it possible to download intraday 1 min data?
Thanks!
Tue Oct 22, 2013 1:39 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It would all depend on the source of the data and how they present/provide
it.
I don't know of such a source.
On Tue, Oct 22, 2013 at 1:22 PM, <quental.nuno@gmail.com> wrote:
>
> Is it possible to download intraday 1 min data?
>
it.
I don't know of such a source.
On Tue, Oct 22, 2013 at 1:22 PM, <quental.nuno@
>
> Is it possible to download intraday 1 min data?
>
Tue Oct 22, 2013 1:39 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You look like you're grabbing a lot of data. The add-in has a built in
limit of being able to access only 1000 web pages per "session". Anything
further returns "Error" values. The add-in is designed for ad hoc usage. I
don't really want people overusing the free data sources, since they can
rewrite their web pages so that the add-in can't access the data.
That must take a long time to load.
We've also had instances of individuals being shut down because of too many
accesses to data for a particular web site (e.g. Zacks). Presumably based
on IP address.
Have you looked at what FinViz can provide? You can can a large number of
data items for all the stocks they have, with a single Internet access. See
the LINKS area of the group for more information.
On Tue, Oct 22, 2013 at 12:50 PM, Liyang Chen <lchen257@yahoo.ca> wrote:
>
> The first 5 columns are hard coded so no problem there, 6th column
> is =RCHGetElementNumber(A3,941) and it worked for the entire column before
> closing and now it shows all errors. the "P/E" column still works though,
> and it is using =RCHGetYahooQuotes(A3,"r",,"NOW()")
>
>
limit of being able to access only 1000 web pages per "session"
further returns "Error" values. The add-in is designed for ad hoc usage. I
don't really want people overusing the free data sources, since they can
rewrite their web pages so that the add-in can't access the data.
That must take a long time to load.
We've also had instances of individuals being shut down because of too many
accesses to data for a particular web site (e.g. Zacks). Presumably based
on IP address.
Have you looked at what FinViz can provide? You can can a large number of
data items for all the stocks they have, with a single Internet access. See
the LINKS area of the group for more information.
On Tue, Oct 22, 2013 at 12:50 PM, Liyang Chen <lchen257@yahoo.
>
> The first 5 columns are hard coded so no problem there, 6th column
> is =RCHGetElementNumbe
> closing and now it shows all errors. the "P/E" column still works though,
> and it is using =RCHGetYahooQuotes(
>
>
Tue Oct 22, 2013 2:21 pm (PDT) . Posted by:
"Liyang Chen" lchen257
That's probably why then, exceeded the limit.
Didn't know that they put restrictions on the amount of data people can access.
I shall check out Finviz.
Thanks,
LY
On Tuesday, October 22, 2013 4:38 PM, Randy Harmelink <rharmelink@gmail.com> wrote:
You look like you're grabbing a lot of data. The add-in has a built in limit of being able to access only 1000 web pages per "session". Anything further returns "Error" values. The add-in is designed for ad hoc usage. I don't really want people overusing the free data sources, since they can rewrite their web pages so that the add-in can't access the data.
That must take a long time to load.
We've also had instances of individuals being shut down because of too many accesses to data for a particular web site (e.g. Zacks). Presumably based on IP address.
Have you looked at what FinViz can provide? You can can a large number of data items for all the stocks they have, with a single Internet access. See the LINKS area of the group for more information.
On Tue, Oct 22, 2013 at 12:50 PM, Liyang Chen <lchen257@yahoo.ca> wrote:
>
>The first 5 columns are hard coded so no problem there, 6th column is =RCHGetElementNumber(A3,941) and it worked for the entire column before closing and now it shows all errors. the "P/E" column still works though, and it is using =RCHGetYahooQuotes(A3,"r",,"NOW()")
>
Didn't know that they put restrictions on the amount of data people can access.
I shall check out Finviz.
Thanks,
LY
On Tuesday, October 22, 2013 4:38 PM, Randy Harmelink <rharmelink@gmail.
You look like you're grabbing a lot of data. The add-in has a built in limit of being able to access only 1000 web pages per "session"
That must take a long time to load.
We've also had instances of individuals being shut down because of too many accesses to data for a particular web site (e.g. Zacks). Presumably based on IP address.
Have you looked at what FinViz can provide? You can can a large number of data items for all the stocks they have, with a single Internet access. See the LINKS area of the group for more information.
On Tue, Oct 22, 2013 at 12:50 PM, Liyang Chen <lchen257@yahoo.
>
>The first 5 columns are hard coded so no problem there, 6th column is =RCHGetElementNum
>
Tue Oct 22, 2013 3:52 pm (PDT) . Posted by:
"Liyang Chen" lchen257
Hi Randy,
the RCHGetTableCell(finviz) solution works very well.
I was wondering if I do retrieve a substantial amount of data, does it help that i am accessing with a single internet access?
don't want to get banned because I really do like this add-in!
Regards,
LY
On Tuesday, October 22, 2013 5:21 PM, Liyang Chen <lchen257@yahoo.ca> wrote:
That's probably why then, exceeded the limit.
Didn't know that they put restrictions on the amount of data people can access.
I shall check out Finviz.
Thanks,
LY
On Tuesday, October 22, 2013 4:38 PM, Randy Harmelink <rharmelink@gmail.com> wrote:
You look like you're grabbing a lot of data. The add-in has a built in limit of being able to access only 1000 web pages per "session". Anything further returns "Error" values. The add-in is designed for ad hoc usage. I don't really want people overusing the free data sources, since they can rewrite their web pages so that the add-in can't access the data.
That must take a long time to load.
We've also had instances of individuals being shut down because of too many accesses to data for a particular web site (e.g. Zacks). Presumably based on IP address.
Have you looked at what FinViz can provide? You can can a large number of data items for all the stocks they have, with a single Internet access. See the LINKS area of the group for more information.
On Tue, Oct 22, 2013 at 12:50 PM, Liyang Chen <lchen257@yahoo.ca> wrote:
>
>The first 5 columns are hard coded so no problem there, 6th column is =RCHGetElementNumber(A3,941) and it worked for the entire column before closing and now it shows all errors. the "P/E" column still works though, and it is using =RCHGetYahooQuotes(A3,"r",,"NOW()")
>
the RCHGetTableCell(
I was wondering if I do retrieve a substantial amount of data, does it help that i am accessing with a single internet access?
don't want to get banned because I really do like this add-in!
Regards,
LY
On Tuesday, October 22, 2013 5:21 PM, Liyang Chen <lchen257@yahoo.
That's probably why then, exceeded the limit.
Didn't know that they put restrictions on the amount of data people can access.
I shall check out Finviz.
Thanks,
LY
On Tuesday, October 22, 2013 4:38 PM, Randy Harmelink <rharmelink@gmail.
You look like you're grabbing a lot of data. The add-in has a built in limit of being able to access only 1000 web pages per "session"
That must take a long time to load.
We've also had instances of individuals being shut down because of too many accesses to data for a particular web site (e.g. Zacks). Presumably based on IP address.
Have you looked at what FinViz can provide? You can can a large number of data items for all the stocks they have, with a single Internet access. See the LINKS area of the group for more information.
On Tue, Oct 22, 2013 at 12:50 PM, Liyang Chen <lchen257@yahoo.
>
>The first 5 columns are hard coded so no problem there, 6th column is =RCHGetElementNum
>
Tue Oct 22, 2013 4:22 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It would be the number of accesses, I would think.
It hasn't happened very often.
I do know that investors.com has a limit to how many stock checkup you can
run in a 24-hour period (300 or 400 I think). Not sure how they enforce it.
IMO, the best way to use the add-in is to use the free screening services
to get down to a manageable set of ticker symbols. Then use the add-in to
get more detail on that set of companies.
On Tue, Oct 22, 2013 at 3:49 PM, Liyang Chen <lchen257@yahoo.ca> wrote:
>
> the RCHGetTableCell(finviz) solution works very well.
>
> I was wondering if I do retrieve a substantial amount of data, does it
> help that i am accessing with a single internet access?
>
> don't want to get banned because I really do like this add-in!
>
>
It hasn't happened very often.
I do know that investors.com has a limit to how many stock checkup you can
run in a 24-hour period (300 or 400 I think). Not sure how they enforce it.
IMO, the best way to use the add-in is to use the free screening services
to get down to a manageable set of ticker symbols. Then use the add-in to
get more detail on that set of companies.
On Tue, Oct 22, 2013 at 3:49 PM, Liyang Chen <lchen257@yahoo.
>
> the RCHGetTableCell(
>
> I was wondering if I do retrieve a substantial amount of data, does it
> help that i am accessing with a single internet access?
>
> don't want to get banned because I really do like this add-in!
>
>
Tue Oct 22, 2013 9:01 pm (PDT) . Posted by:
boo1712
Dear Randy,
Much of the problem with advfn is it is hard to automatically choose the exchanges for each ticker.
If we change the advfn function to something like =smfGetADVFNElement("NYSE";,"MMM";,"A",1,">Year End Date")
much of the problem can be solved.
Much of the problem with advfn is it is hard to automatically choose the exchanges for each ticker.
If we change the advfn function to something like =smfGetADVFNElement
much of the problem can be solved.
Tue Oct 22, 2013 9:17 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It looks up the exchange right now. However, I had considered adding it as
an optional parameter. If passed as a parameter, it could skip the lookup
step and just used the passed value.
But, right now, I have no issues with the AdvFN elements. It's the regional
redirections that are an issue.
On Tue, Oct 22, 2013 at 9:01 PM, <boo1712@yahoo.co.uk> wrote:
> Much of the problem with advfn is it is hard to automatically choose the
> exchanges for each ticker.
>
> If we change the advfn function to something like
> =smfGetADVFNElement("NYSE";,"MMM";,"A",1,">Year End Date")
>
> much of the problem can be solved.
>
an optional parameter. If passed as a parameter, it could skip the lookup
step and just used the passed value.
But, right now, I have no issues with the AdvFN elements. It's the regional
redirections that are an issue.
On Tue, Oct 22, 2013 at 9:01 PM, <boo1712@yahoo.
> Much of the problem with advfn is it is hard to automatically choose the
> exchanges for each ticker.
>
> If we change the advfn function to something like
> =smfGetADVFNElement
>
> much of the problem can be solved.
>
Tidak ada komentar:
Posting Komentar