15 Messages
Digest #3766
4b
Re: RCHGetYahooQuotes stops working - here's a workaround [1 Attachm by "Randy Harmelink" rharmelink
5b
Re: Good news for option quotes users ... possible smfGetYahooPortfo by "Randy Harmelink" rharmelink
Messages
Wed Aug 10, 2016 7:30 am (PDT) . Posted by:
woodburydance
Dear Randy,
First, let me thank you putting together this wonderful product!
I am trying to calculate the dividends per share that I have been paid for each stock from the date I purchased the stock until today. It is a different problem but it is a dividend history problem so I asked the question here instead of opening up a new thread.
Thank you!
Bruce Meyer
First, let me thank you putting together this wonderful product!
I am trying to calculate the dividends per share that I have been paid for each stock from the date I purchased the stock until today. It is a different problem but it is a dividend history problem so I asked the question here instead of opening up a new thread.
Thank you!
Bruce Meyer
Wed Aug 10, 2016 2:28 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I find the easiest way is to use the Yahoo historical quotes CSV file:
=SUM(INDEX(RCHGetYahooHistory("MMM",2015,1,1,2015,12,31,"v",,,,,99,2),,2))
That's using a beginning date of 2015-01-01 and and ending date of
2015-12-31. Just change those dates to what you need. It can be done from
MorningStar, but not nearly as easily.
On Wed, Aug 10, 2016 at 7:30 AM, bameyer@
...wrote:
> I am trying to calculate the dividends per share that I have been paid for
> each stock from the date I purchased the stock until today. It is a
> different problem but it is a dividend history problem so I asked the
> question here instead of opening up a new thread.
>
>
=SUM(INDEX(RCHGetYa
That's using a beginning date of 2015-01-01 and and ending date of
2015-12-31. Just change those dates to what you need. It can be done from
MorningStar, but not nearly as easily.
On Wed, Aug 10, 2016 at 7:30 AM, bameyer@
...wrote:
> I am trying to calculate the dividends per share that I have been paid for
> each stock from the date I purchased the stock until today. It is a
> different problem but it is a dividend history problem so I asked the
> question here instead of opening up a new thread.
>
>
Wed Aug 10, 2016 7:35 am (PDT) . Posted by:
"tikigod18" maybesew2001
Somehow I am on your email list. I am a member of another Yahoo group, coveredcalls-nakedputs_optionstrategies@yahoogroups.com
so maybe that's why. Can I be removed from your email chain and remain in the other group, or are you connected?
Thanks,
Amy
Wed Aug 10, 2016 12:49 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You can unsubscribe from either group any time. You must have subscribed to
this one at some point, as I don't add people.
You can either visit the group to unsubscribe or leave the group, or I
think you can also send an email to this address from the email address you
are subscribed from:
smf_addin-unsubscribe@yahoogroups.com
On Wed, Aug 10, 2016 at 7:35 AM, tikigod18 tikigod18@
...wrote:
>
> Somehow I am on your email list. I am a member of another Yahoo group,
> coveredcalls-nakedputs_optionstrategies@yahoogroups.com
>
> so maybe that's why. Can I be removed from your email chain and remain in
> the other group, or are you connected?
>
>
>
this one at some point, as I don't add people.
You can either visit the group to unsubscribe or leave the group, or I
think you can also send an email to this address from the email address you
are subscribed from:
smf_addin-unsubscribe@yahoogroups.com
On Wed, Aug 10, 2016 at 7:35 AM, tikigod18 tikigod18@
...wrote:
>
> Somehow I am on your email list. I am a member of another Yahoo group,
> coveredcalls-nakedputs_optionstrategies@yahoogroups.com
>
> so maybe that's why. Can I be removed from your email chain and remain in
> the other group, or are you connected?
>
>
>
Wed Aug 10, 2016 12:56 pm (PDT) . Posted by:
"tikigod18" maybesew2001
Thanks Randy. I have no doubt at some point I subscribed and didn't even know why:)
Amy
-----Original Message-----
From: Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Wed, Aug 10, 2016 3:50 pm
Subject: Re: [smf_addin] remove me
You can unsubscribe from either group any time. You must have subscribed to this one at some point, as I don't add people.
You can either visit the group to unsubscribe or leave the group, or I think you can also send an email to this address from the email address you are subscribed from:
smf_addin-unsubscribe@yahoogroups.com
On Wed, Aug 10, 2016 at 7:35 AM, tikigod18 tikigod18@
...wrote:
Somehow I am on your email list. I am a member of another Yahoo group, coveredcalls-nakedputs_optionstrategies@yahoogroups.com
so maybe that's why. Can I be removed from your email chain and remain in the other group, or are you connected?
Wed Aug 10, 2016 9:15 am (PDT) . Posted by:
bkipersztok
Thanks for the reply Randy. Hmm, yeah, that's not exactly what I'm looking for. Don't think those are the right securities. However, I was able to find updated options quotes for VXX1 here:
http://www.nasdaq.com/symbol/vxx/option-chain?money=all&dateindex=7&page=2 http://www.nasdaq.com/symbol/vxx/option-chain?money=all&dateindex=7&page=2
With that web page / table - to use an example - how would I pull the bid and ask price for VXX1 calls at the $60 strike?
Thanks,
Billy
http://www.nasdaq.com/symbol/vxx/option-chain?money=all&dateindex=7&page=2 http://www.nasdaq.com/symbol/vxx/option-chain?money=all&dateindex=7&page=2
With that web page / table - to use an example - how would I pull the bid and ask price for VXX1 calls at the $60 strike?
Thanks,
Billy
Wed Aug 10, 2016 1:05 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
These should do it:
=smfGetTagContent("
http://www.nasdaq.com/symbol/vxx/option-chain?money=all&dateindex=7&page=2
","td",3,"180119C00060000-vxx1",,,,1)
=smfGetTagContent("
http://www.nasdaq.com/symbol/vxx/option-chain?money=all&dateindex=7&page=2
","td",4,"180119C00060000-vxx1",,,,1)
On Wed, Aug 10, 2016 at 9:15 AM, bkipersztok@
...wrote:
>
> Thanks for the reply Randy. Hmm, yeah, that's not exactly what I'm looking
> for. Don't think those are the right securities. However, I was able to
> find updated options quotes for VXX1 here:
>
> http://www.nasdaq.com/symbol/vxx/option-chain?money=all&dateindex=7&page=2
>
> With that web page / table - to use an example - how would I pull the bid
> and ask price for VXX1 calls at the $60 strike?
>
>
>
=smfGetTagContent("
http://www.nasdaq.com/symbol/vxx/option-chain?money=all&dateindex=7&page=2
","td",3,"180119C00060000-vxx1",,,,1)
=smfGetTagContent("
http://www.nasdaq.com/symbol/vxx/option-chain?money=all&dateindex=7&page=2
","td",4,"180119C00060000-vxx1",,,,1)
On Wed, Aug 10, 2016 at 9:15 AM, bkipersztok@
...wrote:
>
> Thanks for the reply Randy. Hmm, yeah, that's not exactly what I'm looking
> for. Don't think those are the right securities. However, I was able to
> find updated options quotes for VXX1 here:
>
> http://www.nasdaq.com/symbol/vxx/option-chain?money=all&dateindex=7&page=2
>
> With that web page / table - to use an example - how would I pull the bid
> and ask price for VXX1 calls at the $60 strike?
>
>
>
Wed Aug 10, 2016 2:21 pm (PDT) . Posted by:
bkipersztok
Works great. Thanks Randy! Really grateful for your help and prompt response time.
Best,
Billy
Best,
Billy
Wed Aug 10, 2016 9:58 am (PDT) . Posted by:
dnunn0
I have Excel 2007/Win 10. Has anyone gotten it to work with that? I just installed it for the first time.
The Version function works just fine, but not much else. I tried several of the templates and got no joy.
I created a simple test file (attached) and tried the disable/enable trick but either I did it wrong or it doesn't work.
I searched the web and found that unblocking the .xla file might help (http://www.contextures.com/exceladdins.html), but it didn't help enough--still gettting #VALUE.
I'm able to pull yahoo data via the finance API and Excel VBA programming, so the plumbing looks good.
Oh--the add-in is in C:\SMF Add-In directory. I've done nothing unusual (at least not intentionally).
What am I doing wrong?
Thanks,
Dave
The Version function works just fine, but not much else. I tried several of the templates and got no joy.
I created a simple test file (attached) and tried the disable/enable trick but either I did it wrong or it doesn't work.
I searched the web and found that unblocking the .xla file might help (http://www.contextures.com/exceladdins.html), but it didn't help enough--still gettting #VALUE.
I'm able to pull yahoo data via the finance API and Excel VBA programming, so the plumbing looks good.
Oh--the add-in is in C:\SMF Add-In directory. I've done nothing unusual (at least not intentionally)
What am I doing wrong?
Thanks,
Dave
Attachment(s) from
1 of 1 File(s)
Wed Aug 10, 2016 1:11 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
When I opened your attachment, both formula worked fine. I got "my* version
results though, because it's running on my machine.
I'm not sure what to tell you, if I can't repeat the error here. What
results do you get for the "Version"?
What "finance API" are you referring to?
On Sun, Aug 7, 2016 at 10:58 PM, dnunn0@
...wrote:
>
> I have Excel 2007/Win 10. Has anyone gotten it to work with that? I just
> installed it for the first time.
>
> The Version function works just fine, but not much else. I tried several
> of the templates and got no joy.
>
> I created a simple test file (attached) and tried the disable/enable trick
> but either I did it wrong or it doesn't work.
>
> I searched the web and found that unblocking the .xla file might help (
> http://www.contextures.com/exceladdins.html), but it didn't help
> enough--still gettting #VALUE.
>
> I'm able to pull yahoo data via the finance API and Excel VBA programming,
> so the plumbing looks good.
>
> Oh--the add-in is in C:\SMF Add-In directory. I've done nothing unusual
> (at least not intentionally).
>
> What am I doing wrong?
>
results though, because it's running on my machine.
I'm not sure what to tell you, if I can't repeat the error here. What
results do you get for the "Version"?
What "finance API" are you referring to?
On Sun, Aug 7, 2016 at 10:58 PM, dnunn0@
...wrote:
>
> I have Excel 2007/Win 10. Has anyone gotten it to work with that? I just
> installed it for the first time.
>
> The Version function works just fine, but not much else. I tried several
> of the templates and got no joy.
>
> I created a simple test file (attached) and tried the disable/enable trick
> but either I did it wrong or it doesn't work.
>
> I searched the web and found that unblocking the .xla file might help (
> http://www.contextures.com/exceladdins.html), but it didn't help
> enough--still gettting #VALUE.
>
> I'm able to pull yahoo data via the finance API and Excel VBA programming,
> so the plumbing looks good.
>
> Oh--the add-in is in C:\SMF Add-In directory. I've done nothing unusual
> (at least not intentionally)
>
> What am I doing wrong?
>
Wed Aug 10, 2016 10:18 am (PDT) . Posted by:
garyhartling
Let's start at the beginning. You say "If you haven't created the Yahoo security cookies"... OK, so I haven't knowingly created any Yahoo security cookies, so how do I create it?
Wed Aug 10, 2016 1:23 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Best way is to use the EXCEL Web Query dialog (keyboard shortcut
alt+d+d+w). Go log in at "https://www.yahoo.com" and then cancel out of the
dialog. Just logging in creates the security cookie. I'm not sure how long
the cookie goes until it expires. Weeks, months?
In most cases, you should be able to just use IE to log in, but I've seen a
few situations where the IE browser is not the same version of the IE
object used by EXCEL, so the EXCEL Web Query dialog is the best bet.
On Wed, Aug 10, 2016 at 10:18 AM, Gary.Hartling@
...wrote:
>
> Let's start at the beginning. You say "If you haven't created the Yahoo
> security cookies"... OK, so I haven't knowingly created any Yahoo security
> cookies, so how do I create it?
>
>
alt+d+d+w). Go log in at "https://www.yahoo.com" and then cancel out of the
dialog. Just logging in creates the security cookie. I'm not sure how long
the cookie goes until it expires. Weeks, months?
In most cases, you should be able to just use IE to log in, but I've seen a
few situations where the IE browser is not the same version of the IE
object used by EXCEL, so the EXCEL Web Query dialog is the best bet.
On Wed, Aug 10, 2016 at 10:18 AM, Gary.Hartling@
...wrote:
>
> Let's start at the beginning. You say "If you haven't created the Yahoo
> security cookies"
> cookies, so how do I create it?
>
>
Wed Aug 10, 2016 6:56 pm (PDT) . Posted by:
beatnut8827
Dear Randy Thanks. That was a typo - should have been "plug-in". I followed your advice and exited Excel but the the context-menu is till missing the SMF options. I am using Excel 2016.
Any help greatly appreciated. Oh, and congratulations on a great piece of work
Neil in Sydney
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :
I'm not sure what to suggest other than exiting EXCEL and restarting it. The context menu loads when the add-in is loaded. I would thought that would have happened when you added it back in. But I have no idea what "pkug" is or what specifically you did to "remove and add the addin back in"...
On Mon, Aug 8, 2016 at 11:03 PM, neil@ ...wrote:
I had some weird prblem with the pkug and had to remove and add the addin back in. in the process I Lost the SMF menu item from the context-menu in Excel - the one with that allosw you to select whether to recalculate the selection workbook etc. Looking for help in getting back.
Any help greatly appreciated. Oh, and congratulations on a great piece of work
Neil in Sydney
---In smf_addin@yahoogroups.com, <rharmelink@
I'm not sure what to suggest other than exiting EXCEL and restarting it. The context menu loads when the add-in is loaded. I would thought that would have happened when you added it back in. But I have no idea what "pkug" is or what specifically you did to "remove and add the addin back in"...
On Mon, Aug 8, 2016 at 11:03 PM, neil@ ...wrote:
I had some weird prblem with the pkug and had to remove and add the addin back in. in the process I Lost the SMF menu item from the context-menu in Excel - the one with that allosw you to select whether to recalculate the selection workbook etc. Looking for help in getting back.
Wed Aug 10, 2016 7:11 pm (PDT) . Posted by:
john_hoel
I have had the same problem since installing the new release. My solution is the following:
1. File => Options => Add ins => Manage Excel Add-ins => Go
2. un-check Stock Market Functions Add-In
3. check Stock Market Functions Add-In.
That resolves it for me.
1. File => Options => Add ins => Manage Excel Add-ins => Go
2. un-check Stock Market Functions Add-In
3. check Stock Market Functions Add-In.
That resolves it for me.
Wed Aug 10, 2016 8:17 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Is it possible you have the "unblock" issue?
It's been discussed in a number of message threads recently. The problem
appears to be related to a MicroSoft security update that was done in July.
It's not letting EXCEL load the add-in when EXCEL starts up. As a result,
you could be getting link errors if you open a workbook, because EXCEL
can't resolve the links to the add-in. And if the add-in isn't being
loaded, you won't get the context menu...
For a workaround suggested by Microsoft, until they fix the issue, see:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
On Wed, Aug 10, 2016 at 6:56 PM, neil@theatreofimage.com.au [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Thanks. That was a typo - should have been "plug-in". I followed your
> advice and exited Excel but the the context-menu is till missing the SMF
> options. I am using Excel 2016.
> Any help greatly appreciated. Oh, and congratulations on a great piece of
> work
>
>
It's been discussed in a number of message threads recently. The problem
appears to be related to a MicroSoft security update that was done in July.
It's not letting EXCEL load the add-in when EXCEL starts up. As a result,
you could be getting link errors if you open a workbook, because EXCEL
can't resolve the links to the add-in. And if the add-in isn't being
loaded, you won't get the context menu...
For a workaround suggested by Microsoft, until they fix the issue, see:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
On Wed, Aug 10, 2016 at 6:56 PM, neil@theatreofimage.com.au [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Thanks. That was a typo - should have been "plug-in"
> advice and exited Excel but the the context-menu is till missing the SMF
> options. I am using Excel 2016.
> Any help greatly appreciated. Oh, and congratulations on a great piece of
> work
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar