15 Messages
Digest #4024
2c
Re: Update on Yahoo Historical Quotes (as of 2017-05-21) [1 Attachme by "Randy Harmelink" rharmelink
Messages
Mon May 22, 2017 10:34 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32237
On Mon, May 22, 2017 at 10:11 AM, lewglenn@
...wrote:
>
> What's the url for the 5/21 version?
>
> __._
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32237
On Mon, May 22, 2017 at 10:11 AM, lewglenn@
...wrote:
>
> What's the url for the 5/21 version?
>
> __._
>
Mon May 22, 2017 2:26 pm (PDT) . Posted by:
brad.reel
Randy - I really hate asking this because I know you've been busting your tail for the last couple of weeks dealing with issues, etc. I really like the information in your 50 day screener example and was hoping to recreate and use. I've poked all around BarChart trying to figure out how to recreate with zero luck. I am a free member and maybe that's a premium feature. Can you either point me at a URL or maybe confirm if you use paid service?
Thanks again for everything. You are awesome.
Thanks again for everything. You are awesome.
Mon May 22, 2017 3:43 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
T
he screening I did on barchart.com was not a premium feature. All I have
is a free account. I did need to logon into the account, using the EXCEL
Query dialog, before I could use smfGetCSVFile() to grab the screener
output in EXCEL, but that's independent of using the screener in a browser.
I logged out to see what steps I needed to go through.
1. I click on the "My Barchart" banner option and choose "Organize
Screeners".
2. It prompts me to log in to my free account, so I do.
Voila, I'm there.
Note that "screens" and "views" are separately defined, so you will have to
create your own custom view as well as whatever screening you want to do.
They have so many choices of fields to display. However, I think the view
is limited to 12 fields? Not sure.
The free account has limits of 10 exports a day and 1000 tickers per
export.
On Mon, May 22, 2017 at 2:26 PM, brad.reel@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Randy - I really hate asking this because I know you've been busting your
> tail for the last couple of weeks dealing with issues, etc. I really like
> the information in your 50 day screener example and was hoping to recreate
> and use. I've poked all around BarChart trying to figure out how to
> recreate with zero luck. I am a free member and maybe that's a premium
> feature. Can you either point me at a URL or maybe confirm if you use paid
> service?
>
> Thanks again for everything. You are awesome.
>
>
he screening I did on barchart.com was not a premium feature. All I have
is a free account. I did need to logon into the account, using the EXCEL
Query dialog, before I could use smfGetCSVFile() to grab the screener
output in EXCEL, but that's independent of using the screener in a browser.
I logged out to see what steps I needed to go through.
1. I click on the "My Barchart" banner option and choose "Organize
Screeners".
2. It prompts me to log in to my free account, so I do.
Voila, I'm there.
Note that "screens" and "views" are separately defined, so you will have to
create your own custom view as well as whatever screening you want to do.
They have so many choices of fields to display. However, I think the view
is limited to 12 fields? Not sure.
The free account has limits of 10 exports a day and 1000 tickers per
export.
On Mon, May 22, 2017 at 2:26 PM, brad.reel@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Randy - I really hate asking this because I know you've been busting your
> tail for the last couple of weeks dealing with issues, etc. I really like
> the information in your 50 day screener example and was hoping to recreate
> and use. I've poked all around BarChart trying to figure out how to
> recreate with zero luck. I am a free member and maybe that's a premium
> feature. Can you either point me at a URL or maybe confirm if you use paid
> service?
>
> Thanks again for everything. You are awesome.
>
>
Mon May 22, 2017 3:15 pm (PDT) . Posted by:
a3306b6221c9729d4baefc364b31b9ca
Getting into an infinite loop during an spreadsheet update. Here is a screen capture of the breakpoint in VBA. Let me know if further debugger output is needed.
Attachment(s) from
1 of 1 Photo(s)
Mon May 22, 2017 3:32 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I assume you have the aSynchronous processing enabled.
How do you know it's in an infinite loop? What is the value of
oHTTP.ReadyState? It really can't continue until it's been told the
processing is done. What function invocation did you use?
On Mon, May 22, 2017 at 2:34 PM, leon.bodzin@
...wrote:
> Getting into an infinite loop during an spreadsheet update. Here is a
> screen capture of the breakpoint in VBA. Let me know if further debugger
> output is needed.
>
>
How do you know it's in an infinite loop? What is the value of
oHTTP.ReadyState? It really can't continue until it's been told the
processing is done. What function invocation did you use?
On Mon, May 22, 2017 at 2:34 PM, leon.bodzin@
...wrote:
> Getting into an infinite loop during an spreadsheet update. Here is a
> screen capture of the breakpoint in VBA. Let me know if further debugger
> output is needed.
>
>
Mon May 22, 2017 11:29 am (PDT) . Posted by:
eremon9
Randy—you may have noticed this already, but the closing price arrays include today's current price when the ending date is set to Today().
Tom
Tom
Mon May 22, 2017 3:40 pm (PDT) . Posted by:
eremon9
Randy—I notice a discontinuity in the unadjusted closing price for SNY between 9/27/13 ($10.15 / share) and 9/30/13 ($50.63 / share). I'm unable to find any split info that might explain it.
Tom
Tom
Mon May 22, 2017 11:44 am (PDT) . Posted by:
"Jose Jacob" pepecan47
Hello Randy, first of all you are amazing, thank you very much for all you do for us.
What are the new formulas with the latest changes?
Dividend History
=RCHGetYahooHistory(A2,,,,,,,"v")
Price Historry
=RCHGetYahooHistory(A1,,,,,,,,"DA",1,1)
Dividend History
=RCHGetYahooHistory(A1,,,,,,,"v",,,,1)
Latest Dividend
=INDEX(RCHGetYahooHistory(A13,,,,,,,"v",,0,,,1,2),1,2)
Second Latest Dividend
=INDEX(RCHGetYahooHistory(A13,,,,,,,"v",,0,,,2,2),2,2)
Second Latest Dividend
=INDEX(RCHGetYahooHistory(A14,,,,,,,"v",,0,,,3,2),3,2)
Regards, Jose L. Jacob
What are the new formulas with the latest changes?
Dividend History
=RCHGetYahooHistory
Price Historry
=RCHGetYahooHistory
Dividend History
=RCHGetYahooHistory
Latest Dividend
=INDEX(RCHGetYahooH
Second Latest Dividend
=INDEX(RCHGetYahooH
Second Latest Dividend
=INDEX(RCHGetYahooH
Regards, Jose L. Jacob
Mon May 22, 2017 12:15 pm (PDT) . Posted by:
"Wasi"
Hi,
I have download the new version of smf addin. But still I am getting errors, like "Name" I have confirmed that the addin is installed though.
Any suggestions?
Thanks
wasi
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, May 22, 2017 1:14 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Replace RCHGetYahooHistory call
See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32237
On Mon, May 22, 2017 at 10:11 AM, lewglenn@
...wrote:
What's the url for the 5/21 version?
__._
I have download the new version of smf addin. But still I am getting errors, like "Name" I have confirmed that the addin is installed though.
Any suggestions?
Thanks
wasi
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, May 22, 2017 1:14 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Replace RCHGetYahooHistory call
See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32237
On Mon, May 22, 2017 at 10:11 AM, lewglenn@
...wrote:
What's the url for the 5/21 version?
__._
Mon May 22, 2017 12:25 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
So what did you get with:
=RCHGetElementNumber("Version")
What formula are you getting #NAME? results for?
On Mon, May 22, 2017 at 12:10 PM, 'Wasi' wasi.rahim@
...wrote:
>
> I have download the new version of smf addin. But still I am getting
> errors, like "Name" I have confirmed that the addin is installed though.
>
>
>
> Any suggestions?
>
>
>
> Thanks
>
> wasi
>
>
>
> *From:* smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
> *Sent:* Monday, May 22, 2017 1:14 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* Re: [smf_addin] Re: Replace RCHGetYahooHistory call
>
>
>
>
>
> See:
>
> https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32237
>
>
>
> On Mon, May 22, 2017 at 10:11 AM, lewglenn@
>
> ...wrote:
>
>
> What's the url for the 5/21 version?
>
>
=RCHGetElementNumber("Version")
What formula are you getting #NAME? results for?
On Mon, May 22, 2017 at 12:10 PM, 'Wasi' wasi.rahim@
...wrote:
>
> I have download the new version of smf addin. But still I am getting
> errors, like "Name" I have confirmed that the addin is installed though.
>
>
>
> Any suggestions?
>
>
>
> Thanks
>
> wasi
>
>
>
> *From:* smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
> *Sent:* Monday, May 22, 2017 1:14 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* Re: [smf_addin] Re: Replace RCHGetYahooHistory call
>
>
>
>
>
> See:
>
> https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32237
>
>
>
> On Mon, May 22, 2017 at 10:11 AM, lewglenn@
>
> ...wrote:
>
>
> What's the url for the 5/21 version?
>
>
Mon May 22, 2017 2:09 pm (PDT) . Posted by:
"lswpubrw" lswpubrlw
Randy,
I'm continuing to have the same problem. My Add-In manager says the SMF XLA is installed and active and my Windows updates are all up-to-date. The file in the SMF folder is the one I downloaded on 5/21 so I'm assuming it's the new one. I've removed the links on the front of the commands, now using only
=RCHGetElementNumber("Version")
and
=RCHGetYahooQuotes($A$7,"l1")
Still giving me #Name?
Bob
lswpubrw@optonline.net
warasir@sunysuffolk.edu
bobwarasila@lswpub.com
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Monday, May 22, 2017 3:20 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] installation.
So what did you get with:
=RCHGetElementNumber("Version")
What formula are you getting #NAME? results for?
On Mon, May 22, 2017 at 12:10 PM, 'Wasi' wasi.rahim@
...wrote:
I have download the new version of smf addin. But still I am getting errors, like "Name" I have confirmed that the addin is installed though.
Any suggestions?
Thanks
wasi
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, May 22, 2017 1:14 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Replace RCHGetYahooHistory call
See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32237
On Mon, May 22, 2017 at 10:11 AM, lewglenn@
...wrote:
What's the url for the 5/21 version?
I'm continuing to have the same problem. My Add-In manager says the SMF XLA is installed and active and my Windows updates are all up-to-date. The file in the SMF folder is the one I downloaded on 5/21 so I'm assuming it's the new one. I've removed the links on the front of the commands, now using only
=RCHGetElementNumber("Version")
and
=RCHGetYahooQuotes($A$7,"l1")
Still giving me #Name?
Bob
lswpubrw@optonline.net
warasir@sunysuffolk.edu
bobwarasila@lswpub.com
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Monday, May 22, 2017 3:20 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] installation.
So what did you get with:
=RCHGetElementNumber("Version")
What formula are you getting #NAME? results for?
On Mon, May 22, 2017 at 12:10 PM, 'Wasi' wasi.rahim@
...wrote:
I have download the new version of smf addin. But still I am getting errors, like "Name" I have confirmed that the addin is installed though.
Any suggestions?
Thanks
wasi
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, May 22, 2017 1:14 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Replace RCHGetYahooHistory call
See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32237
On Mon, May 22, 2017 at 10:11 AM, lewglenn@
...wrote:
What's the url for the 5/21 version?
Mon May 22, 2017 3:37 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try this:
1. Close EXCEL
2. Open EXCEL
3. Create a new workbook
4. Then use the "Version" function
If you get #NAME? back, it means the add-in is not active.
When you mention having to remove links, it mean EXCEL couldn't find the
add-in (or the function) in that location and marked those as unresolved
links. You should have gotten an error message when opening the workbook.
Those unresolved links need to be resolved before the workbook will
function properly -- it will give #NAME? errors for them, BECAUSE they are
unresolved links.
The best way to remove such unresolved links is to use the smfFixLinks
macro in the add-in.
On Mon, May 22, 2017 at 1:48 PM, 'lswpubrw' lswpubrw@
...wrote:
>
> I'm continuing to have the same problem. My Add-In manager says the SMF
> XLA is installed and active and my Windows updates are all up-to-date. The
> file in the SMF folder is the one I downloaded on 5/21 so I'm assuming it's
> the new one. I've removed the links on the front of the commands, now
> using only
>
> =RCHGetElementNumber("Version")
> and
> =RCHGetYahooQuotes($A$7,"l1")
> Still giving me #Name?
>
>
>
1. Close EXCEL
2. Open EXCEL
3. Create a new workbook
4. Then use the "Version" function
If you get #NAME? back, it means the add-in is not active.
When you mention having to remove links, it mean EXCEL couldn't find the
add-in (or the function) in that location and marked those as unresolved
links. You should have gotten an error message when opening the workbook.
Those unresolved links need to be resolved before the workbook will
function properly -- it will give #NAME? errors for them, BECAUSE they are
unresolved links.
The best way to remove such unresolved links is to use the smfFixLinks
macro in the add-in.
On Mon, May 22, 2017 at 1:48 PM, 'lswpubrw&#
...wrote:
>
> I'm continuing to have the same problem. My Add-In manager says the SMF
> XLA is installed and active and my Windows updates are all up-to-date. The
> file in the SMF folder is the one I downloaded on 5/21 so I'm assuming it's
> the new one. I've removed the links on the front of the commands, now
> using only
>
> =RCHGetElementNumbe
> and
> =RCHGetYahooQuotes(
> Still giving me #Name?
>
>
>
Mon May 22, 2017 2:25 pm (PDT) . Posted by:
palminha
Hi Randy
Can you give me some samples?
Thank you!
Can you give me some samples?
Thank you!
Mon May 22, 2017 2:46 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hard for me to understand what you're asking for samples of? There are
smfPricesByDates() templates on the web site, and smfGetYahooHistory()
samples in the previously mentioned links.
On Mon, May 22, 2017 at 2:25 PM, palminha@
...wrote:
>
> Can you give me some samples?
>
>
smfPricesByDates(
samples in the previously mentioned links.
On Mon, May 22, 2017 at 2:25 PM, palminha@
...wrote:
>
> Can you give me some samples?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar