5 New Messages
Digest #2703
Messages
Sat Jul 20, 2013 4:45 pm (PDT) . Posted by:
"MikeJBB" MikeJBB
I downloaded and installed the SMF because the MSN addin failed to get OTCPK stocks starting 7/19/13. The MSN website itself also does not produce stock quotes for OTCPK's any longer, it finds the company and puts up NA. I know the format changed for options and I have that working, but not for stocks as far as I know.
I was hoping I could get prices for OTCPK stocks from another source. I looked thru all 20k lines in the def file and only found MSN for last price. And MSN still works for NY stocks. Is there another source for excel prices? Here's some stocks that fail in SMF, MSN, and the MSN website: PFRMF, ATUSF, WFEMF.
Any help with SMF, since I converted my spreadsheet to it, would be appreciated.
Thanks
Mike
I was hoping I could get prices for OTCPK stocks from another source. I looked thru all 20k lines in the def file and only found MSN for last price. And MSN still works for NY stocks. Is there another source for excel prices? Here's some stocks that fail in SMF, MSN, and the MSN website: PFRMF, ATUSF, WFEMF.
Any help with SMF, since I converted my spreadsheet to it, would be appreciated.
Thanks
Mike
Sat Jul 20, 2013 4:52 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You should use the RCHGetYahooQuotes() function for current quotes. It can
grab numerous items on up to 200 stocks with one function invocation (and
one Internet access).
Element #25 has been incorrect since last year, when MSN redesigned their
print page. Ever since then, they've populated that field with the previous
day's closing price.
On Sat, Jul 20, 2013 at 3:53 PM, MikeJBB <mike@besslers.net > wrote:
> I downloaded and installed the SMF because the MSN addin failed to get
> OTCPK stocks starting 7/19/13. The MSN website itself also does not
> produce stock quotes for OTCPK's any longer, it finds the company and puts
> up NA. I know the format changed for options and I have that working, but
> not for stocks as far as I know.
>
> I was hoping I could get prices for OTCPK stocks from another source. I
> looked thru all 20k lines in the def file and only found MSN for last
> price. And MSN still works for NY stocks. Is there another source for
> excel prices? Here's some stocks that fail in SMF, MSN, and the MSN
> website: PFRMF, ATUSF, WFEMF.
>
> Any help with SMF, since I converted my spreadsheet to it, would be
> appreciated.
>
grab numerous items on up to 200 stocks with one function invocation (and
one Internet access).
Element #25 has been incorrect since last year, when MSN redesigned their
print page. Ever since then, they've populated that field with the previous
day's closing price.
On Sat, Jul 20, 2013 at 3:53 PM, MikeJBB <mike@besslers.
> I downloaded and installed the SMF because the MSN addin failed to get
> OTCPK stocks starting 7/19/13. The MSN website itself also does not
> produce stock quotes for OTCPK's any longer, it finds the company and puts
> up NA. I know the format changed for options and I have that working, but
> not for stocks as far as I know.
>
> I was hoping I could get prices for OTCPK stocks from another source. I
> looked thru all 20k lines in the def file and only found MSN for last
> price. And MSN still works for NY stocks. Is there another source for
> excel prices? Here's some stocks that fail in SMF, MSN, and the MSN
> website: PFRMF, ATUSF, WFEMF.
>
> Any help with SMF, since I converted my spreadsheet to it, would be
> appreciated.
>
Sat Jul 20, 2013 8:57 pm (PDT) . Posted by:
"trendfirst" trendfirst
I've just built my first spreadsheet using the smf addin. No major
problems, but I did get an error when I went from Win7 to XP. When I
closed the spreadsheet in XP, I got an error dialog that said "Compile
error in hidden module: SolverCode". Everything seems to run fine on
both operating systems in spite of this error. The spreadsheet was
built in Win7. Excel 2010 on both operating systems.
If anyone wants to have a look, it's called "Option Screener.xlsx" in
the User File area. I'm just a hack, so if anyone has any suggestions
on improving it, I'm all ears.
Thanks,
Kevin
problems, but I did get an error when I went from Win7 to XP. When I
closed the spreadsheet in XP, I got an error dialog that said "Compile
error in hidden module: SolverCode"
both operating systems in spite of this error. The spreadsheet was
built in Win7. Excel 2010 on both operating systems.
If anyone wants to have a look, it's called "Option Screener.xlsx" in
the User File area. I'm just a hack, so if anyone has any suggestions
on improving it, I'm all ears.
Thanks,
Kevin
Sat Jul 20, 2013 9:16 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
SolverCode is not part of the SMF add-in. It has no hidden modules.
Most of my option sheets are over in this Yahoo group:
http://finance.groups.yahoo.com/group/justcoveredcalls/
I have one similar to yours, but it looks at the first ITM and first OTM
calls for a covered call, then determines which has the best return of the
stock price remains unchanged:
* * 2013-07-26 * * OX * * * * *Best
covered call based on RIU* *Ticker* *Last Price* *Strike* *RIU* *RIE* *D/P*
*Call Ticker Symbol* *Bid Price* MMM $116.19 ITM 1.0% 1.0% 2.1% MMM 7/26
2013 $115.00 Call $2.39 SPY $169.17 ITM 0.6% 0.6% 0.7% SPY 7/26 2013
$169.00 Call $1.17 IWM $104.31 OTM 0.7% 0.8% 0.7% IWM 7/26 2013 $104.50
Call $0.68
But I just update it to use the smfUpdateDownloadTable process for this, so
there is no waiting for recalculation when the workbook is opened. It will
show the values that were there the last time it was saved. I typically
just change the expiration date, list of ticker symbols for my potential
candidates, then run the macro.
On Sat, Jul 20, 2013 at 8:36 PM, trendfirst <trendfirst@yahoo.com > wrote:
>
> I've just built my first spreadsheet using the smf addin. No major
> problems, but I did get an error when I went from Win7 to XP. When I
> closed the spreadsheet in XP, I got an error dialog that said "Compile
> error in hidden module: SolverCode". Everything seems to run fine on both
> operating systems in spite of this error. The spreadsheet was built in
> Win7. Excel 2010 on both operating systems.
>
> If anyone wants to have a look, it's called "Option Screener.xlsx" in the
> User File area. I'm just a hack, so if anyone has any suggestions on
> improving it, I'm all ears.
>
Most of my option sheets are over in this Yahoo group:
http://finance.
I have one similar to yours, but it looks at the first ITM and first OTM
calls for a covered call, then determines which has the best return of the
stock price remains unchanged:
* * 2013-07-26 * * OX * * * * *Best
covered call based on RIU* *Ticker* *Last Price* *Strike* *RIU* *RIE* *D/P*
*Call Ticker Symbol* *Bid Price* MMM $116.19 ITM 1.0% 1.0% 2.1% MMM 7/26
2013 $115.00 Call $2.39 SPY $169.17 ITM 0.6% 0.6% 0.7% SPY 7/26 2013
$169.00 Call $1.17 IWM $104.31 OTM 0.7% 0.8% 0.7% IWM 7/26 2013 $104.50
Call $0.68
But I just update it to use the smfUpdateDownloadTa
there is no waiting for recalculation when the workbook is opened. It will
show the values that were there the last time it was saved. I typically
just change the expiration date, list of ticker symbols for my potential
candidates, then run the macro.
On Sat, Jul 20, 2013 at 8:36 PM, trendfirst <trendfirst@yahoo.
>
> I've just built my first spreadsheet using the smf addin. No major
> problems, but I did get an error when I went from Win7 to XP. When I
> closed the spreadsheet in XP, I got an error dialog that said "Compile
> error in hidden module: SolverCode"
> operating systems in spite of this error. The spreadsheet was built in
> Win7. Excel 2010 on both operating systems.
>
> If anyone wants to have a look, it's called "Option Screener.xlsx" in the
> User File area. I'm just a hack, so if anyone has any suggestions on
> improving it, I'm all ears.
>
Sun Jul 21, 2013 1:03 am (PDT) . Posted by:
"Lawrence" lawleesh
Hi Randy
I read from the blog that there is no element number for Accumulated Depreciation for Google Finance. Could you pls give me a RCHGetTableCell formula for this in the format below so that I can fill in symbol and year in another cell.
Thanks
LL
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Those are just be normal EXCEL processing, so sure. You need to concatenate
> a string to change the URL, and I usually move the parameter for the
> concatenation to the end of the URL so it's just a single concatenation
> instead of two. So, something like:
>
> =RCHGetTableCell("
> http://markets.ft.com/research/Markets/Tearsheets/Financials?subview=BalanceSheet&s= "&B3,C3,">Cash
> and Short Term Investments")
>
> ...where B3 is your ticker symbol and C3 is which offset of year you want.
>
> On Sun, Jul 14, 2013 at 9:03 PM, Lawrence <lawrence.leesh@...> wrote:
>
> >
> > If I want the formula to get "1", "G05.SI" and "Cash and Short Term
> > Investments" from cell values, is that possible? So when I change the cells
> > it would retrieve another piece of info from another stock from another
> > year.
> >
>
I read from the blog that there is no element number for Accumulated Depreciation for Google Finance. Could you pls give me a RCHGetTableCell formula for this in the format below so that I can fill in symbol and year in another cell.
Thanks
LL
--- In smf_addin@yahoogrou
>
> Those are just be normal EXCEL processing, so sure. You need to concatenate
> a string to change the URL, and I usually move the parameter for the
> concatenation to the end of the URL so it's just a single concatenation
> instead of two. So, something like:
>
> =RCHGetTableCell(
> http://markets.
> and Short Term Investments"
>
> ...where B3 is your ticker symbol and C3 is which offset of year you want.
>
> On Sun, Jul 14, 2013 at 9:03 PM, Lawrence <lawrence.
>
> >
> > If I want the formula to get "1"
> > Investments" from cell values, is that possible? So when I change the cells
> > it would retrieve another piece of info from another stock from another
> > year.
> >
>
Tidak ada komentar:
Posting Komentar