Kamis, 26 Januari 2012

[smf_addin] Digest Number 2089

Messages In This Digest (14 Messages)

Messages

1a.

Re: SMF-Template-SMFTech-Beta.xls

Posted by: "draz2121" bolony21@gmail.com   draz2121

Wed Jan 25, 2012 5:08 am (PST)



Thanks, I will find a workaround.

I would however like the ability to extend the history to approx 6 months of daily data.

Please can you advise if/how this is possible as currently only 60 working days (approx).

Thanks.

Shaun

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

Re: SMF-Template-SMFTech-Beta.xls

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

Wed Jan 25, 2012 5:13 am (PST)



Just array-enter the formulas over larger ranges...

On Wed, Jan 25, 2012 at 6:08 AM, draz2121 <bolony21@gmail.com> wrote:

I would however like the ability to extend the history to approx 6
months of daily data.

Please can you advise if/how this is possible as currently only 60
working days (approx).

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

Re: SMF-Template-SMFTech-Beta.xls

Posted by: "draz2121" bolony21@gmail.com   draz2121

Wed Jan 25, 2012 5:30 am (PST)



I'm sorry but I'm no expert here but I'm trying.

The first 5 columns contain {=RCHGetYahooHistory(B4,,,,,,,,,,1,1)}

Columns H onwards contain {=SMFTech($B$6:$G$65,H2,H3,H4,H5)}

I changed the $G$65 to $G$150 and copied down all cells from row 65 to 150 but this does not work.

Shaun

--- In smf_addin@yahoogroups.com, "Randy H" <rharmelink@...> wrote:
>
> Just array-enter the formulas over larger ranges...
>
> On Wed, Jan 25, 2012 at 6:08 AM, draz2121 <bolony21@...> wrote:
>
> I would however like the ability to extend the history to approx 6
> months of daily data.
>
> Please can you advise if/how this is possible as currently only 60
> working days (approx).
>

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

Re: SMF-Template-SMFTech-Beta.xls

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

Wed Jan 25, 2012 5:51 am (PST)



You can't "copy down". You have to array-enter the formula over the
entire range, at once.

To array-enter a formula in EXCEL, first highlight the range of cells
where you would like the returned data to appear. Next, type in (or
paste in and edit) your formula and then press Ctrl-Shift-Enter (instead
of Enter).

On Wed, Jan 25, 2012 at 6:30 AM, draz2121 <bolony21@...> wrote:
I'm sorry but I'm no expert here but I'm trying.

The first 5 columns contain {=RCHGetYahooHistory(B4,,,,,,,,,,1,1)}

Columns H onwards contain {=SMFTech($B$6:$G$65,H2,H3,H4,H5)}

I changed the $G$65 to $G$150 and copied down all cells from row 65 to
150 but this does not work.

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

Re: SMF-Template-SMFTech-Beta.xls

Posted by: "draz2121" bolony21@gmail.com   draz2121

Wed Jan 25, 2012 6:51 am (PST)



Thanks, that did the trick :)

--- In smf_addin@yahoogroups.com, "Randy H" <rharmelink@...> wrote:
>
> You can't "copy down". You have to array-enter the formula over the
> entire range, at once.
>
> To array-enter a formula in EXCEL, first highlight the range of cells
> where you would like the returned data to appear. Next, type in (or
> paste in and edit) your formula and then press Ctrl-Shift-Enter (instead
> of Enter).
>
> On Wed, Jan 25, 2012 at 6:30 AM, draz2121 <bolony21@> wrote:
> I'm sorry but I'm no expert here but I'm trying.
>
> The first 5 columns contain {=RCHGetYahooHistory(B4,,,,,,,,,,1,1)}
>
> Columns H onwards contain {=SMFTech($B$6:$G$65,H2,H3,H4,H5)}
>
> I changed the $G$65 to $G$150 and copied down all cells from row 65 to
> 150 but this does not work.
>

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

Gujarat Auto Industry & Narendra modi's proactive leadership

Posted by: "mdkumar kumar" mdkumarz@gmail.com   mdkumarz

Wed Jan 25, 2012 8:19 am (PST)



High quality global journalism requires investment. Please share this
article with others using the link below, do not cut & paste the article.
See our Ts&Cs <http://www.ft.com/servicestools/help/terms> and Copyright
Policy <http://www.ft.com/servicestools/help/copyright> for more detail.
Email ftsales.support@ft.com to buy additional rights.
http://www.ft.com/cms/s/0/c3edd1f0-4054-11e1-9bce-00144feab49a.html#ixzz1kUETT09u

Car industry: Global drive fuels Modi's Motown

By Neil Munshi
[image: Ford Figo]

Made in India: the Ford Figo is shipped to 50 other countries

In the middle of a strike at Maruti
Suzuki<http://markets.ft.com/tearsheets/performance.asp?s=in:MARUTI>'s
main factory that would cost India's largest carmaker $500m in lost
production, the company negotiated a deal to invest $1bn in new facilities
on the subcontinent.

It was an unusual move, but – despite the troubles it and many other
companies have had in India – Maruti was confident its new plant would roll
out on time and without any hitches, for one reason: it will be built in
the western state of Gujarat.
More ON THIS STORY

- Overview Undimmed ambition as economy's lights
flicker<http://www.ft.com/cms/s/0/a3857a96-429b-11e1-97b1-00144feab49a.html>
- Economy Debate over growth after fight to trim inflation
rate<http://www.ft.com/cms/s/0/3fd69730-3ec4-11e1-9da2-00144feab49a.html>
- Airlines Ailing private carriers get that sinking
feeling<http://www.ft.com/cms/s/0/a411d150-4055-11e1-9bce-00144feab49a.html>
- Retailing Problems in store for ambitious
incomers<http://www.ft.com/cms/s/0/6f56fa44-4055-11e1-9bce-00144feab49a.html>
- Online shopping Web takes hassle out of bringing up
baby<http://www.ft.com/cms/s/0/3cd92332-403f-11e1-82f6-00144feab49a.html>

IN INDIA AND GLOBALISATION 2012

- Higher education Students forced to play numbers
game<http://www.ft.com/cms/s/0/c4d2a292-40ec-11e1-b521-00144feab49a.html>
- Outsourcing New aims are set but old image dies
hard<http://www.ft.com/cms/s/0/4558f8c4-4121-11e1-8c33-00144feab49a.html>
- Energy Rush to buy foreign coal
assets<http://www.ft.com/cms/s/0/7b49c698-4121-11e1-8c33-00144feab49a.html>
- Corporate profile Ratan
Tata<http://www.ft.com/cms/s/0/b4920e56-4121-11e1-8c33-00144feab49a.html>

Ever since Tata
Motors<http://markets.ft.com/tearsheets/performance.asp?s=in:TATAMOTORS>
was
unceremoniously ousted from the eastern state of West Bengal in 2008 over a
land dispute, and successfully relocated to Gujarat, the state – and its
controversial chief minister, Narendra Modi – have become known for their
business-friendly, anti-union environment and emerged as India's answer to
Detroit of the US.

"The main reason is because of the initiatives that have been undertaken by
the chief minister," says Yaresh Kothari, auto analyst for Angel Broking.
"He has been very proactive about inviting industrialists to the state and
offering them quick access to land, which has become a major problem in the
country."

This year alone,
Ford<http://markets.ft.com/tearsheets/performance.asp?s=us:F> and
Peugeot Citroen have joined Maruti and Tata in making massive investments
in the state, drawn in by attractive tax incentives, improved
infrastructure and a streamlined land acquisition and approvals process
absent from many other states in a country that seems to relish
bureaucratic red tape.

Last year saw growth in the industry fall to an anaemic 4.3 per cent on the
back of high interest rates, Maruti's production problems and a general
slowdown in the domestic economy, after two consecutive years at around 30
per cent.

But India remains one of the world's fastest growing, and most attractive,
auto markets. Gujarat's pro-business mentality makes it more attractive
still, removing the uncertainty many foreign, and domestic, companies face
when entering Asia's third-largest economy.

In 2008, Tata Motors learnt first-hand how India's fickle political winds
can turn a done deal into a dead deal when construction of its plant in
Sringur, West Bengal was halted by weeks of violent protest by local
farmers.

The protests by the farmers – who claimed they had been forced to give up
their land and had not received sufficient compensation – were stoked by
Mamata Banerjee, then West Bengal's opposition leader, and now chief
minister.

Tata shut down construction, though the plant – which was meant to produce
the low-cost Nano – was around 85 per cent complete, and two years later
announced the launch of its plant in the village of Sanand, Gujarat.

Part of the $500m investment included a 375-acre "vendor park" for
suppliers. The park promoted the growth of a supplier ecosystem, and Tata's
smooth acquisition of the land and rollout of the plant gave Gujarat a
reputation as a place where carmakers could do business worry-free.

And so last year foreign companies clamouring to tap into an Indian
market<http://blogs.ft.com/beyond-brics/2012/01/04/delhi-auto-show-a-chance-to-cheer-up/#axzz1kQ2HHlD3>whose
recent hiccups have largely been understood as an anomaly followed suit.

In February Peugeot announced an investment of nearly $800m in Sanand as
part of its aim of generating 50 per cent of its sales outside Europe by
2015, compared with 39 per cent in 2010.

And Ford soon followed, announcing in July its investment of $1bn in a
plant in Sanand that should be in production by 2014, and will have an
initial capacity of 240,000 vehicles. This is more than double the capacity
of the US carmaker's facility in the southern city of Chennai, a popular
destination for carmakers that has lost some of its relevance amid
Gujarat's rise.

At the time, Joe Hinrichs, Ford's head of Asia-Pacific and Africa, said
Gujarat was selected over other states for its geographical location and
ports from which to export cars to other emerging markets. Ford ships the
Figo from India to 50 other countries, including South Africa, Mexico and
the United Arab Emirates.

"Gujarat is well on its way to become the automotive hub as every auto
manufacturer is looking towards the state, thanks to the pro-investment
policies and infrastructure," says Michael Boneham, president and managing
director of Ford India. "When Ford began to consider an additional site to
construct a manufacturing facility in India it was almost impossible to
ignore the impressive changes and progress enacted by the state government
and fast tracked approval process."

Gujarat's port infrastructure was also a big selling point for Maruti when
it announced its $1bn plant investment in September – in 2008, it signed a
$1.75bn joint venture with the state's private Mundra port for a "mega car
terminal" to buoy the company's export plans.

Gujarat could be seen as potentially politically sensitive as Mr Modi, the
state's Hindu nationalist leader and main architect of its economic revival
since 2001, has been criticised for his lax role during the 2002 communal
riots when at least 2,000 people – mainly Muslims – were killed. But few
auto executives have addressed the issue, and it does not seem to have
stopped the industry from accepting his invitations.

There is little doubt that more foreign carmakers will be following suit.

--
Yours sincerely,
Draksharamam Kumar Mandavilli
mdkumarz@gmail.com,
91-7737255159
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
3.

Toronto Stock Exchange (TSX)

Posted by: "BGP" bengp@shaw.ca   pedretb

Wed Jan 25, 2012 12:32 pm (PST)



Hello,

I am new to your group and very impressed with smf add-in. Thank you for
making that possible.

Do any of the members have experience with accessing data (historical) for
Canadian listed stocks on the TSX. Some Canadian stocks are listed on the
NYSE, but many are not. My apologies in advance if this question has been
asked before.

Cheers,

Ben P

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of draz2121
Sent: Wednesday, January 25, 2012 6:52 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: SMF-Template-SMFTech-Beta.xls

Thanks, that did the trick :)

--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
"Randy H" <rharmelink@...> wrote:
>
> You can't "copy down". You have to array-enter the formula over the
> entire range, at once.
>
> To array-enter a formula in EXCEL, first highlight the range of cells
> where you would like the returned data to appear. Next, type in (or
> paste in and edit) your formula and then press Ctrl-Shift-Enter (instead
> of Enter).
>
> On Wed, Jan 25, 2012 at 6:30 AM, draz2121 <bolony21@> wrote:
> I'm sorry but I'm no expert here but I'm trying.
>
> The first 5 columns contain {=RCHGetYahooHistory(B4,,,,,,,,,,1,1)}
>
> Columns H onwards contain {=SMFTech($B$6:$G$65,H2,H3,H4,H5)}
>
> I changed the $G$65 to $G$150 and copied down all cells from row 65 to
> 150 but this does not work.
>

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

Is yahoo VOLUME split-adjusted?

Posted by: "pharnsbe" harnsberger@gmail.com   pharnsbe

Wed Jan 25, 2012 5:37 pm (PST)



I think my previous post wasn't worded clearly...

What I'm trying to figure out is whether or not yahoo split-adjusts their VOLUME data.

For example, suppose stock ABCD trades 100,000 shares on January 15th 2009. The closing price on that day is $50 per share. The $volume on this day would be $5,000,000.

A few years later the price has run all the way up to $200, so ABCD does a 5:1 split, bringing the share price down to $40.

Yahoo then split-adjusts all prior prices, showing ABCD adjusted-close on 1/15/2009 = $10.

Now if you were to multiply $10 * 100,000 shares, you'd get $volume at $1,000,000, which is not the correct $volume that historically occurred on that day. The reason is the VOLUME also needs to be split-adjusted. The correct split-adjusted volume for 1/15/2009 would be 500,000 (100,000 * 5).

So I realize yahoo does a great job of adjusting closing prices for splits and dividends, but does anyone know if they are adjusting historical volume levels for splits?

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

Re: Is yahoo VOLUME split-adjusted?

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

Wed Jan 25, 2012 5:50 pm (PST)



I would lean towards saying no, volume is not adjusted. Simply because they
currently do O/H/L/C "as is", adding the adjusted close so those can be
adjusted if desired. So I would suspect volume is "as is" as well. Because
there would be no way to "undo" the adjustment of volume if they had
adjusted it -- adjusted closing price couldn't be used, because that's a
combination of split and dividend adjustments, and dividend adjustments
wouldn't apply to volume.

One way to check would be to go to a printed source of a daily quote on a
stock prior to when it had splits, and see if it matches the Yahoo volume.

On Wed, Jan 25, 2012 at 6:37 PM, pharnsbe <harnsberger@gmail.com> wrote:

> I think my previous post wasn't worded clearly...
>
> What I'm trying to figure out is whether or not yahoo split-adjusts their
> VOLUME data.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
4c.

Re: Is yahoo VOLUME split-adjusted?

Posted by: "james morlock" JimMorlock@optonline.net   kagawonger

Wed Jan 25, 2012 6:02 pm (PST)




Are you seeing volume expressed as a dollar value somewhere on Yahoo?
Volume is normally expressed as the number of shares traded and I dont
see the historical volume (# of shares traded) changing with a stock
split.

On Wed, Jan 25, 2012 at 8:37 PM, pharnsbe wrote:

I think my previous post wasn't worded clearly...

What I'm trying to figure out is whether or not yahoo split-adjusts
their VOLUME data.

For example, suppose stock ABCD trades 100,000 shares on January 15th
2009. The closing price on that day is $50 per share. The $volume on
this day would be $5,000,000.

A few years later the price has run all the way up to $200, so ABCD does
a 5:1 split, bringing the share price down to $40.

Yahoo then split-adjusts all prior prices, showing ABCD adjusted-close
on 1/15/2009 = $10.

Now if you were to multiply $10 * 100,000 shares, you'd get $volume at
$1,000,000, which is not the correct $volume that historically occurred
on that day. The reason is the VOLUME also needs to be split-adjusted.
The correct split-adjusted volume for 1/15/2009 would be 500,000
(100,000 * 5).

So I realize yahoo does a great job of adjusting closing prices for
splits and dividends, but does anyone know if they are adjusting
historical volume levels for splits?

<http://docs.yahoo.com/info/terms/>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
4d.

Re: Is yahoo VOLUME split-adjusted?

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Wed Jan 25, 2012 6:33 pm (PST)



In your example all you have to do is multiply the unadjusted closing price
by the number of shares for the actual dollar volume if the volume amount is
not adjusted.

I don't think Yahoo adjusts past volume. If you look at their historical
data page, only the Adjusted Closing price is marked with an asterisk to
indicate it's adjusted by dividends and splits. Which would lead to another
question - would past volume be adjusted only by splits but also dividends?

http://finance.yahoo.com/q/hp?s=SXL+Historical+Prices

I show SXL as an example of something that's split recently.

To be sure, note Yahoo's volume data for something that's due to split and
check afterwards. This page shows upcoming ones:
http://finance.yahoo.com/q?s=cog <http://finance.yahoo.com/q?s=cog&ql=1>
&ql=1

In fact, COG is supposed to split tomorrow and I just noted the Jan 25
volume is 5,384,800 so check tomorrow.

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of pharnsbe
Sent: Wednesday, January 25, 2012 8:37 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Is yahoo VOLUME split-adjusted?

I think my previous post wasn't worded clearly...

What I'm trying to figure out is whether or not yahoo split-adjusts their
VOLUME data.

For example, suppose stock ABCD trades 100,000 shares on January 15th 2009.
The closing price on that day is $50 per share. The $volume on this day
would be $5,000,000.

A few years later the price has run all the way up to $200, so ABCD does a
5:1 split, bringing the share price down to $40.

Yahoo then split-adjusts all prior prices, showing ABCD adjusted-close on
1/15/2009 = $10.

Now if you were to multiply $10 * 100,000 shares, you'd get $volume at
$1,000,000, which is not the correct $volume that historically occurred on
that day. The reason is the VOLUME also needs to be split-adjusted. The
correct split-adjusted volume for 1/15/2009 would be 500,000 (100,000 * 5).

So I realize yahoo does a great job of adjusting closing prices for splits
and dividends, but does anyone know if they are adjusting historical volume
levels for splits?

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

Re: [Bulk] RE: [smf_addin] Is yahoo VOLUME split-adjusted?

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Wed Jan 25, 2012 6:35 pm (PST)



Oops, sorry, the link for upcoming splits should be:
http://biz.yahoo.com/c/s.html

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Mike McQuaid
Sent: Wednesday, January 25, 2012 9:33 PM
To: smf_addin@yahoogroups.com
Subject: [Bulk] RE: [smf_addin] Is yahoo VOLUME split-adjusted?

In your example all you have to do is multiply the unadjusted closing price
by the number of shares for the actual dollar volume if the volume amount is
not adjusted.

I don't think Yahoo adjusts past volume. If you look at their historical
data page, only the Adjusted Closing price is marked with an asterisk to
indicate it's adjusted by dividends and splits. Which would lead to another
question - would past volume be adjusted only by splits but also dividends?

http://finance.yahoo.com/q/hp?s=SXL+Historical+Prices

I show SXL as an example of something that's split recently.

To be sure, note Yahoo's volume data for something that's due to split and
check afterwards. This page shows upcoming ones:
http://finance.yahoo.com/q?s=cog <http://finance.yahoo.com/q?s=cog&ql=1>
&ql=1

In fact, COG is supposed to split tomorrow and I just noted the Jan 25
volume is 5,384,800 so check tomorrow.

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of pharnsbe
Sent: Wednesday, January 25, 2012 8:37 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Is yahoo VOLUME split-adjusted?

I think my previous post wasn't worded clearly...

What I'm trying to figure out is whether or not yahoo split-adjusts their
VOLUME data.

For example, suppose stock ABCD trades 100,000 shares on January 15th 2009.
The closing price on that day is $50 per share. The $volume on this day
would be $5,000,000.

A few years later the price has run all the way up to $200, so ABCD does a
5:1 split, bringing the share price down to $40.

Yahoo then split-adjusts all prior prices, showing ABCD adjusted-close on
1/15/2009 = $10.

Now if you were to multiply $10 * 100,000 shares, you'd get $volume at
$1,000,000, which is not the correct $volume that historically occurred on
that day. The reason is the VOLUME also needs to be split-adjusted. The
correct split-adjusted volume for 1/15/2009 would be 500,000 (100,000 * 5).

So I realize yahoo does a great job of adjusting closing prices for splits
and dividends, but does anyone know if they are adjusting historical volume
levels for splits?

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

Re: Is yahoo VOLUME split-adjusted?

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

Wed Jan 25, 2012 6:40 pm (PST)



A cash dividend shouldn't affect the number of shares. It does reduce
the assets of the company, so something like book value per share
should go down.

A stock dividend would affect the number of shares. But, usually, a 5%
stock dividend is also called a 21-20 stock split. So it could depend on
whose terminology is being used. :(

On Wed, Jan 25, 2012 at 7:33 PM, Mike McQuaid <mikemcq802@yahoo.com>
wrote:

Which would lead to another question - would past volume be adjusted
only by splits but also dividends?

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

Re: Is yahoo VOLUME split-adjusted?

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Wed Jan 25, 2012 6:46 pm (PST)



No, I agree a cash dividend shouldn't. And, perhaps that answers the
question - at least for the calculation that the OP had.

Since Yahoo's adjusted close price is adjusted for cash dividends and splits
then even if volume were adjusted just for splits (and I don't think it is
either) then you wouldn't be multiplying them together to get an accurate
historical dollar volume.

Good point on the stock dividends.

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Randy H
Sent: Wednesday, January 25, 2012 9:40 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Is yahoo VOLUME split-adjusted?

A cash dividend shouldn't affect the number of shares. It does reduce the
assets of the company, so something like book value per share should go
down.

A stock dividend would affect the number of shares. But, usually, a 5% stock
dividend is also called a 21-20 stock split. So it could depend on whose
terminology is being used. :(

On Wed, Jan 25, 2012 at 7:33 PM, Mike McQuaid <mikemcq802@yahoo.com> wrote:

Which would lead to another question - would past volume be adjusted only by
splits but also dividends?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

New business?

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! News

Get it all here

Breaking news to

entertainment news

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
Diposting oleh EXCEL FEED LEARNING di 02.44

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)