Selasa, 29 November 2011

[smf_addin] Digest Number 2030

Messages In This Digest (13 Messages)

Messages

1a.

Re: Cannot pull up a quote for Kinetic concepts  KCI

Posted by: "Pete" petekoch@yahoo.com   petekoch

Mon Nov 28, 2011 5:37 am (PST)



Yahoo! site also returns 0.00 because KCI was acquired by Apax Partners. KCI ceased trading on 11/07/2011.

--- In smf_addin@yahoogroups.com, "Dennis Sesar" <dennis@...> wrote:
>
> I am using the following to try and get a quote for KCI
>
>
>
> RCHGetYahooQuotes(C32,"l1")
>
>
>
> Cell c32 contains KCI. The function returns 0.0. I tried replacing the c32
> with "KCI" but got the same result 0.0. The function is working fine for me
> with many other ticker symbols. My broker shows the symbol as KCI. I
> cannot figure out what I am doing wrong.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
2a.

Re: Insert "Trends in Twitter" chart in BATS Template

Posted by: "paul messerschmidt" financepaul@gmail.com   fuelspotpaul

Mon Nov 28, 2011 7:41 am (PST)



thanks to the many members of this group who continue to alert me to new
tools and apps.

i was previously unaware of trendistic, which has now become a favorite

On Thu, Nov 24, 2011 at 2:40 PM, ronmac17 <ronmac17@yahoo.com> wrote:

> **
>
>
> Randy, I wanted to add a chart from Trendistic
> http://trendistic.indextank.com/ to the BATS realtime template. I used
> this URL from the site
> http://trendistic.indextank.com/_embed-745/ge/_24-hours. My Comment
> inputs were
> =RCHCreateComment("http://trendistic.indextank.com/_embed-745/ge/_24-hours
> ",99,400,190,1)
> No chart shows up. Not sure where I made a mistake. Could you tell what I
> did wrong here.
> Thanks, Ron
>
>
>

--
-----------------------------------------
Paul Messerschmidt
paul.messerschmidt (skype)
+1-813-334-8682 (mobile)
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3a.

SMFForceRecalculation

Posted by: "dstange1978" danielcs@floripa.com.br   dstange1978

Mon Nov 28, 2011 8:58 am (PST)



Is there a way to set the SMFForceRecalculation to run automatically each minute?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
3b.

Re: SMFForceRecalculation

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Nov 28, 2011 9:09 am (PST)



Just write your own VBA timing routine -- Google "VBA onTime" and you
should find lots of examples.

But, seriously, if you need that level of service, you should be using a
paid data provider that offers such data. IMO, it's unfair to place that
burden on a free data provider.

On Mon, Nov 28, 2011 at 9:57 AM, dstange1978 <danielcs@floripa.com.br>wrote:

> Is there a way to set the SMFForceRecalculation to run automatically each
> minute?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
3c.

Re: SMFForceRecalculation

Posted by: "dstange1978" danielcs@floripa.com.br   dstange1978

Mon Nov 28, 2011 11:44 am (PST)



The following message appears:
"Cannot run the macro "E;\test.xlsm'!Start'. The macro may not be available in this workbook or all macros may be disable."
How can I fix this?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Just write your own VBA timing routine -- Google "VBA onTime" and you
> should find lots of examples.
>
> But, seriously, if you need that level of service, you should be using a
> paid data provider that offers such data. IMO, it's unfair to place that
> burden on a free data provider.
>
> On Mon, Nov 28, 2011 at 9:57 AM, dstange1978 <danielcs@...>wrote:
>
> > Is there a way to set the SMFForceRecalculation to run automatically each
> > minute?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
3d.

Re: SMFForceRecalculation

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Nov 28, 2011 12:17 pm (PST)



As the message indicates, you probably don't have macros enabled for the
workbook. Such questions, however, should go to an EXCEL Yahoo group, not
this one.

On Mon, Nov 28, 2011 at 12:44 PM, dstange1978 <danielcs@floripa.com.br>wrote:

> The following message appears:
> "Cannot run the macro "E;\test.xlsm'!Start'. The macro may not be
> available in this workbook or all macros may be disable."
> How can I fix this?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
4a.

Stock screener.xls ticket hypelink each symbol

Posted by: "almondtree" almondtree@yahoo.com   almondtree

Mon Nov 28, 2011 9:19 pm (PST)



I like the cvs of FINVIZ stock screener.xls would like to click on a ticker link it back to FinViz.com to check chart. It there a way to do this in Excel 2010.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4b.

Re: Stock screener.xls ticket hypelink each symbol

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Nov 28, 2011 9:27 pm (PST)



Use the EXCEL HYPERLINK() function to create your own links in a "helper"
column.

On Mon, Nov 28, 2011 at 10:19 PM, almondtree <almondtree@yahoo.com> wrote:

> I like the cvs of FINVIZ stock screener.xls would like to click on a
> ticker link it back to FinViz.com to check chart. It there a way to do this
> in Excel 2010.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
5.

Book Value per share

Posted by: "almondtree" almondtree@yahoo.com   almondtree

Mon Nov 28, 2011 10:12 pm (PST)



From FinViz a cvs on Book Value per Share,Total Assets,Total Liabilites, Total Debt, Total Equity; within last 6 months.
Thanks. Read the Doc.s like Edit links...everything suddenly started working...amazing. Even put Macros on QAT. Using all this for Graham# I put in a =IF(Price<Graham#,"buy","sell")and a Shareholder Equity Book Value number.
Merry Christmas ya'll

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
6a.

Only getting "Error" for MW option retrieval - Yahoo OK

Posted by: "MikeM" mikemcq802@yahoo.com   mikemcq802

Mon Nov 28, 2011 10:44 pm (PST)



Randy, I run this:

smfGetOptionQuotes("INTC DEC 2011 OTM1 C","xsbavi",1,"Y")

and it works fine. But, if I change Y to MW I get updated expiry dates but "Error" for all numeric values (bid, ask, volume, etc).

I went into the Web Query in Excel to verify page retrieval and I got the following debug message:

Line: 1996
Error: Object expected

This was for page:
http://www.marketwatch.com/investing/stock/intc/options

I am using the latest beta version from Nov 23.

Any suggestions?

PS: I've said it before and will say it again - thanks so much for writing and supporting this add-in. It completely changes my approach to investing.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
6b.

Re: Only getting "Error" for MW option retrieval - Yahoo OK

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Nov 28, 2011 11:20 pm (PST)



Looks like MarketWatch has changed two things:

1. Their ticker symbols are different. The expiration date of a ticker
symbols used to have the "yymmdd" version of the date it them. Now, it
appears to be "@ddyy", where "@" is a character representation of the
months (A-L for Jan-Dec for calls, and M-X for Jan-Dec for puts). Other
services do use the letter designation for put/call months, so it's not
unprecendented.

2. They appear to be mixing expiration dates together within a given
month. That will make the OTMn/ITMn choices possibly fail on months where
multiple expiration dates are displayed.

At this point, instead of rushing out to change things, I want to see how
permanent the changes are. Item (1) is easily fixed if they continue that
way. However, item (2) can't be easily fixed. It would then have the same
reliability issues as Yahoo.

I wonder if they switched over to a new source of option quotes that use
the alternative ticker symbols?

It seems like Yahoo, Google, MSN, and MarketWatch each still all have their
own issues with reliability and coverage of option quotes.

In any case, MarketWatch option quotes won't work as things currently are.

On Mon, Nov 28, 2011 at 11:44 PM, MikeM <mikemcq802@yahoo.com> wrote:

> Randy, I run this:
>
> smfGetOptionQuotes("INTC DEC 2011 OTM1 C","xsbavi",1,"Y")
>
> and it works fine. But, if I change Y to MW I get updated expiry dates
> but "Error" for all numeric values (bid, ask, volume, etc).
>
> I went into the Web Query in Excel to verify page retrieval and I got the
> following debug message:
>
> Line: 1996
> Error: Object expected
>
> This was for page:
> http://www.marketwatch.com/investing/stock/intc/options
>
> I am using the latest beta version from Nov 23.
>
> Any suggestions?
>
> PS: I've said it before and will say it again - thanks so much for writing
> and supporting this add-in. It completely changes my approach to investing.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
7a.

Stock screener.xls

Posted by: "almondtree" almondtree@yahoo.com   almondtree

Mon Nov 28, 2011 10:54 pm (PST)



I'm looking for how to get cvs From FinViz on Book Value per Share,Total Assets,Total Liabilites, Total
Debt, Total Equity; within last 6 months.
Thanks. Read the Doc.s like Edit links...everything suddenly started
working...amazing. Even put Macros on QAT. Using all this for Graham# I put in a
=IF(Price<Graham#,"buy","sell")and a Shareholder Equity Book Value number.
Merry Christmas ya'll

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
7b.

Re: Stock screener.xls

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Nov 28, 2011 11:26 pm (PST)



FinViz doesn't carry financial statements data. Check out the "Links" area
of the group. There is a link there that points to information on which
fields are available from FinViz.

On Mon, Nov 28, 2011 at 11:54 PM, almondtree <almondtree@yahoo.com> wrote:

> I'm looking for how to get cvs From FinViz on Book Value per Share,Total
> Assets,Total Liabilites, Total
> Debt, Total Equity; within last 6 months.
> Thanks. Read the Doc.s like Edit links...everything suddenly started
> working...amazing. Even put Macros on QAT. Using all this for Graham# I
> put in a
> =IF(Price<Graham#,"buy","sell")and a Shareholder Equity Book Value number.
> Merry Christmas ya'll
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Get it all here

Breaking news to

entertainment news

Search Ads

Get new customers.

List your web site

in Yahoo! Search.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Diposting oleh EXCEL FEED LEARNING di 02.07

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)