Fidelity Data to Excel
Author: foolsgold
Creation Date: 7/2/2010 12:10 PM
profile picture

foolsgold

#1
How can I convert & transfer stock data in Wealth Lab or Active Trader Pro into an Excel spread sheet for further analysis?
thanks, Jon
profile picture

Eugene

#2
For instance, by Exporting data out of WL5 to ASCII/CSV readable by Excel.
profile picture

foolsgold

#3
Eugene, thanks for the rapid response. I have tried to figure out how to do this but am not familiar enough with WL5 nor where to find what I need to transfer to where!!! can you spare a few more minutes and provide me a bit more guidance? thanx
profile picture

Eugene

#4
Look, we can't know what exactly you're trying to transfer and to where. ;) Be specific please.

Also, there's a chance a visualizer for further analysis might already exist, or a .NET math library could be connected to analyze data - could you give us a hint what kind of analysis you're looking for?
profile picture

foolsgold

#5
Sorry about that. What I am trying to do is to select pairs of stocks/indicators for which I have data for on WP and export that data into an Excel spread sheet. I want compare two stocks/indicators to determine their correlation coefficients in price performance. For example this may help determine if one is a leading indicator of the other.

Currently I download my stock data from Fidelity. I don't know the file it goes into or how to convert and transfer it into an Excel spreadsheet for further analysis.
profile picture

Eugene

#6
That's what I thought - correlation is already available in WLP so no need for Excel or something:

Correlation in Community.Components
Correlation.Series in Community.Indicators

QUOTE:
I don't know the file it goes into or how to convert and transfer it into an Excel spreadsheet for further analysis.

Exactly in the location you specify in the code.
profile picture

foolsgold

#7
thank you for the help. you made it easy for me.
This website uses cookies to improve your experience. We'll assume you're ok with that, but you can opt-out if you wish (Read more).