Selasa, 01 Januari 2013

]] XL-mania [[ Digest Number 2544

5 New Messages

Digest #2544
1
Distance & Azimut antara dua koordinat by "ammar maruf" ammar_tenc
2a
Re: sortir data by "Didi An naufal" didiannaufal
2b
Re: sortir data by "hendrik karnadi" hendrikkarnadi
3a
Re: Error pada vlookup by "Amar Maryadi"

Messages

Mon Dec 31, 2012 8:39 am (PST) . Posted by:

"ammar maruf" ammar_tenc

Dear Pakar Xl,

Mohon bantuan untuk fomula distance & Azimut untuk dua koordinat seperti contoh di bawah : 

Koordinat 1   : -1.6161 116.24217
Koordinat 2  : -1.5871 116.21489
Distance 4.4 Km
Azº  317 º derajat

Terima Kasih
Salam, Ammar

Mon Dec 31, 2012 8:39 am (PST) . Posted by:

"Didi An naufal" didiannaufal

Semoga file terlampir sesuai harapan

Mon Dec 31, 2012 8:44 am (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Coba ganti yang diberi huruf tebal (bold) dari 15 menjadi 35
=IF(ISNUMBER(SMALL(IF(B3:B37=E3,ROW(1:35)),ROW(1:35))),OFFSET($C$2,SMALL(IF(B3:B37=E3,ROW(1:35)),ROW(1:35)),0),"")

Salam,
Hendrik Karnadi

________________________________
From: rivo jacob <rivocbs@gmail.com>
To: XL-mania@yahoogroups.com
Sent: Thursday, 27 December 2012, 16:07
Subject: Re: ]] XL-mania [[ sortir data


 
Dear para master,
saya baru bisa bikin yang kecamatan Tajau.
tolong disempurnakan rumusnya yach.
case : kalau pilih "Kintap", hasilnya blank

thanks
Rivo

2012/12/26 Farid Wajedi Pulungan <faridwp@gmail.com>

> 
>Dear master,
> 
>Pertanyaan ini mungkin sudah pernah didiskusikan yang ingin saya
tanyakan :
>
>
>Bagaimana caranya untuk memunculkan nama desa pada kolom
"I1:I18" sesuai dengan nama kecamatan pada kolom "G3" tanpa
menggunakan fasilitas sort filter, tapi dengan formula
> 
>Terlampir file dan database kecamatan dan desa yang dimaksud
> 
>terima kasih ...
>
>--
>Wasalam,
>
>
>Farid W Pulungan

Mon Dec 31, 2012 8:41 am (PST) . Posted by:

"Amar Maryadi"

Coba kalau paki rumus ini, mudah2an betul (Kolom Description_E)

2012/12/27 JIMMY TRISNA <vincent_aguilera@yahoo.com>

> **
>
>
> Di Kolom B4:B11 di Blok terlebih dahulu kemudian di Text To Column , Pilih
> Delimited , kemudian Finished.
>
> Semoga bermanfaat
>
>
> ------------------------------
> *Dari:* tono <kusumartono@yahoo.com.sg>
> *Kepada:* "XL-mania@yahoogroups.com" <XL-mania@yahoogroups.com>
> *Dikirim:* Rabu, 26 Desember 2012 14:23
> *Judul:* ]] XL-mania [[ Error pada vlookup
>
>
> Dear suhu XL-mania,
>
> Saya menggunakan rumus vlookup untuk mengisi kolom pada deskripsi kode
> biaya, yang mana deskripsi pada kode biaya tersebut ada pada "sheet2".
> Format pada sheet1 dan sheet2 sudah saya samakan dengan menggunakan format
> "general" pada setiap kolomnya.
> Tetapi hasil dari vlookup masih #N/A (file terlampir).
>
> Mohon pencerahannya dari suhu/master XL-mania. :)
>
>
>
> salam,
> tono
>
>
>
>
>
>

Mon Dec 31, 2012 8:41 am (PST) . Posted by:

"Opik Pds" opik_pds

Dear pak andang,
Buat tabel bantuan fungsinya sebagai tempat simpan sementara sebelum disimpan ke tabel surat masuk
trimakasih, wassalam

 
Regard,

Opik PDS

________________________________
From: Andang Wisu <andangwisu@ymail.com>
To: "XL-mania@yahoogroups.com" <XL-mania@yahoogroups.com>
Sent: Wednesday, December 26, 2012 2:18 PM
Subject: ]] XL-mania [[ Membuat Aplikasi Surat Masuk dg Excel


 
rekan-rekan xl-mania, saya minta tolong bagaimana cara agar bisa membuat aplikasi Surat Masuk dg Excel. Konsepnya adalah dengan cara semua surat masuk akan di entri di sheet 1 dan hasil entri tersebut akan disimpan dan muncul di sheet berikutnya secara otomastis. Saya berikan layout surat masuknya...terima kasih atas bantuannya.

GROUP FOOTER MESSAGE
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Merry Christmas. May God bless you and your family...             |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di :                                            |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 05.13 0 komentar

[smf_addin] Digest Number 2453

10 New Messages

Digest #2453
1a
Re: Getting data from Fundlab by "jcarlosd" jcarlosd
1b
Re: Getting data from Fundlab by "Randy Harmelink" rharmelink
2b
3a
SMF Add-in Problem by "yfbili" yfbili
3b
Re: SMF Add-in Problem by "Randy Harmelink" rharmelink
4a
smfTagContent by "Marty" mtopper
4b
Re: smfTagContent by "Randy Harmelink" rharmelink
5a
Average Earnings Returns by "Adam Singh" adamsingh1
5b
Re: Average Earnings Returns by "Randy Harmelink" rharmelink

Messages

Mon Dec 31, 2012 5:36 am (PST) . Posted by:

"jcarlosd" jcarlosd

There is no other code between those two parts.
If I show the IE window ("objIE.Visible = True") when I do the "click", IE accepts the submit and returns to the initial screen (https://fundlab.credit-suisse.com/index.cfm?).
Then I try to get the data (as any other URL without disclaimer) with RCHGetHTMLTable, but it gets stopped at the disclaimer page again.

It seems to me that the cookie is never set. I already had problems with other URL, if you remember, and I could not resolve the issue. You told me that once I enter with IE in the disclaimer page, cookie should be set. But it is not working for me. How can I set it?

BTW, happy new year and keep this extraordinary tool and forum alive

J.Carlos

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> What happens after the Click and before the RCHGetHTMLTable()?
>
> On Sun, Dec 30, 2012 at 10:00 AM, jcarlosd <jcdelrio@...> wrote:
>
> > It's strange. Before going to that screen I run this code, to overpass the
> > country-code screen (I removed declarations and load waiting to simplify):
> >
> > URLset = ""
> > https://fundlab.credit-suisse.com/index.cfm?disclaimer=no&change=true"
> > Set objIE = New InternetExplorer
> > objIE.Navigate URLset
> > Set oForm = objIE.Document.forms(0)
> > On Error Resume Next 'sometimes IE cache does not go to this page
> > oForm.elements("DOMICILE").Value = "LUX"
> > oForm.elements("Disclaimer").Value = "YES"
> > oForm("acceptButton").Click
> > On Error GoTo 0
> >
> > 'And then I use SMF macro
> > myURL = "https://fundlab.credit-suisse.com/index.cfm?nav=list"
> > myData = RCHGetHTMLTable(myURL, "Show performance figures", 1, "", 1)
> >
> > I use to work just with VBA, not Excel, so I do not how to program the
> > Excel Web query and I work with the Internet Explorer object.
> >
> > It seems that the page I get with RCHGetHTMLTable is different from the
> > one I can get at that moment with "objIE.Navigate myURL".
> >
> > If this is true, I do not know how to override it
> >
>

Mon Dec 31, 2012 1:03 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Try using the EXCEL Web Query dialog (atl+d+d+w) to do the disclaimer. When
you get to the page with the HTML table, then CANCEL out and try the add-in
function...

That works for me. I'm not sure why your VBA code isn't doing the trick. It
looks like it should.

Hmmm. For me, the "click" button doesn't show up until AFTER the country
choice is selected. Is your VBA code trying to click on the button before
it has appeared?

On Mon, Dec 31, 2012 at 6:36 AM, jcarlosd <jcdelrio@procesando.com> wrote:

> There is no other code between those two parts.
> If I show the IE window ("objIE.Visible = True") when I do the "click", IE
> accepts the submit and returns to the initial screen (
> https://fundlab.credit-suisse.com/index.cfm?).
> Then I try to get the data (as any other URL without disclaimer) with
> RCHGetHTMLTable, but it gets stopped at the disclaimer page again.
>
> It seems to me that the cookie is never set. I already had problems with
> other URL, if you remember, and I could not resolve the issue. You told me
> that once I enter with IE in the disclaimer page, cookie should be set. But
> it is not working for me. How can I set it?
>
>

Mon Dec 31, 2012 7:44 am (PST) . Posted by:

"rho49m" rho49m


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

Mon Dec 31, 2012 12:54 pm (PST) . Posted by:

"Jim Ranum" amt2100

This describes me also!!

Thanks,

Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of rho49m
Sent: Sunday, December 30, 2012 6:14 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Timed refresh during market hours

Really have no idea what I am doing, basically I would like to download
stock data from Yahoo every 10 minutes during market hours, would like to
set start and end times with a refresh interval. I assume it has already
been done but did not find the post. I am none too smart so need an explicit
guide. Thanks

Mon Dec 31, 2012 12:55 pm (PST) . Posted by:

"yfbili" yfbili

I downloaded and unzipped the add-in file to the appropriate folder, then opened RCH_Stock_Market_Functions in Excel. I got some symbols (MMM etc) but no prices. I tried Ctrl-Alt-F9 to update, but that did nothing. What do I need to do to get the quotes to update periodically? Thanks.

Yaz

Mon Dec 31, 2012 1:05 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You may have location errors to resolve before you can use the workbook.
See the LINKS area of the group for more info on that.

You shouldn't be OPENING the XLA file. You need to activate it using the
add-in manager.

On Mon, Dec 31, 2012 at 9:44 AM, yfbili <yfbili@gmail.com> wrote:

> I downloaded and unzipped the add-in file to the appropriate folder, then
> opened RCH_Stock_Market_Functions in Excel. I got some symbols (MMM etc)
> but no prices. I tried Ctrl-Alt-F9 to update, but that did nothing. What
> do I need to do to get the quotes to update periodically? Thanks.
>

Mon Dec 31, 2012 12:55 pm (PST) . Posted by:

"Marty" mtopper

Hi Randy

I have been using the following to capture the DJI average when the market is open. It seems to be stuck - doesnt change even when i run smfForceRecalc.

=0+smfGetTagContent("http://finance.yahoo.com/q?s=^DJI","span",-1,"yfs_l10_")

Any suggestions?

thanks

Marty

Mon Dec 31, 2012 1:10 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You probably don't have your Internet settings set to always get a new copy
of a web page. Check out the related item in the LINKS area about
smfForceRecalculation.

You can get the time of the last update with:

=smfGetTagContent("http://finance.yahoo.com/q?s=^DJI","span",1,"yfs_t10_")

...or the current time on the web page with:

=smfGetTagContent("http://finance.yahoo.com/q?s=
^DJI","span",-1,"yfs_market_time")

On Mon, Dec 31, 2012 at 8:46 AM, Marty <mtopper@yahoo.com> wrote:

>
> I have been using the following to capture the DJI average when the market
> is open. It seems to be stuck - doesnt change even when i run
> smfForceRecalc.
>
> =0+smfGetTagContent("http://finance.yahoo.com/q?s=
> ^DJI","span",-1,"yfs_l10_")
>

Mon Dec 31, 2012 5:08 pm (PST) . Posted by:

"Adam Singh" adamsingh1

I just started playing with the SMF Add-in. It's really slick, and I appreciate everyone's contributions.

I am attempting to calculate the one day return of a stock after an earnings announcement. I have used the RCHGetElementNumber to retrieve the earnings dates from earnings.com. From here I would like to pull the stock price previous to the announcement (closing price), and then the closing price for the day after the annoucement, and thus calculate the one-day return and average them. I intend to compare these returns to the price jump being implied by options prices for future dates (I already have this).

Any suggestions would be greatly appreciated.

Mon Dec 31, 2012 8:07 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You could use the smfPricesByDates() function and get all of the closing
prices with one Internet access.

Another option would be to use RCHGetYahooHistory() to get the entire array
of history, and then do VLOOKUP() functions to get the appropriate prices.

I would think the latter would be better, since you have a mixture of
whether the announcements occur before, during, or after the market day.
Depending on when it occurs, you may want to look at something other than
just closing prices.

One problem with your model is that sometimes a company will release
guidance prior to the actual announcement, and that may be when the market
reaction occurs.

On Mon, Dec 31, 2012 at 5:31 PM, Adam Singh <singh.adam@gmail.com> wrote:

> I just started playing with the SMF Add-in. It's really slick, and I
> appreciate everyone's contributions.
>
> I am attempting to calculate the one day return of a stock after an
> earnings announcement. I have used the RCHGetElementNumber to retrieve the
> earnings dates from earnings.com. From here I would like to pull the
> stock price previous to the announcement (closing price), and then the
> closing price for the day after the annoucement, and thus calculate the
> one-day return and average them. I intend to compare these returns to the
> price jump being implied by options prices for future dates (I already have
> this).
>
> Any suggestions would be greatly appreciated.
>
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 03.46 0 komentar
Langganan: Postingan (Atom)