9 New Messages
Digest #2409
Messages
Thu Nov 22, 2012 5:53 am (PST) . Posted by:
"dguillett1" donaldb36
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.com
Regards,
Bill Blaylock
The White moose ( or Meese) are on the tail end
of this.
Be sure to go all way through the pictures on this one:
Keep going to see the snow moose
They can't have my apple.
OK, I'm curious.
Oh, you're not like the thing I just sniffed,
What are you?
Mom's going to be mad, but I would like to stay.
Oh, yes! I know mother-love in any form.
Very nice.
Beautiful Snow Moose. A must see.
You probably won't see this again in your life time!
"Be sure to show this to your children or grandchildren."
Look behind the moose on the left
I'm glad you came by. You never would have
believed me if you hadn't seen it for yourself.
These animals were photographed just north of the
Wisconsin border on a highway near Marenisco , MI .
Once in awhile there is an opportunity to take in a piece
of nature that you may never see.
Absolutely stunning!
The driver is really wishing his camera was handy.
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.
Regards,
Bill Blaylock
The White moose ( or Meese) are on the tail end
of this.
Be sure to go all way through the pictures on this one:
Keep going to see the snow moose
They can't have my apple.
OK, I'm curious.
Oh, you're not like the thing I just sniffed,
What are you?
Mom's going to be mad, but I would like to stay.
Oh, yes! I know mother-love in any form.
Very nice.
Beautiful Snow Moose. A must see.
You probably won't see this again in your life time!
"Be sure to show this to your children or grandchildren."
Look behind the moose on the left
I'm glad you came by. You never would have
believed me if you hadn't seen it for yourself.
These animals were photographed just north of the
Wisconsin border on a highway near Marenisco , MI .
Once in awhile there is an opportunity to take in a piece
of nature that you may never see.
Absolutely stunning!
The driver is really wishing his camera was handy.
Thu Nov 22, 2012 5:56 am (PST) . Posted by:
"dguillett1" donaldb36
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.
Regards,
Bill Blaylock
From:
To:
Cc:
Subject: Fw: More cool photos ....
A seahorse inspects a diver's watch
1
An illuminated snow tunnel in Russia
2
Everybody was kung fu fighting
3
The honeybee's final sting
4
Street artist Sainer goes big in Poland
5
Mount Rainier casting a shadow on clouds
6
First contact
7
The Irish Sky Garden crater
8
Moon bridge in Dahu Park, Taipei
9
Flight of the devil rays
10
Gásadalur Village in the Faroe Islands
11
World's edge
12
The Capilano suspension bridge in Vancouver
13
Fractal patterns in dried out desert rivers
14
Meditating monks at Pongour Falls
15
A sunset eclipse
16
Bora Bora from space
17
The largest raft of canoes and kayaks in the world
18
Adaptive roots in the concrete jungle
19
The Hamilton Pool Nature Preserve
20
Above the canopy
21
Colliding rivers in Geneva, Switzerland
22
The stunning green vine snake
23
Aurora australis (southern lights) from space
24
Mount Kilimanjaro from above
25
The amazing strength of an ant
26
Yarn bombing a bus in Mexico City
27
Felix Baumgartner jumps from 71,580 feet
28
The most incredible aurora of 2012
29
The Waterfall Island at Iguazu Falls
30
Overgrown railroad tracks in the forest
31
A pod of sleeping sperm whales
32
7 hours in one image
33
Pixel people perfection
34
Galactic monsoon
35
Striking artistry of multiple takeoffs at Hannover Airport
36
Sailing like a boss
37
A sea of purple in the badlands of Utah
38
Putting the size of a whale in perspective
39
Meanwhile in Switzerland
40
One boat and 145 water-skiers
41
Salar de Uyuni after some rain
42
Outdoor jacuzzi on the Matterhorn
43
The precious blue marble
44
Maelstrom at Kauai , Hawaii
45
Capsized cruise ship Costa Concordia from space
46
Serenity now
47
ROFLMAO
48
Beautiful Bern from above
49
Thu Nov 22, 2012 5:59 am (PST) . Posted by:
"dguillett1" donaldb36
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.
Regards,
Bill Blaylock
From:
Sent: Monday, November 19, 2012 7:01 PM
Subject: FW: Voted best chewing gum commercial in Europe
------------
From:
Subject: Fw: Voted best chewing gum commercial in Europe
Date: Wed, 14 Nov 2012 20:21:59 -0600
>
Attachments with this message:
1 of 1 File(s)
Thu Nov 22, 2012 6:00 am (PST) . Posted by:
"dguillett1" donaldb36
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.
From: alfacarol
I Hope Your Day
Is Gooder Than Yesterday..
Amazing Photos
Isn't it beautiful?
Paradise Tanager...mostly found in South America
At Wat Samphran (??????????) in Nakhon Pathom Province there is a 17 storey building that has a giant dragon climbing to the roof. The head is at the top where there is a shrine and the tail is on the ground floor. The dragon is hollow and it is possible to walk up some sections of it.
This house was designed by Rudy Ricciotti. The unique architecture includes a pool house, which is like a window in the living room where you can enjoy not only swimming in the water, but the person swimming in it with the effect of the outdoor landscape which is reflected through the window.
The Aiguille du Midi cable car leaves from the centre of Chamonix. It takes visitors up to 3842m for a stunning view of the French Swiss and Italian alps. —
Paradise! Jungfrau Mountain Range, Switzerland
Hallgrímskirkja (244 ft), is the largest church and the sixth tallest architectural structure in Iceland...
The Melisanni Cave, GreeceThis beautiful cave, which was discovered in 1951 and is surrounded by forests, features in Greek mythology as the cave of the nymphs.
Thermal baths inside a cave - Miskolc Tapolca, Hungary
New Town Hall in Hanover, Germany.
Piva Canyon, Bosnia and Herzegovina
Lake Mellisani on the island of Kephalonia Greece
Manarola, Italy..
The Grand Canyon Skywalk
The Grand Canyon Skywalk is a transparent horseshoe-shaped cantilever bridge and tourist attraction in Arizona near the Colorado River on the edge of a side canyon in the Grand Canyon West area of the main canyon. USGS topographic maps show the elevation at the Skywalk's location as 4,770 ft (1,450 m) and the elevation of the Colorado River
In the base of the canyon as 1,160 ft (350 m), and they show that the height of the precisely vertical drop directly under the skywalk is between 500 ft (150 m) and 800 ft (240 m).
Commissioned and owned by the Hualapai Indian tribe, it was unveiled March 20, 2007, and opened to the general public on March 28, 2007. It is accessed via the Grand Canyon West Airport terminal or a 120-mile (190 km) drive from Las Vegas, which includes a 10-mile (16 km) stretch of dirt road which is currently under development. The Skywalk is east of Meadview and north of Peach Springs with Kingman being the closest major city.
Palawan Underground River or St. Paul Subterranean River – Longest Navigable Underground River in the World
This is the most famous cave in the Philippines. The longest underground river was discovered a few years back in Mexico somewhere in the Yucatan. St. Paul Underground River in Palawan, Philippines may not be the longest underground river in the world anymore, but it is still the world's longest navigable underground river. The navigable part of the river inside the cave of the 4000-acre St. Paul Subterranean River stretches 15 kilometers in length (5 miles). St. Paul Cave is the 3rd deepest cave in the country —
The Seven Sisters (Norwegian: De Syv Søstrene or Dei Sju Systrene, also known as Knivsflåfossen) is the 39th tallest waterfall in Norway.
Plitvice Lakes National Park in the Lika region of Croatia.
View from hotel window in the United Arab Emirates!
Jasper Park Lodge, Jasper Alberta, Canada
Villas Vista Hermosa, Costa Rica
Amazing Norway!!!
Sea Caves near Benagil Beach, Algarve, Portugal.
Amazing Constructions.
Beautiful village of Hallstatt - Austria :
The beautiful Victoria Water Falls
Beautiful Display Of The Balance Between Predators & Prey In Nature :)
Thu Nov 22, 2012 10:08 am (PST) . Posted by:
"Guest" michaelmcintyre2000
I seem to get errors attempting to pull option quotes from MSN. For reference, I've attempted to match the examples below as close as possible to the function's on-line documentation.
As of 22-Nov-2012:
=smfGetYahooOptionQuote("SPY","C","12/22/2012","139.00","b")
Correctly returns 2.41.
=smfGetOXOptionQuote("SPY","C","12/22/2012","139.00","b")
Correctly returns 2.41.
=smfGetGoogleOptionQuote("SPY","C","12/22/2012","139.00","b")
Correctly returns 2.41.
=smfGetMSNOptionQuote("SPY","C","12/22/2012","139.00","b")
Fails, returns "Error".
I am unable to successfully pull any option quotes from MSN.
So, "why not use one of the other sites?" you may ask? I'm trying to pull put data, so that limits the usage to two of the functions, Yahoo or MSN. It turns out that, in some instances, Yahoo does not post data for all of the active strikes.
For example,
=smfGetYahooOptionQuote("OXM","P","12/22/2012","40.00","b")
returns an error because the strike does not exist on the Yahoo site. Both the put strike above, Dec45p, and below, Dec35p, return the correct information. However, the Dec40p strike is available on MSN.
Thanks.
As of 22-Nov-2012:
=smfGetYahooOptionQ
Correctly returns 2.41.
=smfGetOXOptionQuot
Correctly returns 2.41.
=smfGetGoogleOption
Correctly returns 2.41.
=smfGetMSNOptionQuo
Fails, returns "Error".
I am unable to successfully pull any option quotes from MSN.
So, "why not use one of the other sites?" you may ask? I'm trying to pull put data, so that limits the usage to two of the functions, Yahoo or MSN. It turns out that, in some instances, Yahoo does not post data for all of the active strikes.
For example,
=smfGetYahooOptionQ
returns an error because the strike does not exist on the Yahoo site. Both the put strike above, Dec45p, and below, Dec35p, return the correct information. However, the Dec40p strike is available on MSN.
Thanks.
Thu Nov 22, 2012 11:10 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Which version of the add-in are you using?
=smfGetMSNOptionQuote("SPY","C","12/22/2012","139.00","b")
...works fine for me. However, I did have to make a change back in February
because of MSN URL changes:
http://finance.groups.yahoo.com/group/smf_addin/message/17506
So you probably need the beta version of the add-in from the "Works in
Progress" folder to get the MSN options to work. That's currently version
2.1.2012.07.12 of the add-in.
Changes made since the last official release:
http://finance.groups.yahoo.com/group/smf_addin/files/Works-In-Progress/%40Change-Log.html
On Thu, Nov 22, 2012 at 11:08 AM, Guest <michaelmcintyre2000@yahoo.com >wrote:
> I seem to get errors attempting to pull option quotes from MSN. For
> reference, I've attempted to match the examples below as close as possible
> to the function's on-line documentation.
>
> As of 22-Nov-2012:
>
> =smfGetYahooOptionQuote("SPY","C","12/22/2012","139.00","b")
> Correctly returns 2.41.
>
> =smfGetOXOptionQuote("SPY","C","12/22/2012","139.00","b")
> Correctly returns 2.41.
>
> =smfGetGoogleOptionQuote("SPY","C","12/22/2012","139.00","b")
> Correctly returns 2.41.
>
> =smfGetMSNOptionQuote("SPY","C","12/22/2012","139.00","b")
> Fails, returns "Error".
>
> I am unable to successfully pull any option quotes from MSN.
>
> So, "why not use one of the other sites?" you may ask? I'm trying to pull
> put data, so that limits the usage to two of the functions, Yahoo or MSN.
> It turns out that, in some instances, Yahoo does not post data for all of
> the active strikes.
>
> For example,
> =smfGetYahooOptionQuote("OXM","P","12/22/2012","40.00","b")
> returns an error because the strike does not exist on the Yahoo site.
> Both the put strike above, Dec45p, and below, Dec35p, return the correct
> information. However, the Dec40p strike is available on MSN.
>
=smfGetMSNOptionQuo
...works fine for me. However, I did have to make a change back in February
because of MSN URL changes:
http://finance.
So you probably need the beta version of the add-in from the "Works in
Progress" folder to get the MSN options to work. That's currently version
2.1.2012.07.
Changes made since the last official release:
http://finance.
On Thu, Nov 22, 2012 at 11:08 AM, Guest <michaelmcintyre2000
> I seem to get errors attempting to pull option quotes from MSN. For
> reference, I've attempted to match the examples below as close as possible
> to the function's on-line documentation.
>
> As of 22-Nov-2012:
>
> =smfGetYahooOptionQ
> Correctly returns 2.41.
>
> =smfGetOXOptionQuot
> Correctly returns 2.41.
>
> =smfGetGoogleOption
> Correctly returns 2.41.
>
> =smfGetMSNOptionQuo
> Fails, returns "Error".
>
> I am unable to successfully pull any option quotes from MSN.
>
> So, "why not use one of the other sites?" you may ask? I'm trying to pull
> put data, so that limits the usage to two of the functions, Yahoo or MSN.
> It turns out that, in some instances, Yahoo does not post data for all of
> the active strikes.
>
> For example,
> =smfGetYahooOptionQ
> returns an error because the strike does not exist on the Yahoo site.
> Both the put strike above, Dec45p, and below, Dec35p, return the correct
> information. However, the Dec40p strike is available on MSN.
>
Thu Nov 22, 2012 3:21 pm (PST) . Posted by:
"Michael McIntyre" michaelmcintyre2000
Thanks Randy. That was it.
________________________________
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Thursday, November 22, 2012 11:10 AM
Subject: Re: [smf_addin] Is smfGetMSNOptionQuote() broken?
Which version of the add-in are you using?
=smfGetMSNOptionQuote("SPY","C","12/22/2012","139.00","b")
...works fine for me. However, I did have to make a change back in February because of MSN URL changes:
http://finance.groups.yahoo.com/group/smf_addin/message/17506
So you probably need the beta version of the add-in from the "Works in Progress" folder to get the MSN options to work. That's currently version 2.1.2012.07.12 of the add-in.
Changes made since the last official release:
http://finance.groups.yahoo.com/group/smf_addin/files/Works-In-Progress/%40Change-Log.html
On Thu, Nov 22, 2012 at 11:08 AM, Guest <michaelmcintyre2000@yahoo.com > wrote:
I seem to get errors attempting to pull option quotes from MSN. For reference, I've attempted to match the examples below as close as possible to the function's on-line documentation.
>
>As of 22-Nov-2012:
>
>=smfGetYahooOptionQuote("SPY","C","12/22/2012","139.00","b")
>Correctly returns 2.41.
>
>=smfGetOXOptionQuote("SPY","C","12/22/2012","139.00","b")
>Correctly returns 2.41.
>
>=smfGetGoogleOptionQuote("SPY","C","12/22/2012","139.00","b")
>Correctly returns 2.41.
>
>=smfGetMSNOptionQuote("SPY","C","12/22/2012","139.00","b")
>Fails, returns "Error".
>
>I am unable to successfully pull any option quotes from MSN.
>
>So, "why not use one of the other sites?" you may ask? I'm trying to pull put data, so that limits the usage to two of the functions, Yahoo or MSN. It turns out that, in some instances, Yahoo does not post data for all of the active strikes.
>
>For example,
>=smfGetYahooOptionQuote("OXM","P","12/22/2012","40.00","b")
>returns an error because the strike does not exist on the Yahoo site. Both the put strike above, Dec45p, and below, Dec35p, return the correct information. However, the Dec40p strike is available on MSN.
>
____________
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Thursday, November 22, 2012 11:10 AM
Subject: Re: [smf_addin] Is smfGetMSNOptionQuot
Which version of the add-in are you using?
=smfGetMSNOptionQuo
...works fine for me. However, I did have to make a change back in February because of MSN URL changes:
http://finance.
So you probably need the beta version of the add-in from the "Works in Progress" folder to get the MSN options to work. That's currently version 2.1.2012.07.
Changes made since the last official release:
http://finance.
On Thu, Nov 22, 2012 at 11:08 AM, Guest <michaelmcintyre2000
I seem to get errors attempting to pull option quotes from MSN. For reference, I've attempted to match the examples below as close as possible to the function's on-line documentation.
>
>As of 22-Nov-2012:
>
>=smfGetYahooOption
>Correctly returns 2.41.
>
>=smfGetOXOptionQuo
>Correctly returns 2.41.
>
>=smfGetGoogleOptio
>Correctly returns 2.41.
>
>=smfGetMSNOptionQu
>Fails, returns "Error".
>
>I am unable to successfully pull any option quotes from MSN.
>
>So, "why not use one of the other sites?" you may ask? I'm trying to pull put data, so that limits the usage to two of the functions, Yahoo or MSN. It turns out that, in some instances, Yahoo does not post data for all of the active strikes.
>
>For example,
>=smfGetYahooOption
>returns an error because the strike does not exist on the Yahoo site. Both the put strike above, Dec45p, and below, Dec35p, return the correct information. However, the Dec40p strike is available on MSN.
>
Thu Nov 22, 2012 1:38 pm (PST) . Posted by:
"chad.touchberry" chad.touchberry
I have been trying to get stock exchange data in with my searches. I have been using:
=RCHGetElementNumber(Ticker,3)
When I run this search I get an "Error" typed in the cell. After searching the forum I installed the latest update in "Works In Progress" and I am still getting the "Error". Any suggestions?
=RCHGetElementNumbe
When I run this search I get an "Error" typed in the cell. After searching the forum I installed the latest update in "Works In Progress" and I am still getting the "Error". Any suggestions?
Thu Nov 22, 2012 1:52 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Hmmm. I just tried:
=RCHGetElementNumber("MMM",3)
...and it worked fine for me. What do you get for:
=RCHGetElementNumber("Version")
=smfGetAParms(3)
On Thu, Nov 22, 2012 at 2:38 PM, chad.touchberry
<chad.touchberry@yahoo.com >wrote:
> I have been trying to get stock exchange data in with my searches. I have
> been using:
> =RCHGetElementNumber(Ticker,3)
>
> When I run this search I get an "Error" typed in the cell. After searching
> the forum I installed the latest update in "Works In Progress" and I am
> still getting the "Error". Any suggestions?
>
=RCHGetElementNumbe
...and it worked fine for me. What do you get for:
=RCHGetElementNumbe
=smfGetAParms(
On Thu, Nov 22, 2012 at 2:38 PM, chad.touchberry
<chad.touchberry@
> I have been trying to get stock exchange data in with my searches. I have
> been using:
> =RCHGetElementNumbe
>
> When I run this search I get an "Error" typed in the cell. After searching
> the forum I installed the latest update in "Works In Progress" and I am
> still getting the "Error". Any suggestions?
>
Tidak ada komentar:
Posting Komentar