Jumat, 28 Februari 2020

Re: [smf_addin] Formula for S&P 500

 

That's a very vague question.

What about the S&P 500? Current price? Historical quotes? P/E ratio? Constituents? Or something else?

Index or ETF?

What context? One data item, or other data and other tickers?

A couple examples of last price of the index:

=smfStrExtr(RCHGetWebData("https://finance.yahoo.com/quote/^GSPC","""regularMarketPrice"":",100),"""raw"":",",",1)
=smfStrExtr(RCHGetWebData("https://www.barchart.com/stocks/quotes/$SPX/overview","""lastPrice"":",100),":""","""",1)

On Fri, Feb 28, 2020 at 1:44 PM Leo Bueno Leo@... wrote:

I will appreciate seeing the formula for the S&P 500.

 

If possible would like to see formulas for 2 or 3 data sources (Yahoo, Google, etc.)

 


__._,_.___
Posted by: Randy Harmelink <rharmelink@gmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

.

__,_._,___
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 14.41 0 komentar

[smf_addin] Formula for S&P 500

 

I will appreciate seeing the formula for the S&P 500.

 

If possible would like to see formulas for 2 or 3 data sources (Yahoo, Google, etc.)

 

Thanks.

 

Leo

 

=========
Leo Bueno
=========

__._,_.___
Posted by: Leo Bueno <leo@buenolaw.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

.

__,_._,___
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 12.43 0 komentar

Kamis, 27 Februari 2020

]] XL-mania [[ 18 Confusing Pictures

 

__._,_.___
Posted by: alka soni <alk.asoni@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)
:: XL-mania ::::::::::::::::::::
Momods sekarang jualan tas di www.flirtypoodle.com ha ha ha....
:: ------------- ::::::::::::::::::::
DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, pembicaraan pribadi, one line message,  melecehkan,  tidak sopan.
:: ------------- ::::::::::::::::::::
Buat subjek yang kreatif, jangan : &quot;tanya&quot;, &quot;help&quot;, &quot;mohon bantu&quot;
Usahakan besar attachment &lt; 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 06.31 0 komentar

]] XL-mania [[ 18 Confusing Pictures

 

__._,_.___
Posted by: "shaliniratnu@yahoo.com" <shaliniratnu@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)
:: XL-mania ::::::::::::::::::::
Momods sekarang jualan tas di www.flirtypoodle.com ha ha ha....
:: ------------- ::::::::::::::::::::
DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, pembicaraan pribadi, one line message,  melecehkan,  tidak sopan.
:: ------------- ::::::::::::::::::::
Buat subjek yang kreatif, jangan : &quot;tanya&quot;, &quot;help&quot;, &quot;mohon bantu&quot;
Usahakan besar attachment &lt; 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 02.21 0 komentar

Re: [belajar-excel] Macro Capslock On

 


pakai vba, dan pakai winapi ya...
1. disebuah module general, copas script ini :
Private Type ByteKeyboard
    arrKBD(0 To 255) As Byte
End Type

#If VBA7 Then
    Private Declare PtrSafe Function GetKeyState Lib "user32" (ByVal nVirtKey As Long) As Long
    Private Declare PtrSafe Function GetKeyboardState Lib "user32" (kbArray As ByteKeyboard) As Long
    Private Declare PtrSafe Function SetKeyboardState Lib "user32" (kbArray As ByteKeyboard) As Long
#Else
    Private Declare Function GetKeyState Lib "user32" (ByVal nVirtKey As Long) As Long
    Private Declare Function GetKeyboardState Lib "user32" (kbArray As ByteKeyboard) As Long
    Private Declare Function SetKeyboardState Lib "user32" (kbArray As ByteKeyboard) As Long
#End If

Private byteKBD As ByteKeyboard

Public Sub MengOnken(Optional bState As Boolean = False)
    GetKeyboardState byteKBD
    byteKBD.arrKBD(20) = CByte(Abs(bState))
    SetKeyboardState byteKBD
End Sub

2. di module Thisworkbook, buat event workbook open, lalu isi dengan bunyi script berikut :
         MengOnken  true   'untuk meng-on-ken capslock secara paksa
 
3. kalau pengen sebelum workbook di tutup si capslock dipaksa off :
    > masih di module thisworkbook, buat event beforeclose, isi dengan script :
         MengOnken  false   'untuk meng-off-ken capslock secara paksa

On Thu, Feb 27, 2020 at 12:09 PM Andrie - sioean2@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:
 

Suhu Excel,

Mohon bantuannya untuk macro excel auto on capslock
Thanks


__._,_.___
Posted by: "Mr. Kid" <mr.nmkid@gmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)
============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

.

__,_._,___
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 01.30 0 komentar

Rabu, 26 Februari 2020

[belajar-excel] Macro Capslock On

 

Suhu Excel,

Mohon bantuannya untuk macro excel auto on capslock
Thanks


__._,_.___
Posted by: Andrie - <sioean2@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)
============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

.

__,_._,___
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 21.07 0 komentar

Re: [belajar-excel] Menampilkan ID data yeng belum diinput (dengan data validation)

 

Dear Ari;

tetapi jumlah isian data validation masih menampilkan semua 14 baris record .. 

14 baris record karena ini: +ROW($1:$14)
Coba ganti rumus +ROW($1:$14) sesuai keinginan.


Wassalam
   Bagus


Pada tanggal Kam, 27 Feb 2020 pukul 09.27 Eira I Arie cheivory_bridge@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
 


Yth.. Bagas

Terima kasih atas solusinya ..

satu lagi pertanyaan :
rumus tersebut saya tambahi iferror untuk menghilangkan error jika data kosong (juga saya set excel table) ..
tetapi jumlah isian data validation masih menampilkan semua 14 baris record ..
saya sudah mencoba membuat name range dinamis pakai offset (utk sumber bagi data validation) tetapi item yang kosong masih ikut di data validationnya ..

bagaimana kira2 solusinya ?

terima kasih

On Thursday, February 27, 2020, 07:46:57 AM GMT+7, Bagus bagus4bls@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:


 

Dear Ari;

Apakah spt file terlampir.


Wassalam
   Bagus


Pada tanggal Sel, 25 Feb 2020 pukul 09.50 Eira I Arie cheivory_bridge@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
 

Selamat Pagi Rekan2

Mohon bantuannya
bagaiamana cara menampilkan ID data yang belum diinput (dengan data validation) ..
file kasus terlampir.

terima kasih

ari

__._,_.___
Posted by: Bagus <bagus4bls@gmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (4)
============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

.

__,_._,___
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 20.46 0 komentar

Re: [belajar-excel] Menampilkan ID data yeng belum diinput (dengan data validation)

 


Yth. Bagas

Terima kasih atas solusinya ..

satu lagi pertanyaan :
rumus tersebut saya tambahi iferror untuk menghilangkan error jika data kosong (juga saya set excel table) ..
tetapi jumlah isian data validation masih menampilkan semua 14 baris record ..
saya sudah mencoba membuat name range dinamis pakai offset (utk sumber bagi data validation) tetapi item yang kosong masih ikut di data validationnya ..

bagaimana kira2 solusinya ?

terima kasih

On Thursday, February 27, 2020, 07:46:57 AM GMT+7, Bagus bagus4bls@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:


 

Dear Ari;

Apakah spt file terlampir.


Wassalam
   Bagus


Pada tanggal Sel, 25 Feb 2020 pukul 09.50 Eira I Arie cheivory_bridge@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
 

Selamat Pagi Rekan2

Mohon bantuannya
bagaiamana cara menampilkan ID data yang belum diinput (dengan data validation) ..
file kasus terlampir.

terima kasih

ari

__._,_.___
Posted by: Eira I Arie <cheivory_bridge@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (3)
============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

.

__,_._,___
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 18.26 0 komentar

Re: [belajar-excel] Menampilkan ID data yeng belum diinput (dengan data validation)

 

Dear Ari;

Apakah spt file terlampir.


Wassalam
   Bagus


Pada tanggal Sel, 25 Feb 2020 pukul 09.50 Eira I Arie cheivory_bridge@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
 

Selamat Pagi Rekan2

Mohon bantuannya
bagaiamana cara menampilkan ID data yang belum diinput (dengan data validation) ..
file kasus terlampir.

terima kasih

ari

__._,_.___
Posted by: Bagus <bagus4bls@gmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)
============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

.

__,_._,___
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 16.46 0 komentar

Selasa, 25 Februari 2020

Re: ]] XL-mania [[ Unsubscribes

 

Unsubscribes

On Feb 26, 2020, at 10:40, "joko santoso j_santoso1982@yahoo.com [XL-mania]" <xl-mania@yahoogroups.com> wrote:
 

Unsubscribes

__._,_.___
Posted by: Dhim <levinstain@yahoo.co.id>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (10)
:: XL-mania ::::::::::::::::::::
Momods sekarang jualan tas di www.flirtypoodle.com ha ha ha....
:: ------------- ::::::::::::::::::::
DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, pembicaraan pribadi, one line message,  melecehkan,  tidak sopan.
:: ------------- ::::::::::::::::::::
Buat subjek yang kreatif, jangan : &quot;tanya&quot;, &quot;help&quot;, &quot;mohon bantu&quot;
Usahakan besar attachment &lt; 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 23.18 0 komentar

]] XL-mania [[ Unsubscribes

 

Unsubscribes

__._,_.___
Posted by: joko santoso <j_santoso1982@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (9)
:: XL-mania ::::::::::::::::::::
Momods sekarang jualan tas di www.flirtypoodle.com ha ha ha....
:: ------------- ::::::::::::::::::::
DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, pembicaraan pribadi, one line message,  melecehkan,  tidak sopan.
:: ------------- ::::::::::::::::::::
Buat subjek yang kreatif, jangan : &quot;tanya&quot;, &quot;help&quot;, &quot;mohon bantu&quot;
Usahakan besar attachment &lt; 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 19.40 0 komentar
Langganan: Postingan (Atom)