Adding stock market data from yahoo finance to master Excel file

[jungle125]

Hi

I have created a web query which import the day´s trading data (example Tesla, ticker TSLA) from finance.yahoo using the following link: https://finance.yahoo.com/quote/TSLA/history?p=TSLA

The table looks like this where I have just copied 5 of the 100 or so lines from the table. :

Web Data Query Test.xlsx
	A	B	C	D	E	F	G
1	Date	Open	High	Low	Close*	Adj Close**	Volume
2	27/09/2023	244.26	245.33	238.57	239.3	239.3	68089575
3	26/09/2023	242.98	249.55	241.66	244.12	244.12	101741600
4	25/09/2023	243.38	247.1	238.31	246.99	246.99	104636600
5	22/09/2023	257.4	257.79	244.48	244.88	244.88	127024300
6	21/09/2023	257.85	260.86	254.21	255.7	255.7	119531000
7	20/09/2023	267.04	273.93	262.46	262.59	262.59	122514600
Table 0

On a separate sheet, I have the "master" database which goes back as far as the stock data goes, in this case Tesla´s IPO in 2010. It looks like this:

06 TSLA.xlsx
	A	B	C	D	E	F	G
2	Date	Open	High	Low	Close	Adj Close	Volume
3	29/06/2010	1.266667	1.666667	1.169333	1.592667	1.592667	281494500
4	30/06/2010	1.719333	2.028	1.553333	1.588667	1.588667	257806500
5	01/07/2010	1.666667	1.728	1.351333	1.464	1.464	123282000
6	02/07/2010	1.533333	1.54	1.247333	1.28	1.28	77097000
7	06/07/2010	1.333333	1.333333	1.055333	1.074	1.074	103003500
Sheet1

What I´d like to know is:

1) Is there a way to add only the most recent day´s trading date from the website (today for example would be line 2) to the "Master" sheet?
2) Is there a way to automate this so that it updates every day without having to open the Excel every time? Problem is that the link provides the most recent 100 days of trading data, but I want to "capture" each day´s data which ends up as thousands of days of trading data, and I want to do this for about 250 different stocks.
3) I am also open to other sources of the stock data but yahoo seems convenient and it´s free.

Thanks in advance for any suggestions!

 

[ExcelToDAX]

You could do something like this in Power Query:

let    
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("XZpbjiS3DkT34m8DLfEhkmsx7v63cVmZSUkM+GfgQM9ER/GkFFn8779/5go1Ix/jn3//iT9afzSI//nfv6/kGlSSdSlEV0nepDU4f+iToktzunwSjy7RkNfGHH8TpJhUEnWJzVZJ3CVZMkqSLqkOKUm7tHhtGz2NZcTbRk8jfyS2DUjDf8onQRrhtG3MHoeN5SeOnodN1W1k9kCMZG4nsydi/PugS+uRmEw5XnompmMcLws0t+Olp2LL+HjpsTwf29Z6LubPR/d93pBLMG0v1HPxMePMSc/F59DthRi0oO2Fei5O5sdLz8V5nZEFdFz0mtmeiyufoQV4fNGZWqDHbZ6xBXzc4swtQy7uNbgT0MrhrMGdgFY8gX1SDyym1OBOQCuIam4noBU8ddvoaYWMuW0YSO7bRs8qH12ybfSokuOxbQBaOet24uh55GfK2wigFc+UlHYnYr//v7aVhtZPCzpetGvT4nhZXaOlx4t1jZWOF++asB8v0TUl2V4aWqnl03l7aWj9tLAzJ9S1h5DSIBe3sb0Q5BK6jpeeSw76GVnquaTLa2Z7LpPmGVrquUweZ2opQPMzttxzmWI1t/TXY5m6am7pr6cyn2fDJ/VQpnHNLf31TKZTzS39QSQxbNuARJKtbaMH8vx1JfU8Mqq1bfQ4iJS2jdnjIOY4cfQ8SEi3kdkDoeeBWBqDFr6tAD60XI6XngmZzeOlh0KudrxAKiFyvPRYOP87XnouPOfaXgCfnFfeXgCfPLPizEnPhZ/DoLSeC8ui7QXwYRU/XnouvPiMLODDRtfM9lzYxxlawIc9ztQCPhx+xhbwkbHO3HLPRabW4L5kyVaeY/BVqCtMNbYvV0eRWVP7YnUpUTP7UnWUvOOWg9WVx/arWFfy0lMOvCsuNasvUUfJ068cvEBtSfOBsEPoKehz4H8SgRQ1ph9NRyKrKf1gOlJOxrbRk9AMadvoUejzKX1Sz0IX0bbRw1Abvm0ESFHz+WF0JPcaz4+iIz1XnE/qaayf/ZJ6GmtKzeaH0JGIbNvoaSyeezKpp/HUipIMJN+zST2NpbaHk3oaa+meTu5pLJM9ntzTWF41i4CdFdWyCNj5XQ78UxiU6lgE7NisikXAjlE1LAJ2jKtgEbBjUv2KgJ08ZLkc9Hzyn49yAOzYqnZFyI5ZtStCdsyrXBGyk4Op5QLY8VHVipAdn9WsCNlxqmJFyI5z9SpCdpyrVhGy41KtipCd51FWUk/DV3UqQnbcqlIRsuNejYqQHY8qVITseMSeTGAnhp3R7GnEXHs2gZ0g3cMJ7ARXl2KgIKSaFAMFodWjGCgIrRbFQEGs6lAMFIRVhWKgILwaFAMFEVWguFMw89bv5SC6Mqs+MVAw85Y3dwgTpKpPDBTMvAlImegUZDxVnxgoyBpd7YmBgpkPTd42VpesuhMDBTP/obVtQBhezYmBgpmxR9noFMz0oWWjUzDfCD+ppzGpWhMDBXNylSYGCuaU6kwMFKQUezI7BenCz2j2NOayPZudgjlN93B2Cn5v1fZ0MqQRtMeznyDznZqfJH+gzKpK0tlJpYqSdHZmnqXffEpnJ5OtliSdnUlSJUk6O5O0OpJ0diatqkgC7JBVQxJgh6wKkiA7Lx+fBClEFSRBdnhUQRJkJy8OUS6AHaaqR4LsMFc7EmQn+5ZvGz0LlupGguywVjUSZIdXNSNBdt5Hwif1NNirFwmyw1G1SJCd/AkuG8BOXsti2+hpyLQ9mcCO0Dqj2dMQlj2bwI4I7+EEdkRpTyew8z4Ff5ICILKqDCkAIlZVSAGQvBt+46kAiETVIAVAnmvUp/Qc8kRc5aDHkL8PlQMHpWqQAiDKVYMUAXmf95/UU1CtIqQIiK5qQoqAqFUVUgREvaqQIiAaVYUUAdGoKqQIyBpVhRQByWcSbxs9jZywKBsAyHvEfVJPY0lVIUVAllYVUgQk7/5aNgCQtaoKKQKybO3JBECW6xlNSCNkzyYA8nuXsm30NH4HYNkAQN5T/ZMmSFWFFrBjXE1oATtZdr75XMCOafWgBezYqhq0gB2zqkEL2ElEpRwYKFWDFrBjUTVoATvv/eX7TXs+PqsHLWTHqYrQQnbypsllAtjJXyjKBbDjUlVoITuuVYUWsuOrqtBCdtyqCi1kx72q0EJ23ivb9+n2NGJUFVrITsyqQgvZyTJrZQPYCaoqtJCd57wvqaeRT+49mcBOPofPaPY0Ys09m8BO2NjDCey8t9RvoiENrypkAEhENSHrgORfVUXIOiB5laseZB2Q/GP1IOuA0ODqQdYBSaV6kHVAfl/Scjnwrmj1IOuA0Hsf/37T0SWrImQASF7yqgkZAELZFbVMdEDy4lpVyACQlKoKGQBCebeWbaNHkcfs2DZ6Fnn9sm2jh5F3Ed42ehpvBfk+3Z5GOl9lowOSUlUhA0AoH3RRNgjS8KpCBoDQjKpCBoBQfvx7MjsglHGc0exppLZnswOSUuzh7IDQ27q+ie5pkNgez3645DW6qpD/gbKqCTmwk+fbN58O7JBXD3Jgh6J6kAM7FNWDHNjhUT3IgR2e1YMc2HkL5qv0fJirBzmyw1JFyJEd1mpCjuywVhVyZOc5kErqQeTDZW0bPYm8OdK2AVFEVSFHdmRUFXJk563UnxQgVRVyZEeoqpAjO8JVhRzZEakq5MiOaFUhR3ZkVRVyZEds7skEdtLeGU1Iw33PJrDzvkX4pJ6GjrWnE9jRKXs8gR2lqkIB7OThN/dOT1ekilAAOypVhALYyW4waq+oZ6SrilAAO2pVhALYed+YvEoPKK+Mqxz0fNaYe7MJ2Fkj9mYTsLOm780mYGdRVaFAdhbr3mwCdrIJybbRk1haVSiQnbWqCgWy874i+iQHqapQIDvLqwoFsvPbo9p7Xj2N3zdXeyZ6GjarCgWy83vklw1gx7iqUCA7xrEnE9gx8TOaPY33rdgn9TRs6R5OYMdM9nQCO+Z0rTR1KebZaOppPI/OkhgkP/tMPQ2fdtaZehpOeraZehrOcpaZehrvi8BP6mm4zrPK1NPwdS/fDdCu7Ttgxe1avwNY3K/9O6DF41rAA1xiXBt4wEs6OSt4AEyGdXbwgJj3HWhpPZbgewuv5xJybeEBNKHXFh5Qkxf4s4UH2IRdW3jATfi1hQfgRFxbeEBOxLWF19HhMa4tvM4Ovy+AS/Ou0b2FF13jawuv45Mn47WF188eHjqulSaQ9hIefOPPY9lZaOIu2Tr7TNIl17POpF0KPttMPa33xfcn9bDmnGeXyUGKs8rUo8oj6Fq+61Hlw+RsMnW0eMq1ftfR4qnX/l1HK++Y1wJeR4ufV4Bb65lMv1bwJoTi1w7ehFTiWsLraOXvfW/h9VyyIp0tvI4WZys4W3gdrffVyNZ6LhnK2cLraKV2beF1tDjvHWcLr6PFeRCfkQW03m88Suu55Md+hhbQyufRtYXXc+FxbeEBWjziWmnq0txLePClf6JqZ6Gph8KsZ5+pZ5K146wz9Ujy/ni2mXoi7zc9n9QDYRtnl8lB8rPKBHH4vXwHccS1fQf4yLjW7wAfmdf+HeAjdC3gAT7C1wYe4CN8reABPu+XXKX1VJLys4QH+Mi6t/B6LmLXFh7gI35t4QE+EtcWHuAjcW3hAT46ri08wEfntYUH+ChdW3iAz/sVX2k9F5VrCw/wUb238Houuq4tPMBH17WFt0+m//0f", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Yahoo Date Code" = _t, Date = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Yahoo Date Code", Int64.Type}, {"Date", type date}}),
    Custom1 = Csv.Document(Web.Contents("https://query1.finance.yahoo.com",[RelativePath ="v7/finance/download/TSLA?period1=" & Number.ToText(Table.SelectRows(#"Changed Type", each ([Date] = Date.AddDays(Date.From(DateTime.LocalNow()),-2))){0}[Yahoo Date Code]) & "&period2=" & Number.ToText(Table.SelectRows(#"Changed Type", each ([Date] =Date.AddDays(Date.From(DateTime.LocalNow()),-1))){0}[Yahoo Date Code]) & "&interval=1d&events=history&includeAdjustedClose=true"]),[Delimiter=",", Columns=7, Encoding=65001, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Custom1, [PromoteAllScalars=true]),
    #"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"Date", type date}, {"Open", type number}, {"High", type number}, {"Low", type number}, {"Close", type number}, {"Adj Close", type number}, {"Volume", Int64.Type}})
in
    #"Changed Type1"

It Currently Grabs Yesterday's Date and 2 Days ago Date, but you can switch it to Today's Date and Yesterday's Date. (Where it says Date.AddDays(Date.From(DateTime.LocalNow()),-2)), change the -2 to a -1, and where it says Date.AddDays(Date.From(DateTime.LocalNow()),-1)) change that to 0.

If you put this in a Power BI dataset with a scheduled refresh after 4PM EST (since that is when the stock market closes), you can have Power Automate push this dataset into your Excel sheet using either Office Scripts or the out-of-the-box Excel connector that adds to a table. It doesn't look like your data is in a table format, so you would have to utilize Office Scripts. Yahoo uses their own in-house numbers to decipher from the dates, so the first step in this Power Query was figuring out the Yahoo logic. It looks like they add 8400 everyday, so I just created simple logic to use for a lookup table. Let me know if you have any questions or concerns!

 

[ExcelToDAX]

And if you want to use multiple stocks, you can create a table with the Ticket Symbols, and convert that into a function.

Here is what it would look like as a function:

(stockName as text) =>
let   
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("XZpbjiS3DkT34m8DLfEhkmsx7v63cVmZSUkM+GfgQM9ER/GkFFn8779/5go1Ix/jn3//iT9afzSI//nfv6/kGlSSdSlEV0nepDU4f+iToktzunwSjy7RkNfGHH8TpJhUEnWJzVZJ3CVZMkqSLqkOKUm7tHhtGz2NZcTbRk8jfyS2DUjDf8onQRrhtG3MHoeN5SeOnodN1W1k9kCMZG4nsydi/PugS+uRmEw5XnompmMcLws0t+Olp2LL+HjpsTwf29Z6LubPR/d93pBLMG0v1HPxMePMSc/F59DthRi0oO2Fei5O5sdLz8V5nZEFdFz0mtmeiyufoQV4fNGZWqDHbZ6xBXzc4swtQy7uNbgT0MrhrMGdgFY8gX1SDyym1OBOQCuIam4noBU8ddvoaYWMuW0YSO7bRs8qH12ybfSokuOxbQBaOet24uh55GfK2wigFc+UlHYnYr//v7aVhtZPCzpetGvT4nhZXaOlx4t1jZWOF++asB8v0TUl2V4aWqnl03l7aWj9tLAzJ9S1h5DSIBe3sb0Q5BK6jpeeSw76GVnquaTLa2Z7LpPmGVrquUweZ2opQPMzttxzmWI1t/TXY5m6am7pr6cyn2fDJ/VQpnHNLf31TKZTzS39QSQxbNuARJKtbaMH8vx1JfU8Mqq1bfQ4iJS2jdnjIOY4cfQ8SEi3kdkDoeeBWBqDFr6tAD60XI6XngmZzeOlh0KudrxAKiFyvPRYOP87XnouPOfaXgCfnFfeXgCfPLPizEnPhZ/DoLSeC8ui7QXwYRU/XnouvPiMLODDRtfM9lzYxxlawIc9ztQCPhx+xhbwkbHO3HLPRabW4L5kyVaeY/BVqCtMNbYvV0eRWVP7YnUpUTP7UnWUvOOWg9WVx/arWFfy0lMOvCsuNasvUUfJ068cvEBtSfOBsEPoKehz4H8SgRQ1ph9NRyKrKf1gOlJOxrbRk9AMadvoUejzKX1Sz0IX0bbRw1Abvm0ESFHz+WF0JPcaz4+iIz1XnE/qaayf/ZJ6GmtKzeaH0JGIbNvoaSyeezKpp/HUipIMJN+zST2NpbaHk3oaa+meTu5pLJM9ntzTWF41i4CdFdWyCNj5XQ78UxiU6lgE7NisikXAjlE1LAJ2jKtgEbBjUv2KgJ08ZLkc9Hzyn49yAOzYqnZFyI5ZtStCdsyrXBGyk4Op5QLY8VHVipAdn9WsCNlxqmJFyI5z9SpCdpyrVhGy41KtipCd51FWUk/DV3UqQnbcqlIRsuNejYqQHY8qVITseMSeTGAnhp3R7GnEXHs2gZ0g3cMJ7ARXl2KgIKSaFAMFodWjGCgIrRbFQEGs6lAMFIRVhWKgILwaFAMFEVWguFMw89bv5SC6Mqs+MVAw85Y3dwgTpKpPDBTMvAlImegUZDxVnxgoyBpd7YmBgpkPTd42VpesuhMDBTP/obVtQBhezYmBgpmxR9noFMz0oWWjUzDfCD+ppzGpWhMDBXNylSYGCuaU6kwMFKQUezI7BenCz2j2NOayPZudgjlN93B2Cn5v1fZ0MqQRtMeznyDznZqfJH+gzKpK0tlJpYqSdHZmnqXffEpnJ5OtliSdnUlSJUk6O5O0OpJ0diatqkgC7JBVQxJgh6wKkiA7Lx+fBClEFSRBdnhUQRJkJy8OUS6AHaaqR4LsMFc7EmQn+5ZvGz0LlupGguywVjUSZIdXNSNBdt5Hwif1NNirFwmyw1G1SJCd/AkuG8BOXsti2+hpyLQ9mcCO0Dqj2dMQlj2bwI4I7+EEdkRpTyew8z4Ff5ICILKqDCkAIlZVSAGQvBt+46kAiETVIAVAnmvUp/Qc8kRc5aDHkL8PlQMHpWqQAiDKVYMUAXmf95/UU1CtIqQIiK5qQoqAqFUVUgREvaqQIiAaVYUUAdGoKqQIyBpVhRQByWcSbxs9jZywKBsAyHvEfVJPY0lVIUVAllYVUgQk7/5aNgCQtaoKKQKybO3JBECW6xlNSCNkzyYA8nuXsm30NH4HYNkAQN5T/ZMmSFWFFrBjXE1oATtZdr75XMCOafWgBezYqhq0gB2zqkEL2ElEpRwYKFWDFrBjUTVoATvv/eX7TXs+PqsHLWTHqYrQQnbypsllAtjJXyjKBbDjUlVoITuuVYUWsuOrqtBCdtyqCi1kx72q0EJ23ivb9+n2NGJUFVrITsyqQgvZyTJrZQPYCaoqtJCd57wvqaeRT+49mcBOPofPaPY0Ys09m8BO2NjDCey8t9RvoiENrypkAEhENSHrgORfVUXIOiB5laseZB2Q/GP1IOuA0ODqQdYBSaV6kHVAfl/Scjnwrmj1IOuA0Hsf/37T0SWrImQASF7yqgkZAELZFbVMdEDy4lpVyACQlKoKGQBCebeWbaNHkcfs2DZ6Fnn9sm2jh5F3Ed42ehpvBfk+3Z5GOl9lowOSUlUhA0AoH3RRNgjS8KpCBoDQjKpCBoBQfvx7MjsglHGc0exppLZnswOSUuzh7IDQ27q+ie5pkNgez3645DW6qpD/gbKqCTmwk+fbN58O7JBXD3Jgh6J6kAM7FNWDHNjhUT3IgR2e1YMc2HkL5qv0fJirBzmyw1JFyJEd1mpCjuywVhVyZOc5kErqQeTDZW0bPYm8OdK2AVFEVSFHdmRUFXJk563UnxQgVRVyZEeoqpAjO8JVhRzZEakq5MiOaFUhR3ZkVRVyZEds7skEdtLeGU1Iw33PJrDzvkX4pJ6GjrWnE9jRKXs8gR2lqkIB7OThN/dOT1ekilAAOypVhALYyW4waq+oZ6SrilAAO2pVhALYed+YvEoPKK+Mqxz0fNaYe7MJ2Fkj9mYTsLOm780mYGdRVaFAdhbr3mwCdrIJybbRk1haVSiQnbWqCgWy874i+iQHqapQIDvLqwoFsvPbo9p7Xj2N3zdXeyZ6GjarCgWy83vklw1gx7iqUCA7xrEnE9gx8TOaPY33rdgn9TRs6R5OYMdM9nQCO+Z0rTR1KebZaOppPI/OkhgkP/tMPQ2fdtaZehpOeraZehrOcpaZehrvi8BP6mm4zrPK1NPwdS/fDdCu7Ttgxe1avwNY3K/9O6DF41rAA1xiXBt4wEs6OSt4AEyGdXbwgJj3HWhpPZbgewuv5xJybeEBNKHXFh5Qkxf4s4UH2IRdW3jATfi1hQfgRFxbeEBOxLWF19HhMa4tvM4Ovy+AS/Ou0b2FF13jawuv45Mn47WF188eHjqulSaQ9hIefOPPY9lZaOIu2Tr7TNIl17POpF0KPttMPa33xfcn9bDmnGeXyUGKs8rUo8oj6Fq+61Hlw+RsMnW0eMq1ftfR4qnX/l1HK++Y1wJeR4ufV4Bb65lMv1bwJoTi1w7ehFTiWsLraOXvfW/h9VyyIp0tvI4WZys4W3gdrffVyNZ6LhnK2cLraKV2beF1tDjvHWcLr6PFeRCfkQW03m88Suu55Md+hhbQyufRtYXXc+FxbeEBWjziWmnq0txLePClf6JqZ6Gph8KsZ5+pZ5K146wz9Ujy/ni2mXoi7zc9n9QDYRtnl8lB8rPKBHH4vXwHccS1fQf4yLjW7wAfmdf+HeAjdC3gAT7C1wYe4CN8reABPu+XXKX1VJLys4QH+Mi6t/B6LmLXFh7gI35t4QE+EtcWHuAjcW3hAT46ri08wEfntYUH+ChdW3iAz/sVX2k9F5VrCw/wUb238Houuq4tPMBH17WFt0+m//0f", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Yahoo Date Code" = _t, Date = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Yahoo Date Code", Int64.Type}, {"Date", type date}}),
    Custom1 = Csv.Document(Web.Contents("https://query1.finance.yahoo.com",[RelativePath ="v7/finance/download/" & stockName & "?period1=" & Number.ToText(Table.SelectRows(#"Changed Type", each ([Date] = Date.AddDays(Date.From(DateTime.LocalNow()),-2))){0}[Yahoo Date Code]) & "&period2=" & Number.ToText(Table.SelectRows(#"Changed Type", each ([Date] =Date.AddDays(Date.From(DateTime.LocalNow()),-1))){0}[Yahoo Date Code]) & "&interval=1d&events=history&includeAdjustedClose=true"]),[Delimiter=",", Columns=7, Encoding=65001, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Custom1, [PromoteAllScalars=true]),
    #"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"Date", type date}, {"Open", type number}, {"High", type number}, {"Low", type number}, {"Close", type number}, {"Adj Close", type number}, {"Volume", Int64.Type}})
in
    #"Changed Type1"

and here is a code with multiple Ticker Symbols that calls the above function (which is called #"Stock Switch")

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCgn2cVSK1YlWcvTxiQQzXEJcwbS7L5hyU4qNBQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Stocks = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Stocks", type text}}),
    #"Invoked Custom Function" = Table.AddColumn(#"Changed Type", "StockTable", each #"Stock Switch"([Stocks])),
    #"Expanded StockTable" = Table.ExpandTableColumn(#"Invoked Custom Function", "StockTable", {"Date", "Open", "High", "Low", "Close", "Adj Close", "Volume"}, {"Date", "Open", "High", "Low", "Close", "Adj Close", "Volume"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Expanded StockTable",{{"Open", type number}, {"High", type number}, {"Low", type number}, {"Close", type number}, {"Adj Close", type number}, {"Volume", type number}})
in
    #"Changed Type1"

 

[kcmuppet]

And if you want to use multiple stocks, you can create a table with the Ticket Symbols, and convert that into a function.
...

Hi - thanks for taking the time to upload your code here. When I try it I get an error:

DataFormat.Error: We couldn't parse the input provided as a Date value.
Details:
    9/26/2023

I guess this is something to to do with the source. Has yahoo changed it's code format perhaps? Is there a way to dynamically create those codes (or even do without them)?