Jump to content

gmelancon

Members
  • Posts

    3
  • Joined

  • Last visited

Profile Information

  • Favorite Area of Science
    Physics

gmelancon's Achievements

Lepton

Lepton (1/13)

0

Reputation

  1. The only issue with excel is that the method I used to write the macro meant it was too big to compile, so it had to be split up into 20 macros. Then scilab could not read a single excel file that had all 20 macros as well as the stock data. I could try OpenOffice, but if it uses a similar compiler, I imagine size will still be an issue. Also, Scilab is able to read the file format that excel uses (.xls), does OpenOffice spreadsheet also use that format? I do not know if Scilab can use a CSV file directly, but I can look into it. As for Visual Studio Express, does that use the same language as the one in excel macros? Isn't it limited in functionality? I have considered using something of the sort, and getting a module that allows for matrix mathematics, but I was unsure if it would have the same capabilities as the excel macro for downloading the data. Thanks With some tinkering, I believe I could get scilab to use a CSV the way I need it to.
  2. I am currently in the process of coding a program that will analyze stock data from approximately 800 stocks to make estimated predictions of the profitability and timeframe of the profit, for my personal use. My current setup involves an excel macro to download the data, then pulling it into scilab for analysis. With the amount of data involved, I can only put so much into the excel file before it overloads scilab's ability to read it, and so I have had to split the excel macros into 20 different files, with each having to be activated and saved individually. This is obviously less than ideal, although still better than manual analysis of each stock. My question is, is there a way to use scilab to get the data directly, and skip excel entirely? If not, then what are some methods of programming that would allow me to download the data, and manipulate that data with the use of matrices, preferably without having to manually code the matrices, such as Matlab or Scilab. Open source or otherwise free compiler systems/programming languages are preferred as well. I am a mechanical engineering student, not computer science, so I am not an expert, nor do I intend to be. I only need as much information as is required. Thanks in advance for any help you can offer, as it will greatly decrease the time I spend researching.
  3. I am an engineering student, but I would like to perform some experiments unrelated to my studies. I originally thought that getting liquid nitrogen would require a license, but a relative who works in the liquid air industry said that was not the case. So now that I can get my hands on liquid nitrogen fairly inexpensively, I just need the wire material. I would like something flexible enough to shape when room temperature, that only needs liquid nitrogen to become superconducting. My search has only led me to wires that need liquid helium. Any help, like a particular material to look for or a company to look at, would be appreciated. Thanks in advance
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.