Use excel to pull stock prices from web

[K|muRa^84]

Why nobody recommended investment moat's excellent Google sheets? It's free, it's comprehensive, and everything is set in stone, just need to key your parameters in.

Google investment moat portfolio tracker.

would prefer it to let u key in the then FX rate to determine cost basis, instead of using spot rate

 

[Average]

I tried and succeeded in pulling Price of M1 from google finance, using MS Excel 2013! However, my method is very novice and does not suit users who want to pull price for manymany counters. Below instructions.

Creating a data query from google finance.
Google search for M1 google finance, copy the URL.

In MS Excel go to "DATA" tab, select "From Web".

In the pop-up, Paste the URL in the address field and Go.

Toggle 1 of the small arrows pointing east, on the top-left of page.

Click "Import" to close the pop-up.

Insert the "DATA" on any random cell. Excel will now pull all data from the web and fill on your sheet.

Find the cell(s) that contain the B2F's price and copy them.

Create a new sheet and 'PASTE as link' wherever you want the price to show.

There you have it! Repeat all steps again to pull another counter.

[Disclaimer]
I have yet to test if there will be auto refresh but I am very sure you could manual refresh with a click of "Refresh all".

I have also yet to test with live market movements (Weekend no live quotes to test).

 

[spiritGate]

I have diy one for myself, a much simpler version as i am integrating it with my personal saving spreadsheet. Not sure if i can share the google spreadsheet link here

Sent from sent from gagt using GAGT

 

[Perisher]

I have diy one for myself, a much simpler version as i am integrating it with my personal saving spreadsheet. Not sure if i can share the google spreadsheet link here

No issues.

 

[Denierx]

I have diy one for myself, a much simpler version as i am integrating it with my personal saving spreadsheet. Not sure if i can share the google spreadsheet link here

Sent from sent from gagt using GAGT

Hi do you mind sharing your template? Like to know how can I start on one

 

[zuoom]

Good reference to try.

 

[spiritGate]

Hi do you mind sharing your template? Like to know how can I start on one

Do note that my spreadsheet is very very simple (for investment portfolio) as this is one of a small portion of my overall saving spreadsheet.

Here is the link:
https://docs.google.com/spreadsheets/d/1fwOgYywND46jMjlX3i0xKAQ8y4pOh2Umq9QyB8LSfGE/edit?usp=sharing

If you go to investment tab, u can see the basic shares and how to retrieve the share price and dividend information.

I have create a video on how my spreadsheet works

 

[wahkao3]

forget about excel
it doesnt even calculate basic performance

use fund manager, it can plot equity curve

 

[leoch037]

i'm using sgx.i3investor.com
it's foc

anyone has similar portfolio sites like this to recommend?

 

[ValueInvestor]

forget about excel
it doesnt even calculate basic performance

use fund manager, it can plot equity curve

where to go this? free or what cost?

 

[ValueInvestor]

Hi do you mind sharing your template? Like to know how can I start on one

can consider starting from scratch

google spreed sheet is super easy to use

 

[wahkao3]

where to go this? free or what cost?

by right nid to pay
by left no need

 

[ValueInvestor]

by right nid to pay
by left no need

zzzzzzzz don't use illegally leh

those software makes need to making a living too right?

 

[peterchan75]

Not sure what's TS intention of pulling the stock prices from the web. If it's for charting software then some charting software like NinjaTrader has a plugin to download daily data(open, high, low, close, volume) from Yahoo Finance. I personally, download daily data from Yahoo Finance using perl script and import into my charting software. Google finance is bitch to download. It will block when downloading too many counters. If the data is for portfolio tracking then using Excel or Google spreadsheet is fine.

 

[wahkao3]

zzzzzzzz don't use illegally leh

those software makes need to making a living too right?

i never say i use illegally ah?
dont anyhow assume

 

[Kryewee]

I have a Google spreadsheet, but these days I'm getting an error. The error is that Google spreadsheet is not authorized to access data for SGX. Anyway around it? Thanks!

 

[apriliasiao]

I have a Google spreadsheet, but these days I'm getting an error. The error is that Google spreadsheet is not authorized to access data for SGX. Anyway around it? Thanks!

me too! dunno how to troubleshot this sia..

 

[Perisher]

I have a Google spreadsheet, but these days I'm getting an error. The error is that Google spreadsheet is not authorized to access data for SGX. Anyway around it? Thanks!

me too! dunno how to troubleshot this sia..

I think you guys are having the same issues as the people in this thread
http://deluxeforums.hardwarezone.co...oogle-spreadsheet-4275653-2.html#post97441668

Take a look perhaps.

 

[iam1e5]

I think you guys are having the same issues as the people in this thread
http://deluxeforums.hardwarezone.co...oogle-spreadsheet-4275653-2.html#post97441668

Take a look perhaps.

read these 2 websites

http://www.labnol.org/internet/import-html-in-google-docs/28125/

https://kx.cloudingenium.com/conten...hoo-finance-you-can-query-them-via-excel-too/

tldr:

use "=importData("http://finance.yahoo.com/d/quotes.csv?s=s63.SI&f=l1")"

to get data for SGX ticker S63, that is ST Eng

also posted in the other thread, but put it here for convenience. not related to both websites.