Threaded Mode | Linear Mode

Viper_99 · 06-03-2012, 06:58 PM

Hey there - Until I joined this site I never keep track of my stack. So after watching a few threads I created a spread sheet that tracks: the type of coin, its silver content, total oz, shipping costs, taxes and price paid. This tells me how many oz I have and what my cost per oz is. However, is there a formula and website that keeps a current silver price and makes a calculation of the value of the stack without my input. An auto updater doodad - I am showing my lack of computer skill there. Please help if you have some expertise - I would appreciate it.

Ivan · 06-03-2012, 09:16 PM

Why to track? Specially leaving trail.

travis · 06-04-2012, 07:15 AM

I don't have my desktop computer available and I'm sure that there is someone here better at vba than me but have a look at these pages to see if it points you in the right direction. If you search around enough you will find someone who has already worked out the problem.

http://msgroups.net/microsoft.public.exc...aily/35152
http://www.howtogeek.com/howto/microsoft...xcel-2007/

good luck

***kshymkiw*** · (This post was last modified: 06-04-2012 11:08 AM by kshymkiw.)

(06-03-2012 06:58 PM)Viper_99 Wrote: Hey there - Until I joined this site I never keep track of my stack. So after watching a few threads I created a spread sheet that tracks: the type of coin, its silver content, total oz, shipping costs, taxes and price paid. This tells me how many oz I have and what my cost per oz is. However, is there a formula and website that keeps a current silver price and makes a calculation of the value of the stack without my input. An auto updater doodad - I am showing my lack of computer skill there. Please help if you have some expertise - I would appreciate it.

Someone had made an Excel Spreadhseet and posted it here. Let me fine it for you. It wasn't Auto, but it was very little input needed from the user.

Here is the thread: http://www.brotherjohnf.com/forum/Thread...?pid=12203

Viper_99 · (This post was last modified: 06-04-2012 11:40 PM by Viper_99.)

(06-04-2012 11:06 AM)kshymkiw Wrote:
(06-03-2012 06:58 PM)Viper_99 Wrote: Hey there - Until I joined this site I never keep track of my stack. So after watching a few threads I created a spread sheet that tracks: the type of coin, its silver content, total oz, shipping costs, taxes and price paid. This tells me how many oz I have and what my cost per oz is. However, is there a formula and website that keeps a current silver price and makes a calculation of the value of the stack without my input. An auto updater doodad - I am showing my lack of computer skill there. Please help if you have some expertise - I would appreciate it.

Someone had made an Excel Spreadhseet and posted it here. Let me fine it for you. It wasn't Auto, but it was very little input needed from the user.

Here is the thread: http://www.brotherjohnf.com/forum/Thread...?pid=12203

Thanks kshymkiw for find that link. I did take a look at that spreadsheet and mine is similar. You are a programmer have you ever heard of people having spreadsheets attached to outside data source. Or is this some dream I have, in away it would be like an app for an iPhone type technology.

***kshymkiw*** · 06-05-2012, 11:18 AM

(06-04-2012 11:39 PM)Viper_99 Wrote:
(06-04-2012 11:06 AM)kshymkiw Wrote:
(06-03-2012 06:58 PM)Viper_99 Wrote: Hey there - Until I joined this site I never keep track of my stack. So after watching a few threads I created a spread sheet that tracks: the type of coin, its silver content, total oz, shipping costs, taxes and price paid. This tells me how many oz I have and what my cost per oz is. However, is there a formula and website that keeps a current silver price and makes a calculation of the value of the stack without my input. An auto updater doodad - I am showing my lack of computer skill there. Please help if you have some expertise - I would appreciate it.

Someone had made an Excel Spreadhseet and posted it here. Let me fine it for you. It wasn't Auto, but it was very little input needed from the user.

Here is the thread: http://www.brotherjohnf.com/forum/Thread...?pid=12203

Thanks kshymkiw for find that link. I did take a look at that spreadsheet and mine is similar. You are a programmer have you ever heard of people having spreadsheets attached to outside data source. Or is this some dream I have, in away it would be like an app for an iPhone type technology.

I am not a programmer by choice. I do some simple scripting stuff.

I believe you can dump an external source into a Spreadhseet, as long as it is in CSV format. So you need a script to reach out to Kitco for example, pull the price of Silver, and then put it into a CSV format. Then you spreadhseet could pull that CSV File into it's tables.

abreik · 06-05-2012, 02:54 PM

I can't find it anymore, but there was a shared Google Doc spreadsheet that had updated NAV spreads for various ETFs. This included live spot prices. I believe they were updated with an RSS feed. A quick search found this function: https://support.google.com/docs/bin/answ...er=155181. Kind of a round about solution, but if you had a Google spreadsheet with just the spot prices (updated via RSS), you could then import them into Excel: http://chandoo.org/wp/2008/07/30/rss-feeds-excel/.