12 Messages
Digest #3039
Messages
Wed Apr 9, 2014 8:16 am (PDT) . Posted by:
opm888
Where can I find the RCHGetElementnumber spreadsheet?
Thanks
Thanks
Wed Apr 9, 2014 8:17 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's the XLS file that is distributed within the ZIP archive...
On Wed, Apr 9, 2014 at 8:07 AM, <opm888@yahoo.com> wrote:
> Where can I find the RCHGetElementnumber spreadsheet?
>
>
On Wed, Apr 9, 2014 at 8:07 AM, <opm888@yahoo.com> wrote:
> Where can I find the RCHGetElementnumber spreadsheet?
>
>
Wed Apr 9, 2014 8:55 am (PDT) . Posted by:
spamfiel
I'm having trouble using smfGetOptionQuotes. For example with "BX 4/11 2014 $33.00 Call", I get $.59, $.62 and $.60 with 3b, 6b, and 7b, respectively. But when I log into Fidelity, I see that the actual bid is $.01. I can understand differences coming from 15-minute delays and differing exchanges, but there seems to be something else here.
Wed Apr 9, 2014 9:07 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
There are two possible issues:
1. The add-in is extracting data from an old saved copy of the web page.
The add-in saves the web page before it extracts data from it. So the
extracted data won't change unless you get rid of that saved copy of the
web page and get a new one. You can do that by either running the
smfForceRecalculation macro, or by exiting and restarting EXCEL. Simply
hitting F9 to recalculate will NOT get you a fresh copy of the web page.
2. Your Internet Options aren't set to always get a fresh copy of the web
page. IE can also save web pages, so that it can display them more quickly
if you go to them again.
For more info, check the "Tips and FAQs" list for items on
smfForceRecalculation.
On Wed, Apr 9, 2014 at 8:55 AM, <dave@fiel.us> wrote:
>
> I'm having trouble using smfGetOptionQuotes. For example with "BX 4/11
> 2014 $33.00 Call", I get $.59, $.62 and $.60 with 3b, 6b, and 7b,
> respectively. But when I log into Fidelity, I see that the actual bid is
> $.01. I can understand differences coming from 15-minute delays and
> differing exchanges, but there seems to be something else here.
>
1. The add-in is extracting data from an old saved copy of the web page.
The add-in saves the web page before it extracts data from it. So the
extracted data won't change unless you get rid of that saved copy of the
web page and get a new one. You can do that by either running the
smfForceRecalculation macro, or by exiting and restarting EXCEL. Simply
hitting F9 to recalculate will NOT get you a fresh copy of the web page.
2. Your Internet Options aren't set to always get a fresh copy of the web
page. IE can also save web pages, so that it can display them more quickly
if you go to them again.
For more info, check the "Tips and FAQs" list for items on
smfForceRecalculation.
On Wed, Apr 9, 2014 at 8:55 AM, <dave@fiel.us> wrote:
>
> I'm having trouble using smfGetOptionQuotes. For example with "BX 4/11
> 2014 $33.00 Call", I get $.59, $.62 and $.60 with 3b, 6b, and 7b,
> respectively. But when I log into Fidelity, I see that the actual bid is
> $.01. I can understand differences coming from 15-minute delays and
> differing exchanges, but there seems to be something else here.
>
Wed Apr 9, 2014 3:28 pm (PDT) . Posted by:
spamfiel
Thanks, Randy. IE was set incorrectly, but that doesn't seem to make it pull new quotes always. So, I guess that I must use smfForceRecalculation. Unfortunately, it takes a couple minutes on my spreadsheet. Any tips on making it work faster? I don't need it to actually recalc, just clear the caches.
Wed Apr 9, 2014 4:50 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
If you have a lot of individual RCHGetYahooQuotes(), you can consolidate
them into a single Internet access by array-entering the function over a
range. But if you're getting a lot of individual option quotes, they take
as long as they take.
There's no reason to purge the web pages saved within the add-in unless you
are recalculating. Or maybe I don't understand the question. The values
won't update until you get a new copy of the web page.
On Wed, Apr 9, 2014 at 3:28 PM, <dave@fiel.us> wrote:
>
> Thanks, Randy. IE was set incorrectly, but that doesn't seem to make it
> pull new quotes always. So, I guess that I must use
> smfForceRecalculation. Unfortunately, it takes a couple minutes on my
> spreadsheet. Any tips on making it work faster? I don't need it to
> actually recalc, just clear the caches.
>
them into a single Internet access by array-entering the function over a
range. But if you're getting a lot of individual option quotes, they take
as long as they take.
There's no reason to purge the web pages saved within the add-in unless you
are recalculating. Or maybe I don't understand the question. The values
won't update until you get a new copy of the web page.
On Wed, Apr 9, 2014 at 3:28 PM, <dave@fiel.us> wrote:
>
> Thanks, Randy. IE was set incorrectly, but that doesn't seem to make it
> pull new quotes always. So, I guess that I must use
> smfForceRecalculati
> spreadsheet. Any tips on making it work faster? I don't need it to
> actually recalc, just clear the caches.
>
Wed Apr 9, 2014 9:35 pm (PDT) . Posted by:
spamfiel
Yes, I use an array for stock quotes. But for options, I use VBA to run a series of tickers to get the quotes for various strikes and expiration dates. So recalculating doesn't accomplish much, but the cache clearing makes the VBA work properly on the next run. Not ideal, but it works, and a far sight better than staring at options chains manually.
Wed Apr 9, 2014 9:53 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You could add a call to smfForceRecalculation to your VBA...
On Wed, Apr 9, 2014 at 9:35 PM, <dave@fiel.us> wrote:
>
> Yes, I use an array for stock quotes. But for options, I use VBA to run a
> series of tickers to get the quotes for various strikes and expiration
> dates. So recalculating doesn't accomplish much, but the cache clearing
> makes the VBA work properly on the next run. Not ideal, but it works, and
> a far sight better than staring at options chains manually.
>
On Wed, Apr 9, 2014 at 9:35 PM, <dave@fiel.us> wrote:
>
> Yes, I use an array for stock quotes. But for options, I use VBA to run a
> series of tickers to get the quotes for various strikes and expiration
> dates. So recalculating doesn't accomplish much, but the cache clearing
> makes the VBA work properly on the next run. Not ideal, but it works, and
> a far sight better than staring at options chains manually.
>
Wed Apr 9, 2014 9:44 am (PDT) . Posted by:
codyklein
Here's another video for fixing links. It shows how to install the smfFixLinks in the Quick Access Toolbar (Excel 2010) then fix links through an example. Hope this helps.
http://youtu.be/N3zQQuo3AQ8 http://youtu.be/N3zQQuo3AQ8
http://youtu.be/N3zQQuo3AQ8 http://youtu.be/N3zQQuo3AQ8
Wed Apr 9, 2014 10:17 am (PDT) . Posted by:
phillip.cantrell
I have the add-in installed for excel and it works. However, when I am in VBA and try to add it, it is not under Tools>References. If it does not appear there, what should I do? If I click "Browse", what file am I looking for specifically, because if I go the SMF Add-In folder it tells me that there are no files with the extension it is looking for.
Wed Apr 9, 2014 10:20 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not sure what to tell you. It's always been on the list when I go
>Tools>References, as:
RCH_Stock_Market_Functions
I was able to find it with "Browse" though, if I change the file type to
include XLA.
On Wed, Apr 9, 2014 at 10:12 AM, <phillip.cantrell@yahoo.com> wrote:
>
> I have the add-in installed for excel and it works. However, when I am in
> VBA and try to add it, it is not under Tools>References. If it does not
> appear there, what should I do? If I click "Browse", what file am I
> looking for specifically, because if I go the SMF Add-In folder it tells me
> that there are no files with the extension it is looking for.
>
>Tools>References, as:
RCH_Stock_Market_Functions
I was able to find it with "Browse" though, if I change the file type to
include XLA.
On Wed, Apr 9, 2014 at 10:12 AM, <phillip.cantrell@yahoo.com> wrote:
>
> I have the add-in installed for excel and it works. However, when I am in
> VBA and try to add it, it is not under Tools>References
> appear there, what should I do? If I click "Browse"
> looking for specifically, because if I go the SMF Add-In folder it tells me
> that there are no files with the extension it is looking for.
>
Tidak ada komentar:
Posting Komentar