Crodriguez
New Member
- Joined
- Nov 5, 2013
- Messages
- 1
Hi,
i have built a spreadsheet in excel 2010, which is linked to the msn money live stock quotes, this successfully refreshes with the standard market data. However is there a way to include new fields? I want to add a column for the 200day moving average, i think its available via yahoo finance but i dobt know how to link it.
also the workbook is link with vlookup to separate workbooks containing account statements with number of shares etc. this vlookup works until another user in the shared dropbox folder updates the account statement workbook and replaces saving with the same file name and sheet name. Any suggestions? It appears that the table array field no longer recognizes the workbook and i have to start from scratch....
any help or suggestions greatly appreciated!!
thank you,
C
i have built a spreadsheet in excel 2010, which is linked to the msn money live stock quotes, this successfully refreshes with the standard market data. However is there a way to include new fields? I want to add a column for the 200day moving average, i think its available via yahoo finance but i dobt know how to link it.
also the workbook is link with vlookup to separate workbooks containing account statements with number of shares etc. this vlookup works until another user in the shared dropbox folder updates the account statement workbook and replaces saving with the same file name and sheet name. Any suggestions? It appears that the table array field no longer recognizes the workbook and i have to start from scratch....
any help or suggestions greatly appreciated!!
thank you,
C