15 Messages
Digest #4209
Messages
Sat Nov 4, 2017 3:03 pm (PDT) . Posted by:
timdbui
Hi Randy,
Do you have a template where I just put in the ticker and I can get all available put and call options? Thank you!
Tim
Do you have a template where I just put in the ticker and I can get all available put and call options? Thank you!
Tim
Sat Nov 4, 2017 4:40 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Nope. That would be a nightmare to create.
On Sat, Nov 4, 2017 at 3:03 PM, timdbui@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Do you have a template where I just put in the ticker and I can get all
> available put and call options? Thank you!
>
>
>
On Sat, Nov 4, 2017 at 3:03 PM, timdbui@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Do you have a template where I just put in the ticker and I can get all
> available put and call options? Thank you!
>
>
>
Sat Nov 4, 2017 3:54 pm (PDT) . Posted by:
"Pieter van Leeuwen" pietertvl
Thank you so much for your prior and current efforts here.
Re the array entry, that's wasn't needed when I imported the html version initially.
With CSV, it was ... and your guidance worked.
I hope you are able to clone yourself.
Or bill Yahoo for your time somehow.
I would recommend updating your blog with anything that's been helpful to others here early on, so that you don't have address the same issues multiple times as more folks wander over here.
Cheers
Pieter
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Saturday, November 04, 2017 2:46 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Getting Quotes
"To array-enter a formula in EXCEL, first highlight the range of cells where you would like the returned data to appear -- the number of rows for the range should be AT LEAST the number of ticker symbols you are requesting from the function, while the number of columns for the range should be AT LEAST the number of data items you are requesting for each ticker symbol from the function. Next, enter your formula and then press Ctrl-Shift-Enter."
On Sat, Nov 4, 2017 at 2:39 PM, 'Pieter van Leeuwen' pieter_biz@ecentral.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
This may be issue of single cell vs array entry. (my issue an hour ago)
I'm still looking around to see what array entry means.
Pasting over multiple cells merely repeats.
Doubt it means using text wrap.
Nothing on google explaining that so far.
Re the array entry, that's wasn't needed when I imported the html version initially.
With CSV, it was ... and your guidance worked.
I hope you are able to clone yourself.
Or bill Yahoo for your time somehow.
I would recommend updating your blog with anything that's been helpful to others here early on, so that you don't have address the same issues multiple times as more folks wander over here.
Cheers
Pieter
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Saturday, November 04, 2017 2:46 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Getting Quotes
"To array-enter a formula in EXCEL, first highlight the range of cells where you would like the returned data to appear -- the number of rows for the range should be AT LEAST the number of ticker symbols you are requesting from the function, while the number of columns for the range should be AT LEAST the number of data items you are requesting for each ticker symbol from the function. Next, enter your formula and then press Ctrl-Shift-Enter."
On Sat, Nov 4, 2017 at 2:39 PM, 'Pieter van Leeuwen' pieter_biz@ecentral.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
This may be issue of single cell vs array entry. (my issue an hour ago)
I'm still looking around to see what array entry means.
Pasting over multiple cells merely repeats.
Doubt it means using text wrap.
Nothing on google explaining that so far.
Sat Nov 4, 2017 4:33 pm (PDT) . Posted by:
lewglenn
Very strange. When I look at the properties of the RCH_Stock_Market_Functions.xla file in SMF Add-in, it says Created: Thursday, November 02, 2017, 10:07:18 AM. For the RCHGetElementNumber-Element-Definitions.xls file it says Created: Saturday, September 16, 2017, 11:23:06 AM.
When I just again downloaded the zip file, the RCHGetElementNumber-Element-Definitions.xls file says it was modified 9/16/17. The RCH_Stock_Market_Functions.xla file says it was modified 11/2/2017. So these are the same files I have in my SMF Add-in folder.
The WinZip file has the header RCH_Stock_Market_Functions-2.1.2017.11.02.zip. Is this the correct zip file? Do I have the wrong url?
When I just again downloaded the zip file, the RCHGetElementNumber
The WinZip file has the header RCH_Stock_Market_
Sat Nov 4, 2017 4:34 pm (PDT) . Posted by:
stumpy_chris
What do you need from me for help.
When I use the sample spreadsheet, I get nothing in the cells except this: #NAME? in all the cells. I am pointing the Data link to the spot where I downloaded the function.
I downloaded the most updated SMF function (I believe).
Thanks.
When I use the sample spreadsheet, I get nothing in the cells except this: #NAME? in all the cells. I am pointing the Data link to the spot where I downloaded the function.
I downloaded the most updated SMF function (I believe).
Thanks.
Sat Nov 4, 2017 4:42 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Why would you think that's a problem? Different files get updated at
different times.
That XLS file is just a documentation file.
On Sat, Nov 4, 2017 at 2:49 PM, Yahoo! lewglenn@
...
wrote:
>
> Very strange. When I look at the properties of the *RCH_Stock_Market_Functions.xla
> file* in SMF Add-in, it says Created: Thursday, November 02, 2017,
> 10:07:18 AM. For the *RCHGetElementNumber-Element-Definitions.xls *file it
> says Created: Saturday, September 16, 2017, 11:23:06 AM*.*
>
> I'll try the download again.
>
>
different times.
That XLS file is just a documentation file.
On Sat, Nov 4, 2017 at 2:49 PM, Yahoo! lewglenn@
...
wrote:
>
> Very strange. When I look at the properties of the *RCH_Stock_Market_
> file* in SMF Add-in, it says Created: Thursday, November 02, 2017,
> 10:07:18 AM. For the *RCHGetElementNumbe
> says Created: Saturday, September 16, 2017, 11:23:06 AM*.*
>
> I'll try the download again.
>
>
Sat Nov 4, 2017 4:45 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Most people jump in here before having read the blog.
And the more information that goes into the blog, the less people read it.
On Sat, Nov 4, 2017 at 3:54 PM, 'Pieter van Leeuwen' pieter_biz@
...
wrote:
> I would recommend updating your blog with anything that's been helpful to
> others here early on, so that you don't have address the same issues
> multiple times as more folks wander over here.
>
>
>
And the more information that goes into the blog, the less people read it.
On Sat, Nov 4, 2017 at 3:54 PM, 'Pieter van Leeuwen' pieter_biz@
...
wrote:
> I would recommend updating your blog with anything that's been helpful to
> others here early on, so that you don't have address the same issues
> multiple times as more folks wander over here.
>
>
>
Sat Nov 4, 2017 4:48 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
#NAME? usually means the add-in isn't installed. Which sample spreadsheet
are you using? Which function invocation is give you #NAME?
What do you get with:
=RCHGetElementNumber("Version")
On Sat, Nov 4, 2017 at 4:34 PM, cschwartz@
...
wrote:
>
> What do you need from me for help.
>
> When I use the sample spreadsheet, I get nothing in the cells except this:
> #NAME? in all the cells. I am pointing the Data link to the spot where I
> downloaded the function.
>
> I downloaded the most updated SMF function (I believe).
>
>
>
are you using? Which function invocation is give you #NAME?
What do you get with:
=RCHGetElementNumbe
On Sat, Nov 4, 2017 at 4:34 PM, cschwartz@
...
wrote:
>
> What do you need from me for help.
>
> When I use the sample spreadsheet, I get nothing in the cells except this:
> #NAME? in all the cells. I am pointing the Data link to the spot where I
> downloaded the function.
>
> I downloaded the most updated SMF function (I believe).
>
>
>
Sat Nov 4, 2017 4:32 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Drop the last "1" parameter. It's what tells the function to put headers on.
=
smfGetYahooPortfolioView($B$4:$B$411,$C$2:$AJ$2)
On Sat, Nov 4, 2017 at 2:51 PM, johnrr9@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I am wondering if there is a way using this function in the example sheet
>
> =
>
> smfGetYahooPortfolioView($B$4:$B$411,$C$2:$AJ$2,,1)
>
> and NOT displaying the headers in the first line?
>
=
smfGetYahooPortfolioView($B$4:$B$411,$C$2:$AJ$2)
On Sat, Nov 4, 2017 at 2:51 PM, johnrr9@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I am wondering if there is a way using this function in the example sheet
>
> =
>
> smfGetYahooPortfoli
>
> and NOT displaying the headers in the first line?
>
Sat Nov 4, 2017 7:11 pm (PDT) . Posted by:
johnross999
Tx for this.
The time of "Last Traded" is retrived like 1509749520. What is the format of this? HMS? or anything else.
Tx
The time of "Last Traded" is retrived like 1509749520. What is the format of this? HMS? or anything else.
Tx
Sat Nov 4, 2017 7:28 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's a UNIX date/time value. You can convert it into an EXCEL serial
date/time with something like:
=smfUNIX2Date(A2)
The next release of the function will have over 50 additional fields,
including EXCEL serial date versions of the UNIX date fields.
On Sat, Nov 4, 2017 at 7:11 PM, johnrr9@
...
wrote:
>
> The time of "Last Traded" is retrived like 1509749520. What is the format
> of this? HMS? or anything else.
>
date/time with something like:
=smfUNIX2Date(
The next release of the function will have over 50 additional fields,
including EXCEL serial date versions of the UNIX date fields.
On Sat, Nov 4, 2017 at 7:11 PM, johnrr9@
...
wrote:
>
> The time of "Last Traded" is retrived like 1509749520. What is the format
> of this? HMS? or anything else.
>
Sat Nov 4, 2017 4:39 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't know what to tell you. That code works fine here. What do you get
with:
=RCHGetElementNumber("Version")
On Sat, Nov 4, 2017 at 2:53 PM, palminha@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> OK Randy after I do that I run macro and get this
>
>
with:
=RCHGetElementNumber("Version")
On Sat, Nov 4, 2017 at 2:53 PM, palminha@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> OK Randy after I do that I run macro and get this
>
>
Sat Nov 4, 2017 6:18 pm (PDT) . Posted by:
lewglenn
Randy,
I just once again downloaded the latest version of the zip file from http://ogres-crypt.com/SMF/ http://ogres-crypt.com/SMF/ I then restarted my computer and ran your test file:
Sub Test()
SelStr = "TLT,TLT,EDV,CVX,SON,VNQ,SBIO, T,TQQQ,MORL,DFT,BAX," _
& "BIP,EIGR,XLV,QQQ,XHB,ITB,DBC, GILD,SRC,MRCC,DES,TQQQ," _
& "AHH,HDV,SPHD,XBI,EEM,UVE,KRE, VOE,GDX,SILJ,DSENX,EFA," _
& "DGRW,REML"
Range("A2:I70") = smfGetYahooPortfolioView(SelStr, "013518192015163535", , 1)
Range("A1") = RCHGetElementNumber("Version")
End Sub.
The result from RCHGetElementNumber("Version") is:
Stock Market Functions add-in, Version 2.1.2017.09.17 (C:\Users\lewglenn\Documents; Windows (32-bit) NT 6.02; 12.0; ; ; 1)
I'm at my wits end. Don't know what else I can do to get the latest version of RCH_Stock_Market_Functions.xla. When I examine the properties of the file that I just downloaded it says Created: Thursday, November 02, 2017, 10:07:18 AM. The same for Modified and Accessed.
Any thoughts about what I might be doing wrong?
I just once again downloaded the latest version of the zip file from http://ogres-crypt.com/SMF/ http://ogres-crypt.com/SMF/ I then restarted my computer and ran your test file:
Sub Test()
SelStr = "TLT,TLT,
& "BIP,EIGR,
& "AHH,HDV,
& "DGRW,REML&quo
Range("
Range("
End Sub.
The result from RCHGetElementNumber
Stock Market Functions add-in, Version 2.1.2017.09.
I'm at my wits end. Don't know what else I can do to get the latest version of RCH_Stock_Market_
Any thoughts about what I might be doing wrong?
Sat Nov 4, 2017 6:38 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
OK. Try this:
1. Go to the add-in manager and un-check the add-in. All of them if there
are more than one.
2. Exit EXCEL
3. Unzip the 2017.11.02 ZIP file into the "C:\Users\lewglenn\Documents"
folder, replacing files as necessary.
4. Restart EXCEL
5. Go to the add-in manager and "Browse" to the XLA file in the
"C:\Users\lewglenn\Documents" folder, selecting it
6. Use the "Version" formula and check the version
7. Exit EXCEL
8. Restart EXCEL
9. Check the version again
10. Try the test XLS file and run the macro. What results do you see?
On Sat, Nov 4, 2017 at 6:18 PM, lewglenn@
...
wrote:
> I just once again downloaded the latest version of the zip file from
> http://ogres-crypt.com/SMF/ I then restarted my computer and ran your
> test file:
>
> Sub Test()
>
>
> SelStr = "TLT,TLT,EDV,CVX,SON,VNQ,SBIO, T,TQQQ,MORL,DFT,BAX," _
> & "BIP,EIGR,XLV,QQQ,XHB,ITB,DBC, GILD,SRC,MRCC,DES,TQQQ," _
> & "AHH,HDV,SPHD,XBI,EEM,UVE,KRE, VOE,GDX,SILJ,DSENX,EFA," _
> & "DGRW,REML"
>
> Range("A2:I70") = smfGetYahooPortfolioView(SelStr, "013518192015163535",
> , 1)
> Range("A1") = RCHGetElementNumber("Version")
>
> End Sub.
>
> The result from RCHGetElementNumber("Version") is:
>
> Stock Market Functions add-in, Version 2.1.2017.09.17 (
>
> C:\Users\lewglenn\Documents; Windows (32-bit) NT 6.02; 12.0; ; ; 1)
>
> I'm at my wits end. Don't know what else I can do to get the latest
> version of RCH_Stock_Market_Functions.xla. When I examine the properties
> of the file that I just downloaded it says Created: Thursday, November
> 02, 2017, 10:07:18 AM. The same for Modified and Accessed.
>
>
> Any thoughts about what I might be doing wrong?
>
1. Go to the add-in manager and un-check the add-in. All of them if there
are more than one.
2. Exit EXCEL
3. Unzip the 2017.11.02 ZIP file into the "C:\Users\lewglenn\Documents"
folder, replacing files as necessary.
4. Restart EXCEL
5. Go to the add-in manager and "Browse" to the XLA file in the
"C:\Users\lewglenn\Documents" folder, selecting it
6. Use the "Version" formula and check the version
7. Exit EXCEL
8. Restart EXCEL
9. Check the version again
10. Try the test XLS file and run the macro. What results do you see?
On Sat, Nov 4, 2017 at 6:18 PM, lewglenn@
...
wrote:
> I just once again downloaded the latest version of the zip file from
> http://ogres-crypt.com/SMF/ I then restarted my computer and ran your
> test file:
>
> Sub Test()
>
>
> SelStr = "TLT,TLT,
> & "BIP,EIGR,
> & "AHH,HDV,
> & "DGRW,REML&quo
>
> Range("
> , 1)
> Range("
>
> End Sub.
>
> The result from RCHGetElementNumber
>
> Stock Market Functions add-in, Version 2.1.2017.09.
>
> C:\Users&#
>
> I'm at my wits end. Don't know what else I can do to get the latest
> version of RCH_Stock_Market_
> of the file that I just downloaded it says Created: Thursday, November
> 02, 2017, 10:07:18 AM. The same for Modified and Accessed.
>
>
> Any thoughts about what I might be doing wrong?
>
Sat Nov 4, 2017 7:21 pm (PDT) . Posted by:
johnross999
Randy,
Thank you for the great job you are doing.
I am wondering if there is a way to say thank you by donating small amount for the hard job you are doing.
TX
Thank you for the great job you are doing.
I am wondering if there is a way to say thank you by donating small amount for the hard job you are doing.
TX
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar