Jumat, 04 Januari 2013

[smf_addin] Digest Number 2457

10 New Messages

Digest #2457
1a
Re: smfpricesbydate by "Randy Harmelink" rharmelink
2a
Re: Timed refresh during market hours by "Randy Harmelink" rharmelink
3a
Re: New SMF Add-in article by "Kermit W. Prather" kermitpra
5
Problem with the spreadsheet by "Axel Ronnisch" aronnisch

Messages

Thu Jan 3, 2013 6:58 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Google Finance doesn't offer historical quotes in a CSV file for that
company...

On Thu, Jan 3, 2013 at 3:17 AM, twoq2bstr8 simongbalzer@gmail.com> wrote:

>
> 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.
>

Thu Jan 3, 2013 7:00 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but I am not familiar with DDE at all. I've never used it.

On Thu, Jan 3, 2013 at 3:54 AM, rho49m rho49m@yahoo.it> wrote:

> 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:
>

Thu Jan 3, 2013 7:24 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

Fantastic article. I'm going to reference it in my next user newsletter.
That is if it is okay with you.

Kermit Prather
www.tradingourway.com

-----Original Message-----
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

------------------------------------

Yahoo! Groups Links

Thu Jan 3, 2013 11:42 am (PST) . Posted by:

"iamruf" iamruf

Hi, Element Numbers 63, 47, 42, 54 are retreiving Error.
13666, 878, 941 are working fine.
Can you please help/advise?

Symbol "Dividend Growth Rate
=RCHGetElementNumber
(A2,63)" "Yield
=RCHGetElementNumber
(A2,13666)" "Payout Ratio
=RCHGetElementNumber
(A2,47)" "Debt/Equity =RCHGetElementNumber
(A2,42)" "Current P/E
=RCHGetElementNumber
(A2,54)" "Sector
=RCHGetElementNumber
(A2, 878)" " Market Cap
=RCHGetElementNumber
(A2,941) "
JNJ Error 3.44 Error Error Error Healthcare $195,690,000
KO Error 2.71 Error Error Error Consumer Defensive $168,570,000
IBM Error 1.73 Error Error Error Technology $221,260,000

Thu Jan 3, 2013 1:03 pm (PST) . Posted by:

"iamruf" iamruf

Excel 2010 with Dec Addin updated

--- In smf_addin@yahoogroups.com, "iamruf" wrote:
>
> Hi, Element Numbers 63, 47, 42, 54 are retreiving Error.
> 13666, 878, 941 are working fine.
> Can you please help/advise?
>
> Symbol "Dividend Growth Rate
> =RCHGetElementNumber
> (A2,63)" "Yield
> =RCHGetElementNumber
> (A2,13666)" "Payout Ratio
> =RCHGetElementNumber
> (A2,47)" "Debt/Equity =RCHGetElementNumber
> (A2,42)" "Current P/E
> =RCHGetElementNumber
> (A2,54)" "Sector
> =RCHGetElementNumber
> (A2, 878)" " Market Cap
> =RCHGetElementNumber
> (A2,941) "
> JNJ Error 3.44 Error Error Error Healthcare $195,690,000
> KO Error 2.71 Error Error Error Consumer Defensive $168,570,000
> IBM Error 1.73 Error Error Error Technology $221,260,000
>

Thu Jan 3, 2013 1:13 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I just tried those four elements and they are working fine here.

What do you get for these functions:

=RCHGetElementNumber("Version")
=RCHGetElementNumber("JNJ";,63)
=smfGetAParms(63)

On Thu, Jan 3, 2013 at 12:42 PM, iamruf iam.samw@gmail.com> wrote:

> Hi, Element Numbers 63, 47, 42, 54 are retreiving Error.
> 13666, 878, 941 are working fine.
> Can you please help/advise?
>
> Symbol "Dividend Growth Rate
> =RCHGetElementNumber
> (A2,63)" "Yield
> =RCHGetElementNumber
> (A2,13666)" "Payout Ratio
> =RCHGetElementNumber
> (A2,47)" "Debt/Equity =RCHGetElementNumber
> (A2,42)" "Current P/E
> =RCHGetElementNumber
> (A2,54)" "Sector
> =RCHGetElementNumber
> (A2, 878)" " Market Cap
> =RCHGetElementNumber
> (A2,941) "
> JNJ Error 3.44 Error Error Error Healthcare
> $195,690,000
> KO Error 2.71 Error Error Error Consumer Defensive
> $168,570,000
> IBM Error 1.73 Error Error Error Technology
> $221,260,000
>

Thu Jan 3, 2013 1:26 pm (PST) . Posted by:

"Sam Williams" iamruf

Hi Randy,
I get:
Stock Market Functions add-in, Version 2.1.2012.12.29 (C:\Program Files
(x86)\SMF Add-in; 1) Error MSN;% Growth Rate -- Dividends (5-Year Annual
Average) -- Company;
http://moneycentral.msn.com/investor/research/sreport.asp?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=~~~~~;1;GROWTHRATES
%;DIVIDENDS (5-YEAR; ; ;0;0;0;0
On Thu, Jan 3, 2013 at 4:12 PM, Randy Harmelink rharmelink@gmail.com>wrote:

> =RCHGetElementNumber("Version")
> =RCHGetElementNumber("JNJ";,63)
> =smfGetAParms(63)
>

Thu Jan 3, 2013 1:59 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You still have the old MSN element definitions. Did you not extract all the
new files from the 2012-12-29 ZIP file?

Here's what I get from that last function:

MSN;% Growth Rate -- Dividends (5-Year Annual Average) -- Company;
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=~~~~~;1;GROWTHRATES
%;DIVIDENDS (5-YEAR; ; ;0;0;0;0

Note the different URL.

On Thu, Jan 3, 2013 at 2:26 PM, Sam Williams iam.samw@gmail.com> wrote:

> I get:
> Stock Market Functions add-in, Version 2.1.2012.12.29 (C:\Program Files
> (x86)\SMF Add-in; 1) Error MSN;% Growth Rate -- Dividends (5-Year
> Annual Average) -- Company;
> http://moneycentral.msn.com/investor/research/sreport.asp?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=~~~~~;1;GROWTHRATES %;DIVIDENDS (5-YEAR; ; ;0;0;0;0
>
> On Thu, Jan 3, 2013 at 4:12 PM, Randy Harmelink rharmelink@gmail.com>wrote:
>
>> =RCHGetElementNumber("Version")
>> =RCHGetElementNumber("JNJ";,63)
>> =smfGetAParms(63)
>>
>

Thu Jan 3, 2013 2:11 pm (PST) . Posted by:

"Sam Williams" iamruf

Randy, Many thanks - must have screwed up my initial extract. Now working.
Regards

On Thu, Jan 3, 2013 at 4:59 PM, Randy Harmelink rharmelink@gmail.com>wrote:

> **
>
>
> You still have the old MSN element definitions. Did you not extract all
> the new files from the 2012-12-29 ZIP file?
>
> Here's what I get from that last function:
>
> MSN;% Growth Rate -- Dividends (5-Year Annual Average) -- Company;
> 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=~~~~~;1;GROWTHRATES %;DIVIDENDS (5-YEAR; ; ;0;0;0;0
>
> Note the different URL.
>
>
> On Thu, Jan 3, 2013 at 2:26 PM, Sam Williams iam.samw@gmail.com> wrote:
>
>> I get:
>> Stock Market Functions add-in, Version 2.1.2012.12.29 (C:\Program Files
>> (x86)\SMF Add-in; 1) Error MSN;% Growth Rate -- Dividends (5-Year
>> Annual Average) -- Company;
>> http://moneycentral.msn.com/investor/research/sreport.asp?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=~~~~~;1;GROWTHRATES %;DIVIDENDS (5-YEAR; ; ;0;0;0;0
>>
>> On Thu, Jan 3, 2013 at 4:12 PM, Randy Harmelink rharmelink@gmail.com>wrote:
>>
>>> =RCHGetElementNumber("Version")
>>> =RCHGetElementNumber("JNJ";,63)
>>> =smfGetAParms(63)
>>>
>>
>
>

Fri Jan 4, 2013 2:39 am (PST) . Posted by:

"Axel Ronnisch" aronnisch

Hi,

i am new to this group and tried to work with the fantastic Option Tracker. But i have a Problem and can't fix it. i tried to add my first options for a test. So far the HPQ was not found. Astonishing, today i got data for HPQ. But some is missing.
I added a written put for HPQ. In the put tab the option price is nott filled. And than the other calculations are not done. And for other puts i tried, it is the same.
I am working with a german excel version. Maybe it has someting to do with the transformation of fucntiosn from english to german and maybe with the different kind of the date representation US vs German.

How can i fix it?
Please give advice

best wishes
Axel
Diposting oleh EXCEL FEED LEARNING di 03.48

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)