Re: anyone know how to embed a website data into excel?

by xettie Fri 23 Sep 2011, 12:42

max i try to send you a file... wait.

by Guest Fri 23 Sep 2011, 12:43

maxims wrote:i solve everything...now 1 excel i can do few task

1. first i need to add the hsi index website to page reboot so that website can refresh and my excel can pick up the refresh data

2. i add a currency website... it's usd to myr only, therefore i need to convert myr to hkd using this usd to myr data

3. after all this...my excel h3 premium, networth etc..will automatically refresh...

4. but i still need to key in manually h3 market price..simple lo..h3 market price not changing every minute ma

bloomberg i also need to get page reboot

by Guest Fri 23 Sep 2011, 12:45

i test already..currency is working....hsi later 1.30 test..then mission complete

by Guest Fri 23 Sep 2011, 12:53

wow..my excel currency rate changing automatically [You must be registered and logged in to see this image.]

by xettie Fri 23 Sep 2011, 13:04

maxims wrote:wow..my excel currency rate changing automatically [You must be registered and logged in to see this image.]

[You must be registered and logged in to see this link.]

by xettie Fri 23 Sep 2011, 13:04

for auto refresh
0=no
1=yes

refresh interval is set to 5 sec.

by xettie Fri 23 Sep 2011, 13:05

but yahoo's quote delay damn slow.

by Guest Fri 23 Sep 2011, 13:07

xettie wrote:
maxims wrote:wow..my excel currency rate changing automatically [You must be registered and logged in to see this image.]

[url=http://www.xettie.com/bursacomm/Yahoo-options.xls

[You must be registered and logged in to see this link.]

wa good...

i am using excel 2010...the best is 1 minute update how ah

by xettie Fri 23 Sep 2011, 13:17

i think you can change that in macro programming.

by Guest Fri 23 Sep 2011, 13:20

xettie wrote:i think you can change that in macro programming.

i think enough liao...even 1 minute also bother already..that excel file keep on refreshing

if i want refresh fast can manually press refresh lo [You must be registered and logged in to see this image.]

by Guest Fri 23 Sep 2011, 13:20

xettie wrote:i think you can change that in macro programming.

ur excel file is good i think..but the website u use is not real time..so no point

by xettie Fri 23 Sep 2011, 13:21

hehe it's the concept that counts.... which site you use to get more updated quote?

by Guest Fri 23 Sep 2011, 13:22

xettie wrote:hehe it's the concept that counts.... which site you use to get more updated quote?

i pm u..don want guest to see

by xettie Fri 23 Sep 2011, 13:24

maxims wrote:
xettie wrote:hehe it's the concept that counts.... which site you use to get more updated quote?

i pm u..don want guest to see

[You must be registered and logged in to see this image.]

by Guest Fri 23 Sep 2011, 13:31

my file now very chunnnnnnnnnn

automatically update to 17570 [You must be registered and logged in to see this image.]

by xettie Fri 23 Sep 2011, 13:36

i see if i can "steal" the index and dump it onto excel or not. i suck in excel macros, more on web development.

by Guest Fri 23 Sep 2011, 13:47

xettie wrote:i see if i can "steal" the index and dump it onto excel or not. i suck in excel macros, more on web development.

x u website is fast but cannot embed into excel

by xettie Fri 23 Sep 2011, 13:49

muahahaha... i stole hs's xml data!

[You must be registered and logged in to see this link.]

by xettie Fri 23 Sep 2011, 13:51

hmmm 1 min update once. not good enough :(

by Guest Fri 23 Sep 2011, 13:52

xettie wrote:muahahaha... i stole hs's xml data!

[url=http://www.hsi.com.hk/HSI-Net/HSI-Net?cmd=simpleindex

[You must be registered and logged in to see this link.]

don know what is that....next time we can cooperate in doing some project [You must be registered and logged in to see this image.]

by xettie Fri 23 Sep 2011, 13:56

[quote="maxims"]

xettie wrote:muahahaha... i stole hs's xml data!

[You must be registered and logged in to see this link.]

don know what is that....next time we can cooperate in doing some project [You must be registered and logged in to see this image.]

that is raw xml data. basically without the webpage layout. i can plug those data into my own website. :)

sure sure. biz opportunity is always good. :) you in IT?

by Guest Fri 23 Sep 2011, 14:00

[quote="xettie"]

maxims wrote:
xettie wrote:muahahaha... i stole hs's xml data!

[You must be registered and logged in to see this link.]

don know what is that....next time we can cooperate in doing some project [You must be registered and logged in to see this image.]

that is raw xml data. basically without the webpage layout. i can plug those data into my own website. :)

sure sure. biz opportunity is always good. :) you in IT?

no le..i am not..i learn bit here bit there

by **sun** Fri 23 Sep 2011, 14:04

xettie wrote:
maxims wrote:wow..my excel currency rate changing automatically [You must be registered and logged in to see this image.]

[url=http://www.xettie.com/bursacomm/Yahoo-options.xls

[You must be registered and logged in to see this link.]

thanks for sharing, +1 rep [You must be registered and logged in to see this image.]

by xettie Fri 23 Sep 2011, 14:08

maxims wrote:
xettie wrote:

that is raw xml data. basically without the webpage layout. i can plug those data into my own website. :)

sure sure. biz opportunity is always good. :) you in IT?

no le..i am not..i learn bit here bit there

self taught is always good. [You must be registered and logged in to see this image.]

[quote="."]

xettie wrote:
maxims wrote:wow..my excel currency rate changing automatically [You must be registered and logged in to see this image.]

[You must be registered and logged in to see this link.]

thanks for sharing, +1 rep [You must be registered and logged in to see this image.]

thank you! [You must be registered and logged in to see this image.]

by Sponsored content