10 New Messages
Digest #2456
Messages
Wed Jan 2, 2013 12:08 pm (PST) . Posted by:
"dice962" dice962
Hi all,
I wrote up a new intro and how to for the SMF Add-in and have posted it to SeekingAlpha Instablog.
Thanks for all the hard work in creating and maintaining this great tool Randy !
Derek
http://seekingalpha.com/user/326478/instablog
I wrote up a new intro and how to for the SMF Add-in and have posted it to SeekingAlpha Instablog.
Thanks for all the hard work in creating and maintaining this great tool Randy !
Derek
http://seekingalpha
Wed Jan 2, 2013 2:06 pm (PST) . Posted by:
"Jim Ranum" amt2100
Awesome article Derek. This is exactly what I needed.
Thanks,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of dice962
Sent: Wednesday, January 02, 2013 3:08 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] New SMF Add-in article
Hi all,
I wrote up a new intro and how to for the SMF Add-in and have posted it to
SeekingAlpha Instablog.
Thanks for all the hard work in creating and maintaining this great tool
Randy !
Derek
http://seekingalpha.com/user/326478/instablog
Thanks,
Jim
From: smf_addin@yahoogrou
Of dice962
Sent: Wednesday, January 02, 2013 3:08 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] New SMF Add-in article
Hi all,
I wrote up a new intro and how to for the SMF Add-in and have posted it to
SeekingAlpha Instablog.
Thanks for all the hard work in creating and maintaining this great tool
Randy !
Derek
http://seekingalpha
Wed Jan 2, 2013 2:08 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Thanks for the time and effort you put into the article. I've added a
pointer to it in the LINKS area of the group...
On Wed, Jan 2, 2013 at 1:08 PM, dice962 derekbarrett@gmail.com > wrote:
> Hi all,
>
> I wrote up a new intro and how to for the SMF Add-in and have posted it to
> SeekingAlpha Instablog.
>
> Thanks for all the hard work in creating and maintaining this great tool
> Randy !
>
> Derek
>
> http://seekingalpha.com/user/326478/instablog
>
pointer to it in the LINKS area of the group...
On Wed, Jan 2, 2013 at 1:08 PM, dice962 derekbarrett@
> Hi all,
>
> I wrote up a new intro and how to for the SMF Add-in and have posted it to
> SeekingAlpha Instablog.
>
> Thanks for all the hard work in creating and maintaining this great tool
> Randy !
>
> Derek
>
> http://seekingalpha
>
Wed Jan 2, 2013 1:23 pm (PST) . Posted by:
"marco.deen" marco.deen
Thanks, this works very well combined with the "index" function. I followed the steps in your example file and have excel refer to the option symbol "smfgetoptionstrikes(symbol,expiration,P/C,datasource,1)". However this only seems to work with Yahoo and OX as data source, the rest returns: "invalid data source".
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> I would use the smfGetOptionStrikes() to get a list of strike prices, then
> do a MATCH() on the returned prices to find the correct strike price...
>
> On Thu, Dec 27, 2012 at 3:50 PM, marco.deen wrote:
>
> > If I want to get only the first strike that is a predefined % out of the
> > money for a ticker, say 10% otm, would that be possible?
> >
>
--- In smf_addin@yahoogrou
>
> I would use the smfGetOptionStrikes
> do a MATCH() on the returned prices to find the correct strike price...
>
> On Thu, Dec 27, 2012 at 3:50 PM, marco.deen wrote:
>
> > If I want to get only the first strike that is a predefined % out of the
> > money for a ticker, say 10% otm, would that be possible?
> >
>
Wed Jan 2, 2013 2:05 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Hmmm. Google works fine for me -- for example:
=smfGetOptionStrikes("DIA";,smfGetOptionExpiry(),"C","G",1)
"888" or "8" as a data source doesn't currently work. They changed
something on their website that now prevents the add-in from accessing the
data. I left the code in, hoping I could find a way to fix it later on. But
using them should not return "Invalid data source" -- unless you're using
an older version of the add-in.
On Wed, Jan 2, 2013 at 2:23 PM, marco.deen marco.deen@gmail.com > wrote:
> Thanks, this works very well combined with the "index" function. I
> followed the steps in your example file and have excel refer to the option
> symbol "smfgetoptionstrikes(symbol,expiration,P/C,datasource,1)". However
> this only seems to work with Yahoo and OX as data source, the rest returns:
> "invalid data source".
>
=smfGetOptionStrike
"888" or "8" as a data source doesn't currently work. They changed
something on their website that now prevents the add-in from accessing the
data. I left the code in, hoping I could find a way to fix it later on. But
using them should not return "Invalid data source" -- unless you're using
an older version of the add-in.
On Wed, Jan 2, 2013 at 2:23 PM, marco.deen marco.deen@gmail.
> Thanks, this works very well combined with the "index" function. I
> followed the steps in your example file and have excel refer to the option
> symbol "smfgetoptions
> this only seems to work with Yahoo and OX as data source, the rest returns:
> "invalid data source"
>
Wed Jan 2, 2013 11:44 pm (PST) . Posted by:
"jcarlosd" jcarlosd
I used the IE object until I discovered SMF. Unfortunately this time I could not make SMF to work with XMLHTTP (because of the cookies), so I had to use your option of working with the IE. So far, this method works with W7, IE8 and Excel2003.
BTW, in order to make it faster, with VBA I also setup IE to work without images, so I don't have to wait for them to be loaded.
J. Carlos
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> I abandoned those other methods in RCHGetURLData(), because I got
> significantly different results when I moved to a new computer, with a new
> version of IE and and new version of EXCEL.
>
> Interfacing with the IE object changes quite bit over the variation of
> permutations of EXCEL and IE versions, so it wasn't a reliable thing to
> base the add-in on.
>
> On Tue, Jan 1, 2013 at 2:45 PM, jcarlosd wrote:
>
> > However, I was thinking that since extracting data with IE object works
> > fine, if there was a way to use it instead the XMLHTTP.
> >
> > And I found that there is an option in RCHGetURLData to use it. I did it
> > that way and finally it seems to work (too late already: I'll check again
> > tomorrow).
> >
>
BTW, in order to make it faster, with VBA I also setup IE to work without images, so I don't have to wait for them to be loaded.
J. Carlos
--- In smf_addin@yahoogrou
>
> I abandoned those other methods in RCHGetURLData(
> significantly different results when I moved to a new computer, with a new
> version of IE and and new version of EXCEL.
>
> Interfacing with the IE object changes quite bit over the variation of
> permutations of EXCEL and IE versions, so it wasn't a reliable thing to
> base the add-in on.
>
> On Tue, Jan 1, 2013 at 2:45 PM, jcarlosd wrote:
>
> > However, I was thinking that since extracting data with IE object works
> > fine, if there was a way to use it instead the XMLHTTP.
> >
> > And I found that there is an option in RCHGetURLData to use it. I did it
> > that way and finally it seems to work (too late already: I'll check again
> > tomorrow).
> >
>
Thu Jan 3, 2013 12:05 am (PST) . Posted by:
"lawrence.leesh" lawrence.leesh
Hi
Is there a way to download via addin current assets data? Advfn has data only for some companies and MSN seems to report total assets as current assets.
thanks
LL
Is there a way to download via addin current assets data? Advfn has data only for some companies and MSN seems to report total assets as current assets.
thanks
LL
Thu Jan 3, 2013 12:44 am (PST) . Posted by:
"Randy Harmelink" rharmelink
What companies didn't have current assets on AdvFN? Financial companies,
maybe?
It looks to me like MSN has both total assets and current assets on their
balance sheet:
http://investing.money.msn.com/investments/stock-balance-sheet/?stmtView=Qtr&symbol=MMM
On Thu, Jan 3, 2013 at 1:05 AM, lawrence.leesh lawrence.leesh@yahoo.com >wrote:
>
> Is there a way to download via addin current assets data? Advfn has data
> only for some companies and MSN seems to report total assets as current
> assets.
>
maybe?
It looks to me like MSN has both total assets and current assets on their
balance sheet:
http://investing.
On Thu, Jan 3, 2013 at 1:05 AM, lawrence.leesh lawrence.leesh@
>
> Is there a way to download via addin current assets data? Advfn has data
> only for some companies and MSN seems to report total assets as current
> assets.
>
Thu Jan 3, 2013 2:18 am (PST) . Posted by:
"twoq2bstr8" twoq2bstr8
Hi Randy
How would I use the getcsvfile below to get price quotes for australian sotkcs off the google website. I tried substituting MMM for ASX:IIN for example and it does not work, also tried IIN and IIN.AX.
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> I just looked at an example of Google historical prices for MMM.
>
> - Data is adjusted for splits only, no dividends.
>
> - I found a number of days (holidays?) where open, high, low, and volume
> are zero, but closing price exists, matching neither the day before or the
> day after.
>
> - Data only goes back to 1997-02-28.
>
> I used:
>
> =smfGetCSVFIle("http://www.google.com/finance/historical?q=MMM&startdate=Feb26,
> 1990&output=csv")
>
> I don't see it as an improvement to Yahoo's glitches...
>
> On Tue, Jan 1, 2013 at 4:31 PM, twoq2bstr8 wrote:
>
> >
> > I have read other threads asking whether price data can be pulled in from
> > google finance.
> >
>
How would I use the getcsvfile below to get price quotes for australian sotkcs off the google website. I tried substituting MMM for ASX:IIN for example and it does not work, also tried IIN and IIN.AX.
--- In smf_addin@yahoogrou
>
> I just looked at an example of Google historical prices for MMM.
>
> - Data is adjusted for splits only, no dividends.
>
> - I found a number of days (holidays?) where open, high, low, and volume
> are zero, but closing price exists, matching neither the day before or the
> day after.
>
> - Data only goes back to 1997-02-28.
>
> I used:
>
> =smfGetCSVFIle(
> 1990&output=
>
> I don't see it as an improvement to Yahoo's glitches...
>
> On Tue, Jan 1, 2013 at 4:31 PM, twoq2bstr8 wrote:
>
> >
> > I have read other threads asking whether price data can be pulled in from
> > google finance.
> >
>
Thu Jan 3, 2013 2:54 am (PST) . Posted by:
"rho49m" rho49m
Now I am really getting embarrassed-ignorance is total. I think I now see how to set up the spread sheet you provided to download data automatically.
But now I don't know how to access this data by DDE! I have previously used Personal Stock Monitor to download data from Yahoo, and passed this data by DDE to Metaserver. I used a syntax like PSM|Folder name\Ticker!Price (PSM| My Portfolio\IBM!Price)in Metaserver.
Clearly don't know enough about DDE, using the spread sheet you so kindly provided, I am at a loss to see how I link to it by DDE!. If I try "Excel|spreadsheet-name\Sheet1\IBM!Price" in Excel I get something like spreadsheet-name.xls\file1\IBM.xls not found.How does one establish what possible data fields are available to DDE? Trial and error has not moved me forwards. I would prefer to use variable name not cell references so I can change the spreadsheet later. I am trying to have the data referenced by the symbol name, and have the data identified by the column name (price, volume, open)as it was in PSM. Can you point me to some source of help?. Is this a problem with how I set up the spreadsheet or wrong syntax to access the data? Any info. appreciated Thank you. wrote:
> >
> > OK I have a problem, if I open this spreadsheet the array seems to be filled with "='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(B9:B27,C7:I7)
> > so I make a SMF Add-in folder in root and copy the add-in there. I enable the plug in in Excel, but all I get is a block of #NAME? Clearly I am missing something.
> >
> >
> >
> > --- In smf_addin@yahoogroups.com , "rho49m" wrote:
> > >
> > >
> > > Thanks- that is service.
> > >
> > >
> > > --- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
> > > >
> > > > In the FILES area of the group:
> > > >
> > > > Files > Templates and Examples > RCHGetYahooQuotes
> > > >
> > > >
> > > http://finance.groups.yahoo.com/group/smf_addin/files/Templates%20and%20\
> > > Examples/RCHGetYahooQuotes/
> > > >
> > > > On Mon, Dec 31, 2012 at 3:56 AM, rho49m rho49m@ wrote:
> > > >
> > > > > OK- but where do I find
> > > "RCHGetYahooQuotes-Example-Timed-Update.xls"?
> > > > > Tried your help file, Google search, site search but did not find
> > > it!
> > > > > Feeling pretty silly...
> > > > >
> > > >
> > >
> >
>
But now I don't know how to access this data by DDE! I have previously used Personal Stock Monitor to download data from Yahoo, and passed this data by DDE to Metaserver. I used a syntax like PSM|Folder name\Ticker!
Clearly don't know enough about DDE, using the spread sheet you so kindly provided, I am at a loss to see how I link to it by DDE!. If I try "Excel|
> >
> > OK I have a problem, if I open this spreadsheet the array seems to be filled with "='
> > so I make a SMF Add-in folder in root and copy the add-in there. I enable the plug in in Excel, but all I get is a block of #NAME? Clearly I am missing something.
> >
> >
> >
> > --- In smf_addin@yahoogrou
> > >
> > >
> > > Thanks- that is service.
> > >
> > >
> > > --- In smf_addin@yahoogrou
> > > >
> > > > In the FILES area of the group:
> > > >
> > > > Files > Templates and Examples > RCHGetYahooQuotes
> > > >
> > > >
> > > http://finance.
> > > >
> > > > On Mon, Dec 31, 2012 at 3:56 AM, rho49m rho49m@ wrote:
> > > >
> > > > > OK- but where do I find
> > > "RCHGetYahooQu
> > > > > Tried your help file, Google search, site search but did not find
> > > it!
> > > > > Feeling pretty silly...
> > > > >
> > > >
> > >
> >
>
Tidak ada komentar:
Posting Komentar