Updating stock ticker

Macroaxis provides high-impact, comprehensive, and customizable stock tickers that can be easily integrated to websites, investment portals, financial blogs or financial online media outlets.The near-real-time stock tickers cover markets from over 30 countries and can include socks, funds, etfs, indexes, news, or custom-built financial information.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 There are many free tools available to help people manage their stock portfolio. Still, when you need to do more sophisticated analysis, there is nothing that beats the power of spreadsheet.

For each stock it list many detail financial data as well as stock chart for various periods.

Fortunately it is easy to pull the data from the web tool to a spreadsheet.

You can simple copy and paste the data into a spreadsheet to get a properly formatted table.

It then fetches the (15 minute delayed) stock quote from a Yahoo web services. Finally it updates the cells in the spreadsheet with new data from Yahoo.

It is quite a challenge to find an ASPN category to submit this recipe.

I think the "Image and scientific data processing" category is a fitting one.

For there you can add your custom formula or charts.

The problem is unlike the web view, data downloaded on a spreadsheet is not updated with current market information.

On the other hand if you download the again you will lose all custom formula you have added.

To get the best of both world, I have created a script to so that you can update your spreadsheet with the latest stock quote from the web. It first looks for the stock symbols in your portfolio in your spreadsheet.

Comments are closed.