6 Messages
Digest #3523
Messages
Fri Sep 25, 2015 8:02 am (PDT) . Posted by:
"Bryan" ilmostro
Randy,
thanks for all you do.
Is there a way to enter a list of tickers into the IBD template instead of
having to look at just 1 ticker at a time?
Bryan
thanks for all you do.
Is there a way to enter a list of tickers into the IBD template instead of
having to look at just 1 ticker at a time?
Bryan
Fri Sep 25, 2015 8:10 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm not aware of a way that they allow bulk downloading of data, unless you
count the e-Tables. You can certainly utilize the formulas in the template
to create your own that does multiple tickers. But data retrieval would
still by done on a per ticker basis.
Be sure not to go over the limit on number of checkup retrievals. I think
the terms of service limit you to 300 or 400 within a 24-hour period.
On Fri, Sep 25, 2015 at 8:02 AM, Bryan ilmostrobtw@... wrote:
>
> Is there a way to enter a list of tickers into the IBD template instead of
> having to look at just 1 ticker at a time?
>
>
>
count the e-Tables. You can certainly utilize the formulas in the template
to create your own that does multiple tickers. But data retrieval would
still by done on a per ticker basis.
Be sure not to go over the limit on number of checkup retrievals. I think
the terms of service limit you to 300 or 400 within a 24-hour period.
On Fri, Sep 25, 2015 at 8:02 AM, Bryan ilmostrobtw@
>
> Is there a way to enter a list of tickers into the IBD template instead of
> having to look at just 1 ticker at a time?
>
>
>
Fri Sep 25, 2015 8:21 am (PDT) . Posted by:
"Bryan" ilmostro
Randy,
Before IBD and the template changed I was able to use the formulas to
create a spreadsheet that allowed me to enter 20 symbols and see the IBD
data on all 20 symbols at once.
I ain't having any luck at all changing the current template to allow this.
I will keep plugging away at it but if someone has already done it or knows
how to do it I would appreciate any advice.
Thanks,
Bryan
On Fri, Sep 25, 2015 at 10:10 AM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> I'm not aware of a way that they allow bulk downloading of data, unless
> you count the e-Tables. You can certainly utilize the formulas in the
> template to create your own that does multiple tickers. But data retrieval
> would still by done on a per ticker basis.
>
> Be sure not to go over the limit on number of checkup retrievals. I think
> the terms of service limit you to 300 or 400 within a 24-hour period.
>
> On Fri, Sep 25, 2015 at 8:02 AM, Bryan ilmostrobtw@... wrote:
>
>>
>> Is there a way to enter a list of tickers into the IBD template instead
>> of having to look at just 1 ticker at a time?
>>
>>
>>
>
>
Before IBD and the template changed I was able to use the formulas to
create a spreadsheet that allowed me to enter 20 symbols and see the IBD
data on all 20 symbols at once.
I ain't having any luck at all changing the current template to allow this.
I will keep plugging away at it but if someone has already done it or knows
how to do it I would appreciate any advice.
Thanks,
Bryan
On Fri, Sep 25, 2015 at 10:10 AM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> I'm not aware of a way that they allow bulk downloading of data, unless
> you count the e-Tables. You can certainly utilize the formulas in the
> template to create your own that does multiple tickers. But data retrieval
> would still by done on a per ticker basis.
>
> Be sure not to go over the limit on number of checkup retrievals. I think
> the terms of service limit you to 300 or 400 within a 24-hour period.
>
> On Fri, Sep 25, 2015 at 8:02 AM, Bryan ilmostrobtw@
>
>>
>> Is there a way to enter a list of tickers into the IBD template instead
>> of having to look at just 1 ticker at a time?
>>
>>
>>
>
>
Fri Sep 25, 2015 8:47 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Attached is a quick example. You just need to create a worker column that
builds the URL for each ticker. Then, each formula from the original
template can just use that URL, on a per line basis, instead of a per
worksheet basis. Note that I created a range name of URLCheckup on the new
worksheet (relative to column in the same row), so formulas can be copied
without needing to change them. You will get a popup message from EXCEL
asking whether to use the range name in the new sheet, or from the old
sheet. Just indicate you want the copied formula to use the range name in
the new sheet.
On Fri, Sep 25, 2015 at 8:21 AM, Bryan ilmostrobtw@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Before IBD and the template changed I was able to use the formulas to
> create a spreadsheet that allowed me to enter 20 symbols and see the IBD
> data on all 20 symbols at once.
>
> I ain't having any luck at all changing the current template to allow
> this. I will keep plugging away at it but if someone has already done it or
> knows how to do it I would appreciate any advice.
>
>
builds the URL for each ticker. Then, each formula from the original
template can just use that URL, on a per line basis, instead of a per
worksheet basis. Note that I created a range name of URLCheckup on the new
worksheet (relative to column in the same row), so formulas can be copied
without needing to change them. You will get a popup message from EXCEL
asking whether to use the range name in the new sheet, or from the old
sheet. Just indicate you want the copied formula to use the range name in
the new sheet.
On Fri, Sep 25, 2015 at 8:21 AM, Bryan ilmostrobtw@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Before IBD and the template changed I was able to use the formulas to
> create a spreadsheet that allowed me to enter 20 symbols and see the IBD
> data on all 20 symbols at once.
>
> I ain't having any luck at all changing the current template to allow
> this. I will keep plugging away at it but if someone has already done it or
> knows how to do it I would appreciate any advice.
>
>
Attachment(s) from Randy Harmelink
1 of 1 File(s)
Fri Sep 25, 2015 9:01 am (PDT) . Posted by:
"Bryan" ilmostro
Thanks so much Randy!
You are a gem, and I don't mean one like an amethyst.
Bryan
On Fri, Sep 25, 2015 at 10:47 AM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> [Attachment(s) <#1500530179661e77_TopText> from Randy Harmelink included
> below]
>
> Attached is a quick example. You just need to create a worker column that
> builds the URL for each ticker. Then, each formula from the original
> template can just use that URL, on a per line basis, instead of a per
> worksheet basis. Note that I created a range name of URLCheckup on the new
> worksheet (relative to column in the same row), so formulas can be copied
> without needing to change them. You will get a popup message from EXCEL
> asking whether to use the range name in the new sheet, or from the old
> sheet. Just indicate you want the copied formula to use the range name in
> the new sheet.
>
> On Fri, Sep 25, 2015 at 8:21 AM, Bryan ilmostrobtw@gmail.com [smf_addin] <
> smf_addin@yahoogroups.com> wrote:
>
>>
>> Before IBD and the template changed I was able to use the formulas to
>> create a spreadsheet that allowed me to enter 20 symbols and see the IBD
>> data on all 20 symbols at once.
>>
>> I ain't having any luck at all changing the current template to allow
>> this. I will keep plugging away at it but if someone has already done it or
>> knows how to do it I would appreciate any advice.
>>
>>
>
>
You are a gem, and I don't mean one like an amethyst.
Bryan
On Fri, Sep 25, 2015 at 10:47 AM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> [Attachment(s) <#1500530179661e77_TopText> from Randy Harmelink included
> below]
>
> Attached is a quick example. You just need to create a worker column that
> builds the URL for each ticker. Then, each formula from the original
> template can just use that URL, on a per line basis, instead of a per
> worksheet basis. Note that I created a range name of URLCheckup on the new
> worksheet (relative to column in the same row), so formulas can be copied
> without needing to change them. You will get a popup message from EXCEL
> asking whether to use the range name in the new sheet, or from the old
> sheet. Just indicate you want the copied formula to use the range name in
> the new sheet.
>
> On Fri, Sep 25, 2015 at 8:21 AM, Bryan ilmostrobtw@gmail.com [smf_addin] <
> smf_addin@yahoogroups.com> wrote:
>
>>
>> Before IBD and the template changed I was able to use the formulas to
>> create a spreadsheet that allowed me to enter 20 symbols and see the IBD
>> data on all 20 symbols at once.
>>
>> I ain't having any luck at all changing the current template to allow
>> this. I will keep plugging away at it but if someone has already done it or
>> knows how to do it I would appreciate any advice.
>>
>>
>
>
Fri Sep 25, 2015 10:29 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
FYI -- I just uploaded the following items to the "Works in Progress" page
on the SMF add-in website:
FilenameSizeLast ModifiedDescription 0-Change-log.html
<http://ogres-crypt.com/SMF/Works-In-Progress/0-Change-log.html>906486
2015-09-25 10:00 AM
Log of changes made to the add-in or other files.
RCHGetElementNumber-Element-Definitions.xls
<http://ogres-crypt.com/SMF/Works-In-Progress/RCHGetElementNumber-Element-Definitions.xls>
3024384
2015-09-25 10:00 AM
Documentation of element definitions, as of 2015-09-25
RCHGetElementNumber-Template-IBD-Stock-Checkup.xls
<http://ogres-crypt.com/SMF/Works-In-Progress/RCHGetElementNumber-Template-IBD-Stock-Checkup.xls>
906486
2015-09-25 10:00 AM
Template for new IBD element numbers, #2001-2085 smf-elements-9.txt
<http://ogres-crypt.com/SMF/Works-In-Progress/smf-elements-9.txt>43685
2015-09-25 10:00 AM
Fixed elements #701-703/709/715; Added elements #718-721
Fixed elements #1195-1214 (Barchart Momentum)
Added IBD elements #2001-2085
on the SMF add-in website:
FilenameSizeLast ModifiedDescription 0-Change-log.html
<http://ogres-crypt.com/SMF/Works-In-Progress/0-Change-log.html>906486
2015-09-25 10:00 AM
Log of changes made to the add-in or other files.
RCHGetElementNumber-Element-Definitions.xls
<http://ogres-crypt.com/SMF/Works-In-Progress/RCHGetElementNumber-Element-Definitions.xls>
3024384
2015-09-25 10:00 AM
Documentation of element definitions, as of 2015-09-25
RCHGetElementNumber-Template-IBD-Stock-Checkup.xls
<http://ogres-crypt.com/SMF/Works-In-Progress/RCHGetElementNumber-Template-IBD-Stock-Checkup.xls>
906486
2015-09-25 10:00 AM
Template for new IBD element numbers, #2001-2085 smf-elements-9.txt
<http://ogres-crypt.com/SMF/Works-In-Progress/smf-elements-9.txt>43685
2015-09-25 10:00 AM
Fixed elements #701-703/709/
Fixed elements #1195-1214 (Barchart Momentum)
Added IBD elements #2001-2085
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar