13 New Messages
Digest #2647
Messages
Thu Jun 6, 2013 5:39 am (PDT) . Posted by:
"pipmick" pipmick
Hi,
First post, so please excuse me if it's not in the right area.
I have downloaded the latest zip file but I cannot unzip it at all. It seems I am being asked for a password to unlock it, or it is protected which is preventing me from unzipping the file to my desired location on my Windows 7, 64-bit OS:
C:\Program Files(x86)\SMF Add-In
Can anyone help me at all? I have tried a few times with the same result!
Thanks,
Phil
First post, so please excuse me if it's not in the right area.
I have downloaded the latest zip file but I cannot unzip it at all. It seems I am being asked for a password to unlock it, or it is protected which is preventing me from unzipping the file to my desired location on my Windows 7, 64-bit OS:
C:\Program Files(x86)&#
Can anyone help me at all? I have tried a few times with the same result!
Thanks,
Phil
Thu Jun 6, 2013 11:06 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
There is no password on the ZIP file...I don't know what to tell you. I
just tried opening it directly from the FILES area of the group into
Windows Explorer, and it did it immediately. Didn't ask for a password.
In case it is an O/S issue, you could try just putting it into the "C:\SMF
Add-In" folder. That's where I have mine installed, because of issues I had
with Vista not liking me using it in the Program Files folder.
On Thu, Jun 6, 2013 at 5:19 AM, pipmick <pipmick@yahoo.co.uk > wrote:
>
> First post, so please excuse me if it's not in the right area.
>
> I have downloaded the latest zip file but I cannot unzip it at all. It
> seems I am being asked for a password to unlock it, or it is protected
> which is preventing me from unzipping the file to my desired location on my
> Windows 7, 64-bit OS:
>
> C:\Program Files(x86)\SMF Add-In
>
> Can anyone help me at all? I have tried a few times with the same result!
>
just tried opening it directly from the FILES area of the group into
Windows Explorer, and it did it immediately. Didn't ask for a password.
In case it is an O/S issue, you could try just putting it into the "C:\
Add-In" folder. That's where I have mine installed, because of issues I had
with Vista not liking me using it in the Program Files folder.
On Thu, Jun 6, 2013 at 5:19 AM, pipmick <pipmick@yahoo.
>
> First post, so please excuse me if it's not in the right area.
>
> I have downloaded the latest zip file but I cannot unzip it at all. It
> seems I am being asked for a password to unlock it, or it is protected
> which is preventing me from unzipping the file to my desired location on my
> Windows 7, 64-bit OS:
>
> C:\Program Files(x86)&#
>
> Can anyone help me at all? I have tried a few times with the same result!
>
Thu Jun 6, 2013 11:58 am (PDT) . Posted by:
"Phil Garvey" pipmick
Hi,
Thanks for responding - I've managed to sort it out by opening the file first with 7Zip and then extracting from within the file itself, rather than from the right-button context menu (which has always worked for me since I owned a PC back in 1998)!
Cheers for coming back to me though!
Phil
>________________________________
> From: Randy Harmelink <rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Thursday, 6 June 2013, 19:06
>Subject: Re: [smf_addin] Password required to unzip?
>
>
>
>
>There is no password on the ZIP file...I don't know what to tell you. I just tried opening it directly from the FILES area of the group into Windows Explorer, and it did it immediately. Didn't ask for a password.
>
>In case it is an O/S issue, you could try just putting it into the "C:\SMF Add-In" folder. That's where I have mine installed, because of issues I had with Vista not liking me using it in the Program Files folder.
>
>
>On Thu, Jun 6, 2013 at 5:19 AM, pipmick <pipmick@yahoo.co.uk > wrote:
>
>
>>First post, so please excuse me if it's not in the right area.
>>
>>I have downloaded the latest zip file but I cannot unzip it at all. It seems I am being asked for a password to unlock it, or it is protected which is preventing me from unzipping the file to my desired location on my Windows 7, 64-bit OS:
>>
>>C:\Program Files(x86)\SMF Add-In
>>
>>Can anyone help me at all? I have tried a few times with the same result!
>>
>
>
>
>
Thanks for responding - I've managed to sort it out by opening the file first with 7Zip and then extracting from within the file itself, rather than from the right-button context menu (which has always worked for me since I owned a PC back in 1998)!
Cheers for coming back to me though!
Phil
>________
> From: Randy Harmelink <rharmelink@gmail.
>To: smf_addin@yahoogrou
>Sent: Thursday, 6 June 2013, 19:06
>Subject: Re: [smf_addin] Password required to unzip?
>
>
>
>
>There is no password on the ZIP file...I don't know what to tell you. I just tried opening it directly from the FILES area of the group into Windows Explorer, and it did it immediately. Didn't ask for a password.
>
>In case it is an O/S issue, you could try just putting it into the "C:\
>
>
>On Thu, Jun 6, 2013 at 5:19 AM, pipmick <pipmick@yahoo.
>
>
>>First post, so please excuse me if it's not in the right area.
>>
>>I have downloaded the latest zip file but I cannot unzip it at all. It seems I am being asked for a password to unlock it, or it is protected which is preventing me from unzipping the file to my desired location on my Windows 7, 64-bit OS:
>>
>>C:&#
>>
>>Can anyone help me at all? I have tried a few times with the same result!
>>
>
>
>
>
Thu Jun 6, 2013 5:57 am (PDT) . Posted by:
"Steven" sdavis81
As usual, my thanks Randy.
I am having trouble making my formula work, I wonder if someone could troubleshoot it for me.
My original formula used OptionSource as a source and would not pull the weekly quotes, returning an error.
=IFERROR(AVERAGE(smfGetOptionQuotes(M4,"a",0,OptionSource),smfGetOptionQuotes(M4,"b",0,OptionSource)),smfGetOptionQuotes(M4,"l",0,OptionSource))
I changed the 3 instances of "OptionSource" to "3" (indicating use OX as source), and it returns "bad source"
=IFERROR(AVERAGE(smfGetOptionQuotes(M3,"a",0,3),smfGetOptionQuotes(M3,"b",0,3)),smfGetOptionQuotes(M3,"l",0,3))
The forumula is supposed to pull the bid and ask and split them during day, if not avaialable off hours to use "last price". M3 and M4 are where the quote info lies, I didn't change that.
I tried making a new formula with smfGetOXOptionQuote() but could not get that to work either for some reason, perhaps the syntax is wrong. I am hoping I can just change the source in my original formula to get the same info as before, but no errors on the weeklies.
Thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It would need to be done with two functions in a single formula. However,
> the web page would only be retrieved once. The add-in saves a web page
> before it extracts data from it, so further queries against that same web
> page would just come from the saved copy and not need to go back to the
> Internet.
>
> On Tue, Jun 4, 2013 at 7:18 AM, Steven <sdavis81@...> wrote:
>
> > I was looking over the documentation for pulling weekly VXX quotes. My
> > sheet uses the Yahoo query and returns an error for weeklies.
> >
> > It looks like for a single data item I would use smfGetOXOptionQuote say
> > for "last price".
> >
> > My sheet currently pulls the bid and ask and divides them though. Is
> > there a way to do this with one query or does it need to be entered as a
> > formula with 2 queries?
> >
>
I am having trouble making my formula work, I wonder if someone could troubleshoot it for me.
My original formula used OptionSource as a source and would not pull the weekly quotes, returning an error.
=IFERROR(AVERAGE(
I changed the 3 instances of "OptionSource&
=IFERROR(AVERAGE(
The forumula is supposed to pull the bid and ask and split them during day, if not avaialable off hours to use "last price". M3 and M4 are where the quote info lies, I didn't change that.
I tried making a new formula with smfGetOXOptionQuote
Thanks
--- In smf_addin@yahoogrou
>
> It would need to be done with two functions in a single formula. However,
> the web page would only be retrieved once. The add-in saves a web page
> before it extracts data from it, so further queries against that same web
> page would just come from the saved copy and not need to go back to the
> Internet.
>
> On Tue, Jun 4, 2013 at 7:18 AM, Steven <sdavis81@
>
> > I was looking over the documentation for pulling weekly VXX quotes. My
> > sheet uses the Yahoo query and returns an error for weeklies.
> >
> > It looks like for a single data item I would use smfGetOXOptionQuote say
> > for "last price".
> >
> > My sheet currently pulls the bid and ask and divides them though. Is
> > there a way to do this with one query or does it need to be entered as a
> > formula with 2 queries?
> >
>
Thu Jun 6, 2013 11:59 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The "3" is a prefix on the item codes of OptionsXpress, if you are
requesting items from multiple data sources (i.e. data source of "2").
Try using "OX" as your OptionSource.
On Thu, Jun 6, 2013 at 5:57 AM, Steven <sdavis81@yahoo.com > wrote:
>
> I am having trouble making my formula work, I wonder if someone could
> troubleshoot it for me.
>
> My original formula used OptionSource as a source and would not pull the
> weekly quotes, returning an error.
>
>
> =IFERROR(AVERAGE(smfGetOptionQuotes(M4,"a",0,OptionSource),smfGetOptionQuotes(M4,"b",0,OptionSource)),smfGetOptionQuotes(M4,"l",0,OptionSource))
>
> I changed the 3 instances of "OptionSource" to "3" (indicating use OX as
> source), and it returns "bad source"
>
>
> =IFERROR(AVERAGE(smfGetOptionQuotes(M3,"a",0,3),smfGetOptionQuotes(M3,"b",0,3)),smfGetOptionQuotes(M3,"l",0,3))
>
> The forumula is supposed to pull the bid and ask and split them during
> day, if not avaialable off hours to use "last price". M3 and M4 are where
> the quote info lies, I didn't change that.
>
> I tried making a new formula with smfGetOXOptionQuote() but could not get
> that to work either for some reason, perhaps the syntax is wrong. I am
> hoping I can just change the source in my original formula to get the same
> info as before, but no errors on the weeklies.
>
requesting items from multiple data sources (i.e. data source of "2"
Try using "OX" as your OptionSource.
On Thu, Jun 6, 2013 at 5:57 AM, Steven <sdavis81@yahoo.
>
> I am having trouble making my formula work, I wonder if someone could
> troubleshoot it for me.
>
> My original formula used OptionSource as a source and would not pull the
> weekly quotes, returning an error.
>
>
> =IFERROR(AVERAGE(
>
> I changed the 3 instances of "OptionSource&
> source), and it returns "bad source"
>
>
> =IFERROR(AVERAGE(
>
> The forumula is supposed to pull the bid and ask and split them during
> day, if not avaialable off hours to use "last price". M3 and M4 are where
> the quote info lies, I didn't change that.
>
> I tried making a new formula with smfGetOXOptionQuote
> that to work either for some reason, perhaps the syntax is wrong. I am
> hoping I can just change the source in my original formula to get the same
> info as before, but no errors on the weeklies.
>
Thu Jun 6, 2013 8:03 am (PDT) . Posted by:
"Roger" rogerdiazbernal
Hi Randy:
I upgraded RCH_Stock_Market_Functions_2.1.2013.06.03 but when I use the function RCHGetElementNumber all the elements MSN and ZACS obtained as a result "Error".
Thanks for your attention.
Roger
I upgraded RCH_Stock_Market_
Thanks for your attention.
Roger
Thu Jun 6, 2013 11:53 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just tried these two and they worked fine here:
=RCHGetElementNumber("MMM";,3)
=RCHGetElementNumber("MMM";,850)
Those both give you "Error"? They are basically doing:
=RCHGetTableCell("
http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=MMM ",1,"QUICK
FACTS","EXCHANGE")
=RCHGetTableCell("http://www.zacks.com/stock/quote/MMM ",1,">Industry")
What do you get with those two functions?
On Thu, Jun 6, 2013 at 8:03 AM, Roger <rogerdiazb@gmail.com > wrote:
> I upgraded RCH_Stock_Market_Functions_2.1.2013.06.03 but when I use the
> function RCHGetElementNumber all the elements MSN and ZACS obtained as a
> result "Error".
>
=RCHGetElementNumbe
=RCHGetElementNumbe
Those both give you "Error"
=RCHGetTableCell(
http://investing.
FACTS",
=RCHGetTableCell(
What do you get with those two functions?
On Thu, Jun 6, 2013 at 8:03 AM, Roger <rogerdiazb@gmail.
> I upgraded RCH_Stock_Market_
> function RCHGetElementNumber all the elements MSN and ZACS obtained as a
> result "Error"
>
Thu Jun 6, 2013 1:11 pm (PDT) . Posted by:
"Roger Diaz" rogerdiazbernal
Yes. both are giving "error".
but functions RCHGetTableCell, OK in both
but functions RCHGetTableCell, OK in both
Thu Jun 6, 2013 6:28 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That doesn't make any sense to me, since the RCHGetElementNumber()
functions are basically just saved RCHGetTableCell() functions.
Do you have an older version of EXCEL?
On Thu, Jun 6, 2013 at 1:10 PM, Roger Diaz <rogerdiazb@gmail.com > wrote:
>
> Yes. both are giving "error".
> but functions RCHGetTableCell, OK in both
>
functions are basically just saved RCHGetTableCell(
Do you have an older version of EXCEL?
On Thu, Jun 6, 2013 at 1:10 PM, Roger Diaz <rogerdiazb@gmail.
>
> Yes. both are giving "error"
> but functions RCHGetTableCell, OK in both
>
Thu Jun 6, 2013 11:29 am (PDT) . Posted by:
"Xin L" liucyndy
Randy,
do you have a formula for people to download historical prices? what I have is a list of tickers and for each ticker I just need start day and end day prices.
Do you have formula that I can set date, ticker to download prices? Thanks a lot!
do you have a formula for people to download historical prices? what I have is a list of tickers and for each ticker I just need start day and end day prices.
Do you have formula that I can set date, ticker to download prices? Thanks a lot!
Thu Jun 6, 2013 11:55 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Take a look at the RCHGetYahooHistory() function...
Or, for total return type situations, I use the smfPricesByDates() function.
On Thu, Jun 6, 2013 at 11:29 AM, Xin L <jgr1230@gmail.com > wrote:
>
> do you have a formula for people to download historical prices? what I
> have is a list of tickers and for each ticker I just need start day and end
> day prices.
> Do you have formula that I can set date, ticker to download prices? Thanks
> a lot!
>
Or, for total return type situations, I use the smfPricesByDates(
On Thu, Jun 6, 2013 at 11:29 AM, Xin L <jgr1230@gmail.
>
> do you have a formula for people to download historical prices? what I
> have is a list of tickers and for each ticker I just need start day and end
> day prices.
> Do you have formula that I can set date, ticker to download prices? Thanks
> a lot!
>
Thu Jun 6, 2013 12:14 pm (PDT) . Posted by:
"Ashwin Kumar R N" ashwin_rn186
Thu Jun 6, 2013 6:23 pm (PDT) . Posted by:
"brad.valentine" brad.valentine
How do I get real-time S&P 500, NASDAQ Composite, and Dow Jones Industrial quotes into excel? The Yahoo Real Time Quotes formula works for individual stocks, but it does not seem to work for the indices.
Tidak ada komentar:
Posting Komentar